Customer Import Error - CUST_ORIG_SYSTEM and CUST_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_ACCOUNTS_T

(Doc ID 2329923.1)

Last updated on NOVEMBER 19, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms


While importing the customer we are getting the below error. We are using the simplified template and attached the customer template.

Accounts

The combination of columns CUST_ORIG_SYSTEM and CUST_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_ACCOUNTS_T

ERROR
-----------------------

The combination of columns CUST_ORIG_SYSTEM and
CUST_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_ACCOUNTS_T.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import Customers using Upload Customer spreadsheet

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import customers.

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