EBS 12.2 OAF page issue

[raja]

Hi Erman

We have one responsibility and under that one OAF page is not opening. It throws an exception with

Exception Details.  
 oracle.apps.fnd.framework.OAException: oracle.adf.mds.exception.MDSRuntimeException
        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.OAPageBean.preparePage(OAPageBean.java:2627)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:609)
        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:489)
        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.fnd.security.csrf.GuardFilter.doFilter(GuardFilter.java:276)
        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.__rf._jspService(__rf.java:239)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper
 

No personalizations are present or no change was done to the system. All other oaf pages are opening fine in this instance. Also, this oaf page is opening fine in other instances

[ErmanArslansOracleBlog]

It is a MDSRunTimeException , but no error message for that.. We don't see the exception details and the call/error stack is not a documented one..

Generate a trace and let me see;

Generating the log and trace for self service/OAF issues (Doc ID 1564962.1)

[raja]

trace.txt

[raja]

Hi Erman

have attached the trace file

[ErmanArslansOracleBlog]

Please send me the screen log , by following "Section 2: Generating the On-screen Logging" of the same document.

[raja]

logs_from_screen_logging.txt

[ErmanArslansOracleBlog]

1) Before failing, it does ->

[404]:PROCEDURE:[fnd.profiles.Profiles]:getProfileOptionValue:  name=AMPOOL_CONNECTION_POOL_ENABLED; levelID=10001; levelValue=0; levelValueApplID=0

What is the value of AMPOOL_CONNECTION_POOL_ENABLED set in the problematic instance?
What is the value of AMPOOL_CONNECTION_POOL_ENABLED set in the properly working instances?

2)What is the value of "Disable Self-Service Personal" profile option set in the problematic and properly working instances?

3)Do you have any customizations in the failing page?

4)What is the failing page?

5)Before all that, you have a read for JTF_PF_MASTER_ENABLED option and you get ->

EXCEPTION:[fnd.framework.webui.OAPageBean]:java.lang.NullPointerException
        at oracle.apps.fnd.framework.webui.OAPageBean.getHeaderLabel(OAPageBean.java:10063)
        at oracle.apps.fnd.framework.webui.OAPageBean.getOAPageTitle(OAPageBean.java:9895)
        at oracle.apps.fnd.framework.webui.OAPageBean.finalizeRequest(OAPageBean.java:5279)

I think there is a customizaton there.. Please do a profile value check comparison between your working and problematic instances..

Do a full check and compare.. Speak with your developer.. Compare the following profile option values in the first place ;

Framework Validation Level
FND Function Validation Level
FND Validation Level
FND_VALIDATION_LEVEL