Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete a specific attachment file (unqiue DOCUMENT_ID) from linked to an item. API fnd_attach

Prateek MohanFeb 17 2019 — edited Feb 9 2021

Dear All,

I have custom OAF application where a record has 2 files linked to it.

I need to delete one of the files but the DELETE button is disabled on the webpage and I couldn't find a way to personalize the page to enable it again.

I came across fnd_attached_documents2_pkg.delete_attachments API but only takes Entity Name and PK1_value, which is same in my case for the two files.

The two files only differ in DOCUMENT_ID and ATTACHED_DOCUMENT_ID in fnd_attached_documents table.

pastedImage_6.png

Please advise if there is another API that I should be looking at or any alternate way?

Regards,.
Prateek
Comments
Post Details
Added on Feb 17 2019
#general-ebs-discussion
0 comments
156 views