My Oracle Support Banner

Orphan Records Remain When Deleting Attachments (Doc ID 2716569.1)

Last updated on OCTOBER 06, 2020

Applies to:

Oracle Purchasing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Actual Behavior
On Purchase Order form, when attachment is deleted, the following message is shown;

Delete only attachment or delete both document and attachment ?

If "Attachment" is selected, the records are deleted from FND_ATTACHED_DOCUMENTS, but not from other related tables like, FND_DOCUMENTS_TL, FND_DOCUMENTS and FND_LOBS etc.

Expected Behavior
All the related records are deleted since documents are only accessible through the attachment record.

Steps to Reproduce

  1. Navigate to Purchase Orders form.
  2. Click Attachment Icon.
  3. Select the row and click delete button.

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.