Customer Import Error - The combination of columns {COLUMN1} and {COLUMN2} must be unique in table {TABLE_NAME}. (Doc ID 2274957.1)

Last updated on APRIL 16, 2023

Applies to:

Symptoms

The following errors are encountered when trying to import customers:

The combination of columns {COLUMN1} and {COLUMN2} must be unique in table {TABLE_NAME}.
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 be unique in table 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
The combination of columns SITEUSE_ORIG_SYSTEM and SITEUSE_ORIG_SYSTEM_REF must be unique in table HZ_IMP_PARTYSITEUSES_T.

Cause

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