Contract Invoices Failing To Interface To Receivables (Doc ID 2129663.1)

Last updated on MAY 04, 2016

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0

Contract invoices failing to interface to Receivables

Auto invoice is failing with error "You must enter a value in either the Original System Bill-to Customer Reference column or the Bill-to Customer Account Number column."
What is to be updated on the contract or the customer so that these fields get populated automatically in the Auto Invoice interface tables?

ERROR
-----------------------
"You must enter a value in either the Original System Bill-to Customer Reference column or the Bill-to Customer Account Number column."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
The error appears every time an invoice is created.

Workaround steps:
1. Run the below query from BI Data model.

SELECT A.ORIG_SYSTEM_REFERENCE
FROM HZ_CUST_ACCT_SITES_ALL A
WHERE A.PARTY_SITE_ID IN ( SELECT B.PARTY_SITE_ID
                                               FROM HZ_PARTY_SITES B
                                               WHERE B.PARTY_ID IN (SELECT C.PARTY_ID
                                                                                    FROM HZ_CUST_ACCOUNTS C
                                                                                    WHERE C.ACCOUNT_NUMBER = '<account_number>'))

2. Get the values for the below fields (from above query)
OrigSystemBillAddressRef
OrigSystemBillCustomerRef

3. Go to Receivables -> Billing -> Manage Auto Invoice lines, update the lines with the values.

4. Resubmit the Auto Invoice import.

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