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 JANUARY 31, 2019

Applies to:

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

Symptoms

On : 8.1.1.11 [23030] version, Client Functionality

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

EXPECTED BEHAVIOR
-----------------------
Attributes should be removed when deleted.

STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
Possible orphan records getting created.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.