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?
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