Import Contacts throws error The unique key for the column BATCH_ID,PARTY_ID is invalid. Enter a valid value. (Doc ID 2165499.1)

Last updated on JULY 27, 2016

Applies to:

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

Symptoms

Error when Importing Contacts:

"The unique key for the column BATCH_ID,PARTY_ID is invalid. Enter a valid value."

"The address associated with this party site already exists in the import batch or is associated with a different party site in the registry. Details: The address for party site should be unique. You can import duplicate party site addresses if the profile option ENABLE_BUSINESS_KEY_VALIDATION is set to N."

Changes

 Duplicate Identification process was run and if the duplicate Contacts (same name, 2 different OSRs) were merged the result is 1 Contact, 2 OSRs. Previously used source files with 2 Contacts, 2 Party IDs, 2 OSRs now throw an error as the 2 OSRs point to only 1 Contact/ 1 Party Id after the merge. In this case the merge did not Inactivate the 2nd OSR.

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