AnsweredAssumed Answered

Update Timesheet ID sequence

Question asked by fabricio.de.marchi on Aug 16, 2011
Latest reply on Aug 18, 2011 by fabricio.de.marchi
Hi,

We have a case where we need to update the Timesheet ID being created by
Clarity.

We would like to update the sequence used by Clarity to number the Timesheets
(PRTIMESHEET.PRID field).

Just to be crystal clear, this is not a customized sequence, this sequence
comes with Clarity and we have never touched it.

This is the script of that sequence:
CREATE SEQUENCE APP_NIKU.PRTIMESHEET_S1
START WITH 6053600
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;

We want to increase the current number. It will be a one time change just to
adjust that number.

We need to know if there is any concerns with that change? Could it impact something in the system if we stop the Clarity applications, including the background server, and recreate that sequence with a higher number?

Thanks,

Fabricio

Outcomes