My Oracle Support Banner

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 08, 2018

Applies to:

PeopleSoft Enterprise HCM Pension Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When running Periodic Processing for or Pension Calculations for Cash Balance, the process ends with the error "Already using maximum cursors".

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.

1. Run Periodic Processing for Cash Balance for a large group or the full employee population (Navigation: Pension > Periodic Processes > Request Process).


1. Run Pension Calculations for a large group or the full employee population (Navigation: Pension > Calculations > Request Calculation).




To view full details, 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 a vibrant support community of peers and Oracle experts.