oracle.apps.fnd.framework.OAException

Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','9C43948337702996E04400144F80B8A410120525916069750102902718816222'); REASON = java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghtInit") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "APPS.FND_TRACE", line 360 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 395 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 236 ORA-06512: at line 1 ; ERRNO = 604;

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1857

  • via Oracle Community by 756829, 11 months ago
    level 4 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghtInit") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "APPS.FND_TRACE", line 360 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 395 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 236 ORA-06512: at line 1 ; ERRNO = 604;
  • via Oracle Community by 531886, 1 year ago
    Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int)(userId=6,sessionMode='null','50A433AC43BB44D19FEE33615DA0CC0122667116423664681147113645494831'); REASON = java.sql.SQLException: ORA-04068: existing state of
  • via Oracle Community by 804738, 11 months ago
    Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','A26198979CC1FE7BE040A8C0E714126E19682271241064037327178121309578'); REASON = java.sql.SQLException: ORA-01653: unable to extend table
  • Stack trace

    • oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = createSession(int, String)(userid=6','9C43948337702996E04400144F80B8A410120525916069750102902718816222'); REASON = java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghtInit") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "APPS.FND_TRACE", line 360 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 395 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 236 ORA-06512: at line 1 ; ERRNO = 604; at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:974) at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866) at oracle.apps.fnd.framework.webui.OAPageBean.validateUser(OAPageBean.java:4709) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:703) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429) at oa_html._OA._jspService(_OA.java:85) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:595)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    6 more bugmates