Purging old records from fnd_attachment_documents table
Dear Procurement Guru:
I'm sure you all aware that all our Oracle application attachment from iExpense (receipts,etc...) iProcurement(supplier contracts, SOW, other legal documents) all are stored in the
table called FND_ATTACHED_DOCUMENTS. Also, there is a view called FND_ATTACHED_DOCS_FORM_VL that house all EBS application attachment documents.
My question is since this table and view growing so fast and so big I was looking to see if there is a way we can remove/delete our old attachments from this table?
Currently, we have about 35 Million rows in the FND_ATTACHED_DOCS_FORM_VL view and about 1 Million rows in the FND_ATTACHED_DOCUMENTS table.