Import Contacts throws error The unique key for the column BATCH_ID,PARTY_ID is invalid. Enter a valid value.
Last updated on JANUARY 03, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.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.
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