Last updated on MAY 04, 2016
Applies to:Oracle Fusion Enterprise Contracts Management Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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?
"You must enter a value in either the Original System Bill-to Customer Reference column or the Bill-to Customer Account Number column."
The issue can be reproduced at will with the following steps:
The error appears every time an invoice is created.
1. Run the below query from BI Data model.
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)
3. Go to Receivables -> Billing -> Manage Auto Invoice lines, update the lines with the values.
4. Resubmit the Auto Invoice import.
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