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 SEPTEMBER 28, 2015

Applies to:

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

Symptoms

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.

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