Agreement Item Attributes (S_AGREE_ITEM_XA) Are Not Removed When Deleting Service Agreement

(Doc ID 1984065.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version [23030] and later
Information in this document applies to any platform.


On : [23030] version, Client Functionality

Agreement Item Attributes (S_AGREE_ITEM_XA) are not removed when deleting Service Agreement

Attributes should be removed when deleted.

The issue can be reproduced at will with the following steps:
1) Go to Agreements screen
(To be sure this is our configuration for this screen:
Screen: Agreement Screen
View: Agreement List View
Business Object: Service Agreement
Applets:Applet[0]: Agreement List Applet No Parent; Applet[1]: CUT Agreement Detail Applet No Title;
Business Components: BusComp[0]: Service Agreement; BusComp[1]: Service Agreement;)
2) Find Agreement with any agreement item attributes or create new one
3) Retrieve using SQL ids of these attributes e.g. using following SQL:
select * from siebel.S_DOC_AGREE agr
join siebel.s_agree_item agit on agit.doc_agree_id = agr.row_id join siebel.s_agree_item_xa xa on agit.row_id = xa.agree_item_id
where agr.row_id = '';
4) Remove Agreement from current screen and view
5) Verify that Agreement Item Attributes are still present on DB (table S_AGREE_ITEM_XA) - this is problem - they should be deleted (cascade delete) along with agreement items.

Possible orphan records getting created.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms