When trying to merge two accounts an error message is raised: Error - JBO-26048: Constraint "MOO_OPTY_U1" (Doc ID 2279010.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Customer has two Accounts involved within the Merge that have Opportunities with the same name.
Example: (Request Id = 300002422758126), there are two Opportunities with the same Name. When trying to merge two accounts, data steward gets an error message: Error - JBO-26048: Constraint "MOO_OPTY_U1"
As this is an Oracle validation rule, customer cannot customize this error message. Customer needs a more clear description, so data steward knows what to do as:
"The following error occurred: For one account, all associated opportunities need to have a unique name. Please update Opportunity name and retry to merge both 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