Saturday, October 24, 2020

oracle.apps.fnd.framework.OAException: No data found for region

 Issue-

When user  trying to login in application he is not able to see the home page and there is an error.


to see the home page and there is an error


 oracle.apps.fnd.framework.OAException: No data found for region (/oracle/apps/fnd/framework/navigate/webui/NewHomePG).

        at oracle.apps.fnd.framework.webui.JRAD2AKMapper.loadPage(JRAD2AKMapper.java:784)

        at oracle.apps.fnd.framework.webui.OAPageBean.initializeCustomizationsMDS(OAPageBean.java:7394)

        at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2525)

        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2066)

        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:585)

        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:473)

        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)

       

Solution:-

1- check Personalization.

 SELECT  jdr_mds_internal.getDocumentName(path_docid) as component
      ,       path_type
      ,       path_seq
      ,       creation_date
      ,       last_update_date
      FROM  ( SELECT  path_docid
              ,       path_type
              ,       path_seq
              ,       creation_date
              ,       last_update_date
              FROM    jdr_paths
              START WITH path_owner_docid = jdr_mds_internal.getDocumentID(('/'))
              CONNECT BY PRIOR path_docid = path_owner_docid) paths
      WHERE ( path_type = 'DOCUMENT' AND path_seq = -1)
        OR  ( path_type = 'PACKAGE'  AND path_seq = 0)
        OR  ( path_type = 'PACKAGE'  AND path_seq = -1
          AND NOT EXISTS (
                SELECT * FROM jdr_paths
                WHERE path_owner_docid = paths.path_docid))
                order by last_update_date desc;


2- Delete Personalization from user level,

exec jdr_utils.deletedocument('/oracle/apps/fnd/framework/navigate/webui/customizations/user/7071/NewHomePG');


3- User able to login 


 



x

No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts