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
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

    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 | 6 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)
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