Highlighted
Absent Member.
Absent Member.
680 views

Reset ID request number

Jump to solution

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!

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.
Absent Member.
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

View solution in original post

0 Likes
5 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

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

 

alter sequence kcrt_requests_s increment by 2000

0 Likes
Highlighted
Absent Member.
Absent Member.
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

View solution in original post

0 Likes
Highlighted
Absent Member.
Absent Member.

It does work!

 

Thanks for your help,

Ester

0 Likes
Highlighted
Absent Member.
Absent Member.

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

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..
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..
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.