My Oracle Support Banner

Duplicate serial number when creating CKTID type CLS using Adjustable System Wide Sequence Preference (Doc ID 1988410.1)

Last updated on OCTOBER 23, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

PROBLEM DESCRIPTION:

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.


STEPS

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 IMPACT:

Business find it not acceptable that the same serial number is used for different circuits.

WORKAROUND:

Change the Preferences for Service Request - Connection:
    Options for CLS Serial Number Generation:  
         NA - Non-Adjustable System Wide Sequence

 

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.