8 Replies Latest reply on May 13, 2013 10:38 AM by ;) ApPsMasTi ;)

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

    User353235
      Hi,

      While submitting any self-service request, system gives this error and notification is send to sysadmin with this error:

      =========================================================
      Error Page
      Exception Details.
      oracle.apps.fnd.framework.OAException: 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 1

           at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
           at oracle.apps.ame.dynamicapprovals.webui.ApprovalsCO.processRequest(ApprovalsCO.java:91)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
           at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
           at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
           at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
           at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
           at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
           at OA.jspService(_OA.java:221)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:619)
      ## Detail 0 ##
      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 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           at oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.getApprovers(ApprovalsAMImpl.java:573)
           at oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.queryApprovers(ApprovalsAMImpl.java:739)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
           at oracle.apps.ame.dynamicapprovals.webui.ApprovalsCO.processRequest(ApprovalsCO.java:91)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
           at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
           at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
           at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
           at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
           at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
           at OA.jspService(_OA.java:221)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:619)
      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 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           at oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.getApprovers(ApprovalsAMImpl.java:573)
           at oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.queryApprovers(ApprovalsAMImpl.java:739)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
           at oracle.apps.ame.dynamicapprovals.webui.ApprovalsCO.processRequest(ApprovalsCO.java:91)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
           at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
           at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:212)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
           at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
           at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
           at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
           at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
           at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
           at OA.jspService(_OA.java:221)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
           at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
           at java.lang.Thread.run(Thread.java:619)
      =====================================================

      1. Behavior happens to every self-service request (standard and custom).
      2. Since our self-service request use AME configuration in its approval hierarchy, we test all approval groups using live transaction test scenario by “Approval Management system Analyst responsibility” and providing the actual Transaction ID, test result was valid and we could retrieve chain for needed approvals.
      3. After getting this error the transaction stored at hr_API_transactions table under status “W” “ Work Under Process”
      4. Status of packages AME_UTIL and AME_DYNAMIC_APPROVAL_PKG is valid.

      Thank you,
      Mohammed.
        • 1. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
          ;) ApPsMasTi ;)
          Hi Mohammed,

          EBS release and version platform??


          please see this
          Cannot Add Adhoc Approver In Create Absence SSHR, Error: ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_P(1359276.1)
          SSHR:Any Action Requiring Approval Errors Out With: ORA-01436: Connect By Loop In User Data(357718.1)
          Configuring Oracle Self-Service Human Resources (SSHR) Approvals Using Approvals Management (AME)(360515.1)
          Help documentation on supporting AME Issues and different Diagonistics steps [ID 883338.1]
          Explanation Of "ORA-04068: Existing State Of Packages Has Been Discarded" And "ORA-06508 PL/SQL: Could Not Find Program Unit Being Called" Errors [ID 418270.1]
          3. After getting this error the transaction stored at hr_API_transactions table under status “W” “ Work Under Process”
          are you sure its Work under process
          please see this
          What is the Meaning of Statuses in HR_API_TRANSACTIONS Table? [ID 438346.1]

          :) AppsMAsti ;)
          Sharing is Caring
          1 person found this helpful
          • 2. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
            User353235
            Hi,

            We are having Oracle applications R12 (12.1.3) with PCP configured on two nodes, RDBMS RAC 11.1.0.7 (2 nodes), all on RHEL 5 (64 bit).


            Yes, the HR_API_TRANSACTION table shows status 'W' and the 'Approval Status' is 'Work in Process' when i check from web page (Navigation Employee Self-Service-->Absence Management page).

            Thank you,
            Mohammed.

            Edited by: 906610 on May 12, 2013 4:24 AM
            • 3. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
              ;) ApPsMasTi ;)
              Hi Mohammed,
              Yes, the HR_API_TRANSACTION table shows status 'W' and the 'Approval Status' is 'Work in Process' when i check from web page (Navigation Employee Self-Service-->Absence Management page).
              Thanks for the update
              can you please manually compile these packages
              AME_UTIL and AME_DYNAMIC_APPROVAL_PKG

              please see
              ORA-06508: PL/SQL: Could Not Find Program Unit Being Called In Package OKX_XXXX_PUB [ID 1316754.1]
              Ora-06508: PL/SQL Could Not Find Program Unit Being Called In Package XXXXXX" [ID 1163757.1]

              ;) AppsMAsti ;)
              Sharing is Caring
              1 person found this helpful
              • 4. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
                User353235
                Yes I can compile them manually.

                [oracle@proddb1 ~]$ sqlplus apps

                SQL*Plus: Release 11.1.0.7.0 - Production on Sun May 12 14:41:52 2013

                Copyright (c) 1982, 2008, Oracle. All rights reserved.

                Enter password:

                Connected to:
                Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
                With the Partitioning, Real Application Clusters, OLAP, Data Mining
                and Real Application Testing options

                SQL> alter package AME_UTIL compile;

                Package altered.

                SQL> alter package AME_UTIL compile body;

                Package body altered.

                SQL> alter package AME_DYNAMIC_APPROVAL_PKG compile;

                Package altered.

                SQL> alter package AME_DYNAMIC_APPROVAL_PKG compile body;

                Package body altered.

                Thank You,
                Mohammed.
                • 5. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
                  User353235
                  Hi,

                  I have checked the note ORA-06508: PL/SQL: Could Not Find Program Unit Being Called In Package OKX_XXXX_PUB [ID 1316754.1] which you have provided and found that i have similar issue.
                  The Select query in that note returns rows for me:

                  SQL> select do.name dname, po.name pname, p_timestamp, po.stime p_stime
                  2 from sys.obj$ do, sys.dependency$ d, sys.obj$ po
                  3 where p_obj#=po.obj#(+)
                  4 and d_obj#=do.obj#
                  5 and do.status=1 /*dependent is valid*/
                  6 and po.status=1 /*parent is valid*/
                  7 and po.stime!=p_timestamp /*parent timestamp does not match*/
                  8 and do.type# not in (28,29,30) /*dependent type is not java*/
                  9 and po.type# not in (28,29,30) /*parent type is not java*/
                  10 order by 2,1;

                  DNAME PNAME P_TIMESTAMP P_STIME
                  ------------------------------ ------------------------------ ------------------ ------------------
                  PO_WF_REQ_NOTIFICATION AME_UTIL 13-feb-12 12:16:50 03-apr-13 08:00:05
                  IBY_FNDCPT_COMMON_PUB IBY_UTILITY_PVT 17-aug-11 11:58:34 22-oct-12 10:51:08


                  Do you suggest me to go with the solution mentioned in the note?

                  Thank You,
                  Mohammed.
                  • 6. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
                    Hussein Sawwan-Oracle
                    Do you suggest me to go with the solution mentioned in the note?
                    Yes.

                    Thanks,
                    Hussein
                    1 person found this helpful
                    • 7. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
                      User353235
                      Many Thanks 'AppsMasti' and Hussein. Issue is resolved by implementing fix from note ID 1163757.1

                      Thank You,
                      Mohammed.
                      • 8. Re: Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request
                        ;) ApPsMasTi ;)
                        HI Mohammed,
                        906610 wrote:
                        Many Thanks 'AppsMasti' and Hussein. Issue is resolved by implementing fix from note ID 1163757.1

                        Thank You,
                        Mohammed.
                        Thanks for the update

                        ;) AppsMAsti ;)
                        Sharing is Caring