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 MARCH 08, 2017

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)
AP_INVOICES_INTERFACE
Payables Open Interface (APXIIMPT)


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

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 hundreds of Community platforms