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

Last updated on MAY 15, 2023

Applies to:

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

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