OSM Database column OM_ORDER_FLOW_COORDINATOR.COORD_SET_ID Over 2 Billion

(Doc ID 2299183.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

 

This bug impacts customers using amendment processing (order revision or cancellation) as one of the DB Stored Procedure used by OSM for amendment processing will fail when OM_ORDER_FLOW_COORDINATOR.COORD_SET_ID exceed 2.147 billion with the following exception.

OSM is then unable to process any amendments for any orders with this overflow condition. This can potentially impact a very large number of orders. This KM Note provides mechanism to check your system.

 

Changes

 

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