My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2021

Applies to:

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



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.





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
 The problem has two flavors.

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