FEE-HELP Determination Fails with Max Cursor Error
Last updated on DECEMBER 01, 2017
Applies to:PeopleSoft Enterprise CS Student Financials - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
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.
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
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.
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