FEE-HELP Determination Fails with Max Cursor Error (Doc ID 1927303.1)

Last updated on NOVEMBER 23, 2015

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

The FEE-HELP Determination fails for a large number of students. The failure only occurs for students which use OEE (Open Entry/Open Exit Enrollment). If the process is run for a smaller subset of OEE students it will run successfully.

FEE-HELP Determination runs successfully for a large group of students which use regular enrollment.


ERROR
-----------------------
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: GG100-SQL-CONNECT
Error Message : Already using maximum cursors
Stored Stmt : SFPCFHLP_S_FHLPPAY


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Student Financials, Tuition and Fees, Australian Loan Processing, Process FEE-HELP Determination;
2. Select a run control;
3. Populate the run control for students in OEE Classes
4. Submit the process to the process scheduler.

Please also visit these valuable Campus Solutions sites: Community  Newsletters  Information_Centers  Maintenance_Advisor 

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