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;

Oracle Community | 756829 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Login error in 11.5.10.2

    Oracle Community | 6 years ago | 756829
    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;
  2. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
  3. 0

    Tycast error in Extension

    Oracle Community | 8 years ago | 568541
    oracle.apps.fnd.framework.OAException: The application id or shortname (abc) you entered does not exist.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = null; (Could not lookup message because there is no database connection)
  6. 0

    Not able to view the XML Output, after Output format changed to XML

    Oracle Community | 8 years ago | 488635
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = TemplateFilesForViewVO2; APPLICATION_MODULE = oracle.apps.xdo.oa.template.server.TemplatesAM;

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:974)
      2. oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866)
      3. oracle.apps.fnd.framework.webui.OAPageBean.validateUser(OAPageBean.java:4709)
      4. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:703)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
      6 frames
    3. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:85)
      1 frame
    4. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    5. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    6. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    8. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame