R12: OIE: More Than One Invoice Was Created in Payables from a Single Expense Report (Doc ID 1228553.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.1 and later
Information in this document applies to any platform.
Expense Report Export (APXEXPER)

Symptoms

On : 12.1.1 version,

Although some expense reports are imported to AP, they are imported multiple times and have generated more than one invoice in Payables.  In addition imported expense reports  may be reported as Rejected during subsequent submissions of Expense Report Export with a rejection reason of Duplicate Invoice Number even though the invoice has already been correctly created during the first concurrent request.


In the Audit Information for Expense Report the Status does not show as “Invoice Created” and “Paid” . These check marks are not present. However, in Invoice workbench at least one of the invoices for the Expense Report shows Validated and Paid.

NOTE: This issue only occurs under the condition that the Expense Report Export concurrent program was run for the same org_id at the same time (in this case twice) resulting in a problem in which there is no correct updating of the vouchno and reject code during the second concurrent request run.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Export an ER
2. In Audit view the AP Status for “Invoice Created” and “Paid” are NOT checked
3. In invoice workbench in the Payables responsibility the invoice for the ER is Validated and Paid.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Expense Reports may be exported and paid many times

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