My Oracle Support Banner

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

Last updated on AUGUST 04, 2020

Applies to:

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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.