Consolidated Bill Group Invoice Is Rejected With Reason Duplicate invoice number (Doc ID 2409331.1)

Last updated on APRIL 24, 2024

Applies to:

Symptoms

On : 12.2.4 version, Invoice

When attempting to interface invoice,
the following error occurs.

ERROR
-----------------------
Duplicate invoice number

Steps
---------------
Consolidate Bill Group functionality is used for generating the project invoices.

A. Generated the project invoices with Consolidate Bill Group which has multiple projects.( PRC: Generate Draft Invoices for a Range of Projects)
B. Consolidated Invoice got approved and released.
C. Ran PRC: Interface Invoices to Receivables and few projects got interfaced and few projects are rejected with ‘No Active Project Manager is present’
D. Ran ‘Auto Invoice Import’ in AR and processed successfully.
E. Now, business removed end date of Project managers and ran again interface PRC: Interface Invoices to Receivables and remaining projects are successfully interfaced.
F. Ran again ‘Auto Invoice Import’ in AR and rejected with “Duplicate invoice number” 
G. Ran PRC: Tieback Invoices from Receivables and all projects are accepted from receivables.
H. Now, Business has cancelled the same invoice because of some reason and transferred to AR.
I. Ran again ‘Auto Invoice Import’ in AR and rejected with 1) Transaction lines with the same transaction number have been separated by the grouping process, causing duplicate
Transaction numbers.

Changes

Cause

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