My Oracle Support Banner

Customer Import Error: The combination of columns XXX_ORIG_SYSTEM and XXX_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_ XXX_T (Doc ID 2274957.1)

Last updated on FEBRUARY 22, 2021

Applies to:

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

Symptoms

On Oracle Fusion, 11.1.11.1.0 version, Using customer import, importing customers via spreadsheet (FBDI), get the following errors:

ERROR
-----------------------
The combination of columns PARTY_ORIG_SYSTEM and PARTY_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_PARTIES_T
The combination of columns PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM_REFERENCE must HZ_IMP_PARTIES_T.
The combination of columns SITE_ORIG_SYSTEM and SITE_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_PARTYSITES_
The combination of columns CUST_SITEUSE_ORIG_SYSTEM and CUST_SITEUSE_ORIG_SYS_REF must be unique in table HZ_IMP_ACCTSITEUSES
 


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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