Unable To Update Reference Accounts Using Simplified Customer Upload Template. How to get Orig System Reference Values to Create Reference Account Using Simplified Customer Upload Spreadsheet? (Doc ID 2549673.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

When importing customer through simplified customer upload template, the job is completing with error. The customer has already been created and it is only needed to create Receivable account for each site.

 
ERROR
-----------------------
This combination of Source System and Account Number does not match any record in the Customers worksheet.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Receivables > Billing
3. Go to Customers > Upload customers using spreadsheet
4. Import the process
5. Reviewed the log and observed the error described appears

Changes

Cause

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