Could Not Perform Action: Return to CX Sales from CPQ Create Quote Window - JBO-26048: Constraint "MOO_OPTY_PK1" Is Violated During Post Operation "Insert" (Doc ID 2771206.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 11.13.21.01.0 version, CX Integration

The below error message is returned after clicking on "Return to CX Sales" Button from CPQ Create Quote window:

Could not perform Action: Return to CX Sales
During commerce integration Process ID: xxxxxxxx, Name: OSC - Create Revenue Items
An error occurred while communicating with the partner site.
Error message from the partner site:
JBO-29000: Unexpected exception caught: java.lang.RuntimeException, msg=oracle.jbo.DMLConstraintException: JBO-26048: Constraint "MOO_OPTY_PK1" is violated during post operation "Insert" using SQL statement "INSERT INTO MOO_OPTY(LOCK_ASSIGNMENT_FLAG,BDGTED_FLG,BU_ORG_ID,CHAMPION_FLAG,CONFLICT_ID,CREATED_BY,CREATION_DATE,SALES_METHOD_ID,CURR_STG_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,NAME,OBJECT_VERSION_NUMBER,OPTY_ID,OPTY_NUMBER,OWNER_RESOURCE_ID,STATUS_CD,SUM_REVN_ID,OPTY_CREATION_DATE,OPTY_CREATED_BY,OPTY_LAST_UPDATED_BY,OPTY_LAST_UPDATE_DATE,CURRENCY_CODE,CORP_CURRENCY_CODE,CURCY_CONV_RATE_TYPE,EFFECTIVE_DATE,ASSIGNMENT_IMPACTED_DATE,STATUS_CATEGORY,STATUS_CD_SET_ID,REGISTERED,QUOTED_FLAG,EXTN_ATTRIBUTE_CHAR003,EXTN_ATTRIBUTE_CHAR007,EXTN_ATTRIBUTE_CHAR010,EXTN_ATTRIBUTE_CHAR013,EXTN_ATTRIBUTE_CHAR016,EXTN_ATTRIBUTE_CHAR018,EXTN_ATTRIBUTE_CHAR020,EXTN_ATTRIBUTE_CHAR021,EXTN_ATTRIBUTE_CHAR022,EXTN_ATTRIBUTE_CHAR023,EXTN_ATTRIBUTE_CHAR025,EXTN_ATTRIBUTE_CHAR026,EXTN_ATTRIBUTE_CHAR027,EXTN_ATTRIBUTE_CHAR028,EXTN_ATTRIBUTE_CHAR030,EXTN_ATTRIBUTE_NUMBER009,EXTN_ATTRIBUTE_CHAR031,EXTN_ATTRIBUTE_CHAR032,EXTN_ATTRIBUTE_CHAR033) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51)"

Cause

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