Re: update on Customers page

Posted by ErmanArslansOracleBlog on Apr 27, 2016; 5:29am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/update-on-Customers-page-tp927p928.html

Check the state of APPS.AR_MO_GLOBAL_CACHE

is it invalid?

2016-04-27 8:15 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hello,


when performing an update as SCE AR Superuser responsibility in Customers page, we are getting the error below. It is a cloned instance.

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.AR_MO_GLOBAL_CACHE"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AR_MO_GLOBAL_CACHE"
ORA-06512: at "APPS.ARP_STANDARD", line 3021
ORA-06512: at "APPS.ARP_GLOBAL", line 284
ORA-06512: at "APPS.ARP_TRX_UTIL", line 871
ORA-06512: at "APPS.ARP_TRX_UTIL", line 878
ORA-06512: at line 1

        at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
        at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
        at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
        at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775)
        at oracle.apps.ar.cusstd.acctSite.webui.ArAcctSiteOverviewCO.processRequest(ArAcctSiteOverviewCO.java:603)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
        at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1295)
        at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
        at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
        at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
        at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
        at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
        at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2771)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1991)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
        at _pages.__oa._jspService(__oa.java:233)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
        at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
        at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
        at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)
        at _pages.__oa._jspService(__oa.java:246)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
error_on_customer.txt

Thanks
       

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/update-on-Customers-page-tp927.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--