Find How Many Order IDs Are Left In OSM (Doc ID 750593.1)

Last updated on JUNE 19, 2017

Applies to:

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

Goal

When using a partitioned OSM / Provisioning / OMS schema, the available order IDs will be limited by the (previously created) partitions. This note provides sample code which you can run manually to check the need to create new partitions or you can adapt it into your own monitor codes to automate warning notifications.

Risk

If you do not create new partitions, eventually the limit will be met and no new orders can be created.

Recommendation

It is recommended that available Order ID should be checked weekly (even daily if many new orders are created each day) to prevent new order cannot be created due to new Order ID reaches highest partition limit.

Solution

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