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 NOVEMBER 15, 2023

Applies to:

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

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