This content has been marked as final. Show 4 replies
jtowns wrote:Check the max value of FND_CONCURRENT_REQUESTS_S sequence -- In 11i/R12, it is 2000000000
Just wondering where the concurrent request IDs start e.g. 0,1, or 10000 and where they "tick over". E.g. is it at 9999999, 99999999 or higher.
I've got a feeling they start with four or five digits perhaps at 1000, but I haven't been able to uncover a direct reference in the manuals or on the Support site. I don't think the maximum size in the table FND_CONCURRENT_REQUESTS is the whole story but may be wrong.
Oh, I'm talking about an 22.214.171.124 instance in my case, but would be interested in the case for 12 too.
Yes 2,000,000,000 is the top number here too.
Confirming the sequence FND_CONCURRENT_REQUESTS_S is called by Package FND_REQUESTS in 126.96.36.199,which is defined as:
CREATE SEQUENCE AOL.FND_CONCURRENT_REQUESTS_S
START WITH 2678691 <- Our current nextval
MAXVALUE 2000000000 <- max so 10 digits possible
MINVALUE 1 <- min, so starts at one digit
Interesting that it's set not to start again once we hit the maxvalue (NOCYCLE), must have to recreate the sequence with a new start value when it's close to ticking over.