My Oracle Support Banner

'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 FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.