Procurement - EBS (MOSC)

MOSC Banner

Purging old records from fnd_attachment_documents table

edited Mar 16, 2018 5:05AM in Procurement - EBS (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center