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

Last updated on JUNE 05, 2023

Applies to:

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

Changes

Cause

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