0 Replies Latest reply: Jul 29, 2014 9:38 AM by user610548 RSS

    Getting Error "ORA-01000: maximum open cursors exceeded" from <oracle.apps.fnd.ext.common>

    user610548

      We have Oracle EBS 12.1.3 integrated with ADF 12.1.2 deployed on WLS 12.1.2 server. We have used the Patch 13882058 (Doc ID 974949.1) to complete this integration. Right now we are getting "ORA-01000: maximum open cursors exceeded" error in the adf managed server logfile. The steps to reproduce the problem are as follows :

      a) Login to EBS

      b) Click on Responsibility

      c) Responsibility will redirect to the ADF application

      d) The Application contains a web-page  , you put the item/description in the first line it will fetch corresponding details from the EBS , as you go to next line to enter a new product/description , we see below

      #############################################################################################  Error Stack Begins #################################################################################################

      <Jul 28, 2014 9:29:32 PM EDT> <Error> <oracle.apps.fnd.ext.common> <BEA-000000> <FATAL SQLException error while executing FND_PROFILE.VALUE_SPECIFIC()

      java.sql.SQLException: ORA-01000: maximum open cursors exceeded

      ORA-06512: at "APPS.FND_CACHE_VERSIONS_PKG", line 17

      ORA-06512: at "APPS.FND_PROFILE", line 171

      ORA-06512: at "APPS.FND_PROFILE", line 3663

      ORA-06512: at "APPS.FND_PROFILE", line 3764

      ORA-06512: at line 1

       

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3770)

      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3955)

      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

      at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:101)

      at oracle.apps.fnd.ext.common.ProfileDirectory.getSpecificProfileFromDB(ProfileDirectory.java:222)

      at oracle.apps.fnd.ext.common.ProfileDirectory.newValueInstance(ProfileDirectory.java:77)

      at oracle.apps.fnd.ext.common.ProfileDirectory.newValueInstance(ProfileDirectory.java:32)

      at oracle.apps.fnd.ext.common.EBizDirectory.getInstance(EBizDirectory.java:106)

      at oracle.apps.fnd.ext.common.ProfileDirectory.getSpecificProfile(ProfileDirectory.java:440)

      at oracle.apps.fnd.ext.common.ProfileDirectory.getSpecificProfile(ProfileDirectory.java:390)

      at oracle.apps.fnd.ext.common.EBiz.init(EBiz.java:188)

      at oracle.apps.fnd.ext.common.EBiz.<init>(EBiz.java:182)

      at xxlcb.apps.ldp.dashboard.view.session.EbizUtil.getEBizInstance(EbizUtil.java:177)

      at xxlcb.apps.ldp.dashboard.view.session.EbizUtil.validateEBSSession(EbizUtil.java:135)

      at xxlcb.apps.ldp.dashboard.view.session.GenericPagePhaseListener.beforePhase(GenericPagePhaseListener.java:34)

      at oracle.adfinternal.controller.lifecycle.LifecycleImpl.internalDispatchBeforeEvent(LifecycleImpl.java:93)

      at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:191)

      at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.access$400(ADFPhaseListener.java:35)

      at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$5.before(ADFPhaseListener.java:509)

      at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.beforePhase(ADFPhaseListener.java:77)

      at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.beforePhase(ADFLifecyclePhaseListener.java:44)

      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:356)

      at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:255)

      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:341)

      #############################################################################################  Error Stack Ends ###################################################################################################

      Because of this error we have seen a drastic performance issue and sometime the page simply spins .

       

      We have also raised the SR with Support for this issue and they have asked us to post in the forum to get a quick response while they are working with development on it.

       

      Would appreciate if anyone can share their experience about they have fixed the same error at their side.

       

      Thanks

      Abhinav