'SEVERE ERROR(14645,999) PI() Program(SRPCWLPR)' on Wait List Process when Enrollment Request Detail Sequence Number > 9999
Last updated on JANUARY 26, 2018
Applies to:PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.
When running the Waitlist process against the entire term, the process takes over 4 hours and sometimes returns the following error:
> 2015-08-24-04.41.01.380000 SEVERE ERROR(14645,999) PI() Program(SRPCWLPR)
PTPSQLRT error in: INSERT I-ERDT.
This issue occurs when the Bind-2 value reaches 9999 and then begins again at 0. Bind 2 correlates to the ENRL_REQ_DETL_SEQ number in the ENRL_REQ_DETAIL record.
The issue can be reproduced with the following steps:
1. Run the waitlist process against the entire term where there are more than 23000 rows to be processed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms