Diagnostic Scripts - RGRXFR FSG Transfer Gives ORA-01000: Maximum Open Cursors Exceeded (Doc ID 135933.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 10.7 to 11.5.10.2 [Release 10.7 to 11.5.10]
Information in this document applies to any platform.
Executable:RGRXFR - Program - FSG Transfer

Symptoms

The FSG Transfer program is completing in error with the following message:

ORA-01000: Maximum Open Cursors Exceeded

Is there a script that can be run to determine how many open cursors exist and what is causing the open cursors?

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