The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Reset ID request number

SOLVED
Go to solution
Highlighted
esteri
Super Collector

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
Honored 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
Frequent Visitor
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
Super Collector

Re: Reset ID request number

It does work!

 

Thanks for your help,

Ester

Marc Canovas
Occasional 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
Frequent Visitor

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..
//Add this to "OnDomLoad" event