'SEVERE ERROR(14645,999) PI() Program(SRPCWLPR)' on Wait List Process when Enrollment Request Detail Sequence Number > 9999

(Doc ID 2353808.1)

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.

Symptoms

ISSUE STATEMENT
---------------
When running the Waitlist process against the entire term, the process takes over 4 hours and sometimes returns the following error:
 
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.
 
STEPS
---------------
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.

Cause

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