Account Merge Request Failed - Constraint "MOO_OPTY_U1" is violated during post operation (Doc ID 2230639.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Customer has submitted a Duplicate Resolution Request job that is unsuccessful with this error message:
An error occurred when running the merge service.
Check the server log file for more information.: JBO-26048: Constraint "MOO_OPTY_U1" is violated during post operation "Update" using SQL statement "UPDATE MOO_OPTY OpportunityEO SET CUST_PARTY_ID=:1,SALES_ACCOUNT_ID=:2 WHERE OPTY_ID=:3".

The issue has the following business impact:
Due to this issue customer is unable to run the merge request for the selected accounts.

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