Importing Customers Via Spreadsheet, Get The Following Errors: The combination of columns PARTY_ORIG_SYSTEM and PARTY_ORIG_SYSTEM_REFERENCE must be unique in table HZ_IMP_PARTIES_T (Doc ID 2274957.1)

Last updated on JUNE 08, 2017

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
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From Scheduling Processes, Load Interface for Import
-> Receivables > Import Process:
  --- >>>> Import Trading Community Data in Bulk
  --- >>>> Data File: The zip file imported

2. Go to Navigator -> Customer Data Management ->
  - Select the Batch Identifier
  - Go to batch -> Actions -> Import
3. Review the log and observed the errors described appear


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