Wondering if anyone has faced a scenario where the request serial no reached to maximum of 99999. I believe, RSA is generating default of 5 digit sequence.
What will happen once maximum is reached?
I assume you are referring to the name of the CR.
Looking at T_AV_CHANGE_REQUESTS table:
The name column in the DB is of type VARCHAR2(256 BYTE)
The ID column is of type NUMBER
The following numbers can be stored in a NUMBER column:Positive numbers in the range 1 x 10-130 to 9.99...9 x 10125 with up to 38 significant digitsNegative numbers from -1 x 10-130 to 9.99...99 x 10125 with up to 38 significant digits
The following numbers can be stored in a NUMBER column:
Positive numbers in the range 1 x 10-130 to 9.99...9 x 10125 with up to 38 significant digits
Negative numbers from -1 x 10-130 to 9.99...99 x 10125 with up to 38 significant digits
Oracle Data Types
To answer your question: the number 99999 is not the maximum value.
Yes, I was mentioning about the CR name.
As I understand, the ID gets appended with the Prefix we mention in Request workflow and that becomes the Request Name.
Can we make some changes, to start the number which gets appended in Request Name with 7 digit as this will be inserted in table.
Even if we go ahead with 5 digits in request name, what will happen once 99999 numbers of request raised ? For example we have used RSA as prefix, so what will happen once RSA99999 request is raised ?
Hope I'm not making you confused
Retrieving data ...