Teleservice - EBS (MOSC)

MOSC Banner

Service Request Number Sequence (Initial Value)

edited Dec 12, 2012 2:13AM in Teleservice - EBS (MOSC) 1 commentAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Teleservice Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center