To attach a data file to an Invoice existing in Oracle Receivables using an automated process.

REQUIREMENT:

To attach a data file to an Invoice existing in Oracle Receivables using an automated process. Currently the only way to attach documents to AR Invoices is using Oracle Applications front end. The requirement is to place a file on operating system and Network drive and attach it the the invoices using an automated process (like some plsql code, concurrent program, API). As far as I know there are three tables which are being hit when storing an attachment to Invoice. These are select * FROM FND_ATTACHED_DOCUMENTS FAD where FAD.PK1_VALUE = 1153163(pki_value is customer_trx_id) ; -- find document_id = 1011405 select * FROM FND_DOCUMENTS_TL FDT where document_id = 1011406; --- find media_id = 786686 select * FROM FND_LOBS FL