When Running Periodic Processes or Pension Calculations for Cash Balances, Process Ends in Error "Already using maximum cursors"
(Doc ID 2153101.1)
Last updated on JUNE 07, 2023
Applies to:
PeopleSoft Enterprise HCM Pension Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running Periodic Processing or Pension Calculations for Cash Balance Accounts, the process ends with the error "Already using maximum cursors".
ERROR
-----------------------
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: GG100-SQL-CONNECT
Error Message : Already using maximum cursors
Stored Stmt : xxxxxxxxxxxxxx [Reported Stored Statement varies]
PAPCABAL:PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: DISCONNECT. Bypassing current action: ROLLBACK .
Terminating Program.
STEPS
-----------------------
1. Run Periodic Processing for Cash Balance for a large group or the full employee population (Navigation: Pension > Periodic Processes > Request Process).
OR
1. Run Pension Calculations for a large group or the full employee population (Navigation: Pension > Calculations > Request Calculation).
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |