My Oracle Support Banner

OSM Database column OM_ORDER_FLOW_COORDINATOR.COORD_SET_ID Over 2 Billion (Doc ID 2299183.1)

Last updated on MARCH 31, 2023

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

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
Symptoms
Changes
Cause
 The problem has two flavors.
Solution
References

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