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 |