My Oracle Support Banner

R12: OIE: Expense Report Attachments Are Missing After Expense Report Export Process (Doc ID 2983175.1)

Last updated on OCTOBER 25, 2023

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Issue is with expense report attachments in IExpense.
Images are stored in WebCenter.
Using APIs to attach images to Expense report.
APIs used to make the attachments;
fnd_documents_pkg.insert_row
fnd_attached_documents_pkg.insert_row
Expense report attachments are attached to the expense report, and they exist in FND_DOCUMENTS

After running the Expense Report Export process, attachments are no longer available in the expense report.

When adding the attachments via the Expense Entry OAF page, the attachments can still be seen after Expense Report Export process is run.

Steps:
1. Store images in WebCeneter.
2. Call APIs fnd_documents_pkg.insert_row and fnd_attached_documents_pkg.insert_row to have the images attached to the Expense Report.
3. Process the expense report so it’s ready to be transferred to Payables.
4. Run the Expense Report Export concurrent process.
5. Open the expense report and it no longer shows as having an attachment.

 



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.