RAXTRX: Project Invoices Rejected During AutoInvoice Import with Duplicate Invoice Number (Doc ID 2193265.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

Invoices are generated in PA (Project Accounting) with duplicate invoice numbers.  They are interfaced to Oracle Receivables without any issues and when Auto Invoice Import is run the following errors appear in the output:

This also occurs with the following scenario: 

Duplicate invoice numbers appear on invoices for multi-customer projects. It appears that this has to do with the order of processing unapproved drafts.

User starts by approving the drafts for a multi-customer project, saving after all drafts for this project have been approved.
Then the user releases the first draft and saves.
User gets an error message that states: "Need to approve/release all draft invoices having the same set".
However, after clicking OK users are allowed to release and save the next draft. This results in a duplicate Accounts Receivable (AR) Invoice Number.
User realizes that this is not the proper way to process multi-customer drafts.

Reproduce By Steps

1.  Use the Receivables forms responsibility

2.  Navigate to Interfaces/AutoInvoice

-or-

1.  Use the Receivables forms responsibility

2.  Navigate to Other/Requests/Run

3.  Select PRC: Submit Interface Streamline Processes

4.  Choose Streamline Option X!: Interface Draft Invoice to AR 

Cause

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