Order Getting Failed Due To ORA-00001: Unique Constraint (OSM_UCM.XPKOM_ORDER_INSTANCE) (Doc ID 2017787.1)

Last updated on JUNE 18, 2015

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 and later
Information in this document applies to any platform.

Symptoms

Order getting failed in OSM due to below error.

Fallout during Order/Revision Submission: Failed to create and start the order due to java.lang.RuntimeException:
com.mslv.oms.OMSException: encountered error starting orchestration caused by:ORA-00001: unique constraint (OSM_UCM.XPKOM_ORDER_INSTANCE) violated ORA-06512: at quot::OSM_UCM.OM_ORD_INST_PKGquot::, line 3772 ORA-06512: at quot::OSM_UCM.OM_ORD_INST_PKGquot::, line 2512 ORA-06512: at quot::OSM_UCM.OM_ORD_INST_PKGquot::, line 1880 ORA-06512: at quot::OSM_UCM.OM_HANDLER_PKGquot::, line 2609 ORA-06512: at line 1

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms