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 OCTOBER 17, 2017

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 for or Pension Calculations for Cash Balance, 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).
  

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