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: 

Doubt in request number

Highlighted
RRK_19
Regular Collector

Doubt in request number

Hi,

 

We have been trying to create requests in PPM thru 'Import Requests' report.

For instance:

- While create requests via Import Requests report, the requests number assigned is '35945'.

- But while creating requests normally (i.e. via browser), the requests number is '35920'

 

By question is, due to this will there be any problem arising in the future, as the numbers will be coinciding with each other at some point?

Has anyone faced this issue? Any suggestions

 

Thanks,

Roopesh Kumar

2 REPLIES
Jim Esler
Honored Contributor

Re: Doubt in request number

A PPM node reserves a group of request ids from the database sequence and caches them for use as needed. Several parts of the code do this independently so requests created via different paths do not use ids that are overall sequential. There is no danger of duplication of ids, though. A single id will not be used for more than one request. I believe the sequence is configured by default to allocate 20 ids at a time.

Celil
Esteemed Contributor

Re: Doubt in request number

Hi Kumar,

 

Please check ID sequence and publish the result and if it's ok or not with us:

select kcrt_requests_s.nextval from dual;

 

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

 

Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event