My Oracle Support Banner

IEX: Child Send Dunning For Delinquent Customers Concurrent Program Ending In Error: ORA-01000: maximum open cursors exceeded (Doc ID 2770845.1)

Last updated on APRIL 28, 2021

Applies to:

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

Symptoms

The concurrent request - 'IEX: Child Send Dunning for Delinquent Customers' is ending 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.

 

Steps:
Responsibility: Collections
Navigation: View menu > Requests > Submit a New Request

1. Submit concurrent program - IEX: Child Send Dunning for Delinquent Customers
2. Monitor the job for completion



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
References


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