When Files Are Deleted All Affected Objects Are Also Deleted. (Doc ID 2805002.1)

Last updated on SEPTEMBER 11, 2021

Applies to:

Symptoms

When files are deleted, all affected objects are also deleted

Expected Behavior:

When deleting T_PAC_MUL entry using C_ID_2, C_ENTITY should also be checked to avoid deleting other entries with different C_ENTITY.

 

Steps to reproduce :

1.  Login Java Client
2. Create a stored document and attach a file
3. Create a project
4. Use SQL Developer to access to the database and find out the C_ID of the attached file in Step 2, e.g. 100000  
5. Go back to Java Client and delete the file from the stored document
6. Clean the trash
7. Check the folder and find both the file and the project are removed
8. Check T_PAC_MUL table and find out two records with the same C_ID_1 and C_ID_2 have been removed.

      The issue is that deleting the file will also remove the project from the folder if the project is with the same C_ID as the file.

Cause

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