update on Customers page

[Roshan]

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
       

[ErmanArslansOracleBlog]

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

... [show rest of quote]

--

[Roshan]

I am compiling invalid objects and it remains stuck. Should I cancel it?
Dropping FND_INSTALL_PROCESSES table...


FND_INSTALL_PROCESSES table dropped.


Dropping AD_DEFERRED_JOBS table...


AD_DEFERRED_JOBS table dropped.

 Recording Adadmin action :ADADMIN_CMP_INVALID
 Tokens:INCR_INVOKER=No

sqlplus -s APPS/***** @/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 8  0 NONE FALSE'

[ErmanArslansOracleBlog]

It may be working.

Check invalid counts, see if it decreases.

select count(*) from dba_objects where status='INVALID';

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

I am compiling invalid objects and it remains stuck. Should I cancel it?
Dropping FND_INSTALL_PROCESSES table...


FND_INSTALL_PROCESSES table dropped.


Dropping AD_DEFERRED_JOBS table...


AD_DEFERRED_JOBS table dropped.

 Recording Adadmin action :ADADMIN_CMP_INVALID
 Tokens:INCR_INVOKER=No

sqlplus -s APPS/***** @/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 8  0 NONE FALSE'

---

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-tp927p929.html

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

... [show rest of quote]

--

[Roshan]

The result is 0
SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

[ErmanArslansOracleBlog]

Then you dont have any invalid objects. Restart apps+db and retry.

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

The result is 0
SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

---

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-tp927p931.html

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

--

[Roshan]

Thank you Sir. It is o.k now