My Oracle Support Banner

Order creation fails with error ORA-00001: unique constraint error related to XPKOM_ORDER_FLOW_COORDINATOR (Doc ID 2478271.1)

Last updated on JANUARY 10, 2024

Applies to:

Oracle Communications Order and Service Management - Version 7.2.4 to 7.2.4 [Release 7.2]
Information in this document applies to any platform.
This issue only applies to customers on OSM 7.2.4.1.11 and later 7.2.4.1.x patches. This issue has been addressed in all newer releases and in Patch 28847059: OSM INTERIM PATCH 7.2.4.1.14

Symptoms

Order creation fails with an 'ORA-00001: unique constraint' error. As a result, OSM may fail to create orders, which may happen frequently or intermittently. The following error will appear in the OSM WebLogic server log files:

SQL Exception ORA-00001: unique constraint (ORDERMGMT.XPKOM_ORDER_FLOW_COORDINATOR) violated
ORA-06512: at "ORDERMGMT.OM_WF_API", line 2393
ORA-06512: at "ORDERMGMT.OM_WF_API", line 2612
ORA-06512: at "ORDERMGMT.OM_WF_API", line 3132

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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