My Oracle Support Banner

Autoinvoice: Importing Transactions with the Same Consolidated Billing Error - 'The Imported Billing Number You Entered Already Exists In The System (Doc ID 1575721.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.


You are importing invoices having a Consolidated Billing Number and receive the following error:

The Imported Billing Number you entered already exists in the system. Please enter a unique Imported Billing Number

The cut-off date is weekly, ending every Friday. So the following is the scenario based on these conditions:

There is a validation in Oracle that prevents from loading duplicate CONS_BILLING_NUMBER into the table AR_CONS_INV_ALL. But the business scenario is below.

1.  You have defined a customer (just with only one billing site) as a Friday Billing customer.
You will be generating Consolidated bills every Friday.
You have defined the BFB payment term and a BFB cycle for Friday and all the association has been completed.

2.  The customer receives five (5) invoices on Monday and you generate five (5) transactions with one summary bill number in the RA_INTERFACE_LINES_ALL table and run the autoinvoice program. This will create five transactions with Friday Billing date and enter the corresponding values in the AR_CONS tables.

3.  On Tuesday, you still receive five more invoices for the same customer for the same BILL TO Site.
You want to create the five transactions with the same summary bill number. This is because, the transactions need to get into the same billing cycle (i.e.. Friday) and one Consolidated Billing number needs to get generated on this Friday.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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