My Oracle Support Banner

R12:OIE Expense Report Export (APXEXPER) does not Create All Invoices, No Exception or Rejection Code, Status INVOICED, Invoice Stuck In AP_INVOICES_INTERFACE (Doc ID 874753.1)

Last updated on APRIL 26, 2023

Applies to:

Oracle Internet Expenses - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Expense Report Export (APXEXPER)
Payables Open Interface (APXIIMPT)


Find that Expense Report Export does not create invoices for some of the Expense Reports selected. However, these are not shown in the Exceptions list and there is no rejection code on the Expense Report.
The Expense Report status is updated to INVOICED but no invoice id is populated in the VOUCHNO field.

The Expense Report is present in the ap_invoices_interface table (and in the interface lines table) but the invoice has not been imported.

The issue can be reproduced at will with the following steps:
1. Run Expense Report Export
2. Review the log file, some of the selected expense reports are not created as invoices, they do not appear in the Exceptions list .

Note in the Expense Report Export log file where it refers to Call Payables Open Interface
Expenses Fetched = <a higher number> than  
Invoices Created = <a lower number>


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

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

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