My Oracle Support Banner

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.