java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 509 ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

Oracle Community | User353235 | 4 years ago
  1. 0

    Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request

    Oracle Community | 4 years ago | User353235
    java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 509 ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  2. 0

    Format Payment Instructions with Text Output fails with ora 01422

    Oracle Community | 5 years ago | Tam_11
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  3. 0

    Imoprting page to server

    Oracle Community | 5 years ago | user11258661
    java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02938: Multi-organization routine failed to initialize a session for the product: &PRODUCT. Please inform your support representative. ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL", line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Positive Pay with Additional Parameters erroring out on Manual Run

    Oracle Community | 5 years ago | 843443
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  6. 0

    Significance of FND_JDBC_PLSQL_RESET

    Oracle Community | 5 years ago | user10088255
    java.sql.SQLException: ORA-20101: ORA-06512: at "APPS.XXAP_APXINAGE_XMLP_PKG", line 302 ORA-06512: at line 4at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

  1. balintn 11 times, last 2 months ago
  2. Cafecanudo 2 times, last 3 months ago
18 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. java.sql.SQLException

    ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 509 ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    12 frames
  3. oracle.apps.ame
    ApprovalsAMImpl.queryApprovers
    1. oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.getApprovers(ApprovalsAMImpl.java:573)
    2. oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.queryApprovers(ApprovalsAMImpl.java:739)
    2 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  5. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
    3 frames
  6. oracle.apps.ame
    ApprovalsCO.processRequest
    1. oracle.apps.ame.dynamicapprovals.webui.ApprovalsCO.processRequest(ApprovalsCO.java:91)
    1 frame
  7. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
    4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
    9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
    14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    19. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
    21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
    22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
    23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
    24. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
    26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
    27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    28 frames