R12 After patch 23522569 Receive 'Error in main:ORA-01000: maximum open cursors exceeded' in Custom Process (Doc ID 2162657.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After patch 23522569, from Bug 23272292 - PA_RES_MANAGEMENT_AMG_PUB.DELETE_REQUIREMENTS PERFORMANCE ISSUE, the following appears in the log file for a custom process:

xxxxx_create_proj_open_req_pkg.create_requirementORA-01000: maximum open
cursors exceeded
Error in main:ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
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
R.Conc_Login_Id
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum
Routine AFPPRD has encountered a fatal error. ORA-00604: error occurred at
recursive SQL level 1
ORA-01000: maximum

They suspect the issue is with the API PA_RES_MANAGEMENT_AMG_PUB.CREATE_REQUIREMENTS

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