My Oracle Support Banner

Performance Issue Related To Cascade Delete Assoc And Audit Trail (Doc ID 2281787.1)

Last updated on MAY 15, 2023

Applies to:

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

Symptoms

On : 8.1.1.14.9 [IP2014] version, Client Functionality

ACTUAL BEHAVIOR
---------------
Performance issue related to Cascade Delete Assoc

 child action record got deleted and Action Delete captured in audit, even though Audit not enabled for Action BC and Action Clone BC not there under Account BO

EXPECTED BEHAVIOR
-----------------------
child action record should not get deleted and Action Delete should not capture in audit

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Account BO
2. Action BC under Account BO
3. Account/Action link with Cascade Delete = None
Note:- Make sure that there is no other link with Cascade Delete = Delete
4. Create new clone BC : Action Clone
5. Create new link between Account/Action Clone with Cascade Delete = Delete
Note:- don’t add this cloned BC under Account BO
6. Enable audit trial for child BC Action Clone under Account BC
7. Do clear audit cache
8. Compile all the changes
9. Create Account
10. Drill down on account and create Activities under this account
11. Now delete the account



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.