My Oracle Support Banner

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

Last updated on NOVEMBER 03, 2021

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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