Order creation fails with error ORA-00001: unique constraint error related to XPKOM_ORDER_FLOW_COORDINATOR
(Doc ID 2478271.1)
Last updated on SEPTEMBER 20, 2021
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 126.96.36.199.11 and later 188.8.131.52.x patches. This issue has been addressed in all newer releases and in Patch 28847059: OSM INTERIM PATCH 184.108.40.206.14
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
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