Duplicate serial number when creating CKTID type CLS using Adjustable System Wide Sequence Preference
Last updated on FEBRUARY 22, 2017
Applies to:Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
When using the following Preference for Service Request - Connection
Options for CLS Serial Number Generation: AS - Adjustable System Wide Sequence
And, if two users simultaneously (or, a few seconds apart) assign a CKTID, MSS is allowing duplicate serial numbers to be used.
Also no warning is issued that numbers are duplicated.
Checking the Organizations - CLS Prefix data, it shows the next number that should have been used was jumped.
The serial number is the same but if other parts of the circuit ID are different MSS can save it.
User 1: opens the CKTID screen from a PSR order
User 2: at the same moment user 1 had the CKTID screen open, open his cktid screen
User 2 opens his own CKTID screen to process an unrelated order
Now if both click OK at the same time or seconds apart they can get same serial number assigned and there is no way for them to know if that serial was already in use.
User checked at the CLS organization I can see that the next number should be for e.g. 100180 instead of 100179
And If I try to create a new cktid it will give the 100180 number. Number 100179 was lost.
Business find it not acceptable that the same serial number is used for different circuits.
Change the Preferences for Service Request - Connection:
Options for CLS Serial Number Generation:
NA - Non-Adjustable System Wide Sequence
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms