R12:PA: Cannot Change Status of a Project: ORA-01000: Maximum Open Cursors Exceeded (Doc ID 2371145.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

Users are trying to set few project statuses to pending close. To do so the user ends date all the project resources.

The user decides to pending close a few projects at a stretch then there are multiple actions of project resource end dates and multiple actions of project status change to "Pending Close". After a while
the number of open cursor reaches the max allowed (800 in this instance) and the following exceptions appears:

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.PJI_REP_MEASURE_UTIL", line 1628
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:818)
at oracle.apps.pji.projperf.reporting.webui.ProjPrfCommonControllerImpl.safeInvoke(ProjPrfCommonControllerImpl.java:936)
at oracle.apps.pji.projperf.reporting.webui.RowColComboOverviewCO.processRequest(RowColComboOverviewCO.java:109)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:643)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1058)

Changes

Cause

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