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:
Oracle Advanced Collections - Version 12.1.3 and laterInformation 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 |