RAXMRG Customer Merge Errors With Unique Constraint (AR.HZ_CUST_ACCT_SITES_U2) Violated (Doc ID 2270108.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Trading Community - Version 12.2 and later
Information in this document applies to any platform.

Symptoms


While running "Customer Merge" concurrent program, the following error is encountered.

ERROR
---------
MSG-00001: create_same_sites:create_account_site ERROR The following SQL error occurred:
ORA-00001: unique constraint (AR.HZ_CUST_ACCT_SITES_U2) violated.**CREATE_ACCOUNT_SITE**
MSG-00001: ARP_CMERGE_ARCUS.create_same_sites : User-Defined Exception


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