My Oracle Support Banner

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 JANUARY 03, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.