This content has been marked as final. Show 4 replies
1. Attachments. Check out:
for some info on attachments.
The tables that are hit by a given attachment is there.
Plus potentially use fnd_documents_pkg.delete_row to remove your attachments.
2. Standard functionality for Print PO does not store the .pdf with the PO, but .pdf is not standard functionality. The .pdf is usually stored in the filesystem $APPLCSF/$APPLOUT which can be purged using O/S methods, plus the Purge Concurrrent Requests to remove the database request information.
Using fnd_documents_pkg.delete_row seems a bit scary. Have you thought of posting an example on your blog on how the fnd_documents_pkg.delete_row might look? It would have to clean it out from fnd_lobs as well.
Anyway...thank for your input.
Scary? Maybe ... that was what you asked for !
Yes ... think I'll have to try the delete and update the blog. On my list of things todo amongst many more ;-)
Just an FYI, we found a package called fnd_attached_documents2_pkg that contains an API for deleting attachments. We're not really sure how it to use it yet, but we'll let you know if we figure it out.
Meanwhile, any additional advice is much appreciated!