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 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 and later patches. This issue has been addressed in all newer releases and in Patch 28847059: OSM INTERIM PATCH


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

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