Project and Portfolio Management Practitioners Forum
cancel

Reset ID request number

SOLVED
Go to solution
Highlighted
esteri
Trusted Contributor.

Reset ID request number

Hi!

 

I am Ester and I have working with PPM 9.13.

 

We need to reset the ID request numbers and we don't know how we can do it.

 

For example, the next ID request number that our PPM will assign automatically when a request is created will be 1233. But we need to reset this ID number to start the accounting in a particular number, for example 20000.

 

Is it possible to do it? Someone has done this before?

 

Thanks in advance and regards!

5 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Reset ID request number

Use ALTER SEQUENCE...for example, to shift it up by a count of 2000:

 

alter sequence kcrt_requests_s increment by 2000

d4y4n4
Honored Contributor.
Solution

Re: Reset ID request number

Hi,
The ID's are based on the Oracle sequence kcrt_requests_s.
In this case you would have to change the start value, update this sequence. Make sure that this number is greater than the highest number already stored for Request ID in kcrt_requests table. Following is syntax of one way to change the sequence: alter sequence kcrt_requests_s increment by

Regards,
Dayana Campos
esteri
Trusted Contributor.

Re: Reset ID request number

It does work!

 

Thanks for your help,

Ester

Marc Canovas
Valued Contributor.

Re: Reset ID request number

Hi!

 

I was wondering if there is a way to set the range of Request ID's depending on the Request Type, i.e., that projects requests start at 35000, risks requests at 40000, scope changes at 45000...

I'm looking for it but I can't fins any info on this issue.

 

Thank you,

 

 

Marc

Mohit_Agrawal
Outstanding Contributor.

Re: Reset ID request number

Hi Marc,

This is all done by the corresponding sequences. To see the existing ranges and start values...go to the corresponding sequence and check it...and to create/alter any sequence, below is the syntax:

CREATE SEQUENCE Seq_Name
START WITH 35000
INCREMENT BY 1
CACHE 20;

seq_name.nextval returns 35000, the second value would be 35001..and so on...

Thanks!!
Mohit Agrawal
::Please mark KUDOS if this helps..