Service Request Number Sequence (Initial Value)
Hi,
Service request number are not in sequential order so that we need to run the folllowing alter sequence command
SEQUENCE_NAME INCREMENT_BY CACHE_SIZE
------------------------------ ------------ ----------
CS_INCIDENTS_NUMBER_S 2 100
CS_INCIDENTS_S 2 100
alter sequence CS.CS_INCIDENTS_NUMBER_S INCREMENT BY 1 NOCACHE
But after one patch is applied to system, increment by is changed to 2 again. We need to run alter sequence to change increment by to 1 from 2. But service request number should start where it left off.
How can define next service request number? (sequence last number)
Best Regards,