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 DECEMBER 22, 2020
Applies to:Oracle Fusion Sales Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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."
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.
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