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:

Symptoms

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>

Cause