Internal OSM Exceptions For Orders -Integrity Constraint (ORDERMGMT722_1037.FK_OM_ORDER_FLOW_03) Violated - Parent Key Not Found

(Doc ID 2313312.1)

Last updated on NOVEMBER 10, 2017

Applies to:

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

Symptoms

On : 7.2.2 version, Database

You are continuously getting the below error in OSM server log.


ERROR
-----------------------
Error 1: ORA-02291: integrity constraint (XXXX.FK_OM_ORDER_FLOW_03) violated - parent key not found

<osm01_01> <[ACTIVE] ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'> ORA-06512: at "OSM_PROD.OM_WF_API", line 2274
ORA-06512: at "OSM_PROD.OM_WF_API", line 5717
ORA-06512: at "OSM_PROD.OM_WF_API", line 4674
ORA-06512: at "OSM_PROD.OM_HANDLER_PKG", line 456
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