Error: 'ORA-01000: maximum open cursors exceeded' for Concurrent Request - IEX: Child Send Dunning for Delinquent Customers (Doc ID 2819136.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

Concurrent Request - 'IEX: Child Send Dunning for Delinquent Customers' completing with below error:

ORACLE error 1000 in AFPRSR

Cause: AFPRSR failed due to ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.FND_CONC_PRIVATE_UTILS", line 132

The SQL statement being executed at the time of the error was: and was
executed from
ORA-01000: maximum open cursors exceeded

Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open cursors
exceeded

Contact your system administrator or support representative.

Shutting down Concurrent Manager : 12-MAR-2021 11:09:11
ORACLE error 1000 in AFPRSR

Cause: AFPRSR failed due to ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.FND_CONC_PRIVATE_UTILS", line 132

The SQL statement being executed at the time of the error was: select
FND_CONC_PRIVAT

List of errors encountered:
.............................................................................

_ 1 _
Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open
cursors exceeded

Contact your system administrator or support representative.

_ 2 _
Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open
cursors exceeded

Contact your system administrator or support representative.
.............................................................................

STEPS TO REPRODUCE
==================
--Submit IEX: Child Send Dunning for Delinquent Customers' concurrent program
--It fails when run for a large volume of data.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.