OM_ORDINST_VALUE_PKG.GET_NODE_VALUE_LIKE Input Parameters Changed Causing Orders Stuck In Delayed Timer Task (Doc ID 2269257.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Communications Order and Service Management - Version 7.2.4 to 7.3.5.0.0 [Release 7.2 to 7.3.0]
Information in this document applies to any platform.

Symptoms

All orders are getting stuck at delay timer when upgraded from OSM 7.2.2 to 7.2.4.

The delay timer is executing a sql which is referring a function OM_ORDINST_VALUE_PKG.GET_NODE_VALUE_LIKE.

In OSM 7.2.2 this function has a different definition than 7.2.4.

An additional argument "A_PATH_ID" needs to be passed to this function in OSM 7.2.4



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