Oaf page error

classic Classic list List threaded Threaded
17 messages Options
Reply | Threaded
Open this post in threaded view
|

Oaf page error

Saad Qaiser Khan
Hello,

I have created a dynamic view object on shipment workbench that is an oaf page. when i again access that page it shows me error with exception details through which i came to know that view i created is wrong.Now the page won't open and neither can i delete that item. Is there a way I can recover oaf page before that persoalization. Also I have disabled profile personalization for oaf page to check if problem goes away but it didn't help further now when i try to enable that link personalization won't enable. Please if you can help me on that

Thanks and Regards,
Saad
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
Is this view queried only when that personlization is enabled?
How did you disabled the personalization?
Can this be a browser cache issue or something? Did you retry after disabling the personalization and clearing all the caches (including browser cache)?
Send me the eception details in case of the issue persists..
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
Yes actually it has to be fired on run time. Plus I tries to disabled the personalization and thought that page would be open then but it doesn't. And now I am trying to enabling the personalization but it is not enabling region link. Now I will try to clear browser cache and check if problem goes away or not. However I tried to clear the cache from functional administrator and it doesn't work. I am attaching the exception details log.

oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 123 for type View Object is invalid
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1310)
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1497)
        at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:3067)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2139)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:587)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:475)
        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.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:527)
        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:216)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:487)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 123 for type View Object is invalid
        at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1232)
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1497)
        at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:3067)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2139)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:587)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:475)
        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.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:527)
        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:216)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:487)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 123 for type View Object is invalid
        at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1232)
        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1497)
        at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:3067)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2139)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:587)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:475)
        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.TailFilter.doFilter(TailFilter.java:26)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:527)
        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:216)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:487)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
        at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
        at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
        at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
        at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
Why dont you just compile the view? The view seems invalid..
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
Can you please guide me how can I achieve this? Plus I am unable to enable the OAF Personalization Region Link enabled back. Please if you can guide me through steps.

Thanks and Regards,
Saad
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
Set the values of following profiles to enable Personalization Page link in OAF Pages;

FND: Personalization Region Link Enabled - > Yes

Personalize Self-Service Defn -> Yes

Disable Self-Service Personal -> No
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
It is already done arslan but it is not showing. I don't know what gets wrong. I also done this on site level but it not showing me.

Thanks and Regards,
Saad Qaiser Khan
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
What is your EBS version ? (3 digit)
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
You may need to restart Apache server..
(profile options are cached)

Also you may try using the responsibility named “Functional Administrator” to change the profile option value for “Personalize Self-Service Defn”

Check this post -> https://apps2fusion.com/apps/oa-framework/230-personalization-link-does-not-appear-despite-setting-profile
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
In reply to this post by ErmanArslansOracleBlog
Oracle Apps version is 12.2.6
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
In reply to this post by ErmanArslansOracleBlog
Yes I have also done changing profile options using Functional Administrator But it didn't help. Though I don't know about apache I have bounced the server but don't the apache server bounce with it or not. Do I have to bounce apache seperately. please if you can tell this.


Thanks and Regards,
Saad Qaiser Khan
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
What do you mean by seperately?

I say, restart apache server. (apache server only)

Anyways, also check these profile options settings in user level.. Any value set in user level will overwrite the site level profile setting.

Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad Qaiser Khan
Hello,

yes erman, Its not helping. I have also raised SR but no help from them yet.

Regards,
Saad
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
Did you use  Functional Administrator responsibility??

I mean -> did you set the profile value using Core Services, and SubTab “Profiles”, as instructed in below link ->

https://apps2fusion.com/apps/oa-framework/230-personalization-link-does-not-appear-despite-setting-profile
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

Saad
Hello,

Yes I did it in Functional Administrator responsibility too. but it is not enabling. I have no clue why its doing like this.

Regards,
Saad
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

saad qaiser khan
Would recompiling the jsp help?

Regards,
Saad
Reply | Threaded
Open this post in threaded view
|

Re: Oaf page error

ErmanArslansOracleBlog
Administrator
Did you check the related profiles on all levels? (site, responsibility and user levels)

Personalize Self-Service Defn Yes
Disable Self-Service Personal No
Profile option FND: Personalization Region Link Enabled is not required for personalize the page, if turn it on, will see personalization link at region level, if not, still able to use Personalize Page link on top of the page to do personalization.