Autoinvoice: Importing Transactions with the Same Consolidated Billing Error - 'The Imported Billing Number You Entered Already Exists In The System
Last updated on SEPTEMBER 28, 2015
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 (#1001 to #1005) with one summary bill number (#2001) 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 (#1006 to #1010) with the same summary bill number (#2001). 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms