My Oracle Support Banner

How to resolve the error - Unique Constraint (FUSION.MOO_OPTY_U3) Violated On Create Opportunities (Doc ID 2010189.1)

Last updated on MARCH 23, 2019

Applies to:

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

Goal

On : 11.1.9.2.0 version, Opportunity Management

error ORA-0001: unique constraint (FUSION.MOO_OPTY_U3) violated on Create Opportunities

We are getting an error when creating an Opportunity, through Opportunity Object and Lead Conversion. ERROR: ORA-0001: unique constraint (FUSION.MOO_OPTY_U3) violated
- We noticed the error happens all the time when we create a lead in EUR or GBP and try to convert that Lead to an Opportunity
- Seems like the error happens randomly when trying to enter an Opportunity through Opportunity Object.
- We have to cancel, then it seems like the second time you try to enter the opportunity it goes through.

 

 

 

Solution

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
Goal
Solution
References


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