Cascade Delete Does Not Work Between BusComps Based On A Same Table (Doc ID 2778388.1)

Last updated on APRIL 29, 2022

Applies to:

Symptoms

Child records are not deleted when Cascade Delete is enabled  on the link between BusComps based on a same table.

STEPS
-----------------------
The issue can be reproduced at will with the following configuration steps:
1. Create a Table:

4. Create a Business Object with BusCompA and BusCompB connected by link BusCompA/BusCompB.

5. Create Applets A and B (class CSSFrameList), based on BusCompA and BusCompB respectively.

6. Create a View AB with applets A and B.

7. Create a new Screen AB and add the View AB to it.

8. Add the Screen AB to the Application.

9. In Administration Application --> View add the view AB. Add Responsibility of SADMIN user.

10. Test case:
a- Log in Application and navigate to view AB.

b- Press Delete button (method DeleteRecord) on record in Applet A.

c. Parent record gets deleted.

d. Login to DB Client, SQL Plus, and query for the child record.

e. The child record is not deleted.

Cause

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