6 Replies Latest reply on Nov 19, 2012 8:13 AM by ac4991

    OAF Error while deploying OA Project in APPS

    ac4991
      Hi Guyz,

      I'm new to this forums and also to OAF.
      Oracle Applications Version: 12.0.0 RUP6
      Oracle JDeveloper: 10.1.3.3.0

      I've just went through the OA Framework Developers Guide, OA Framework Beginners Guide Chola Press and Deployment of OA Framework Tutorials in APPS Environment by Anjani Pandey and have built a small test EmpDetails Page with Search,DML and Attachments.

      OA Project: MyAdvBookPR.jpr
      Entity Object: EmployeeEO (table: Employees)
      Entity Object: DepartmentEO (table: Departments)
      Association Object: EmpToDeptAO (Employees.employee_id = departments.department_id(+))
      View Object: EmpDetailsVO
      Application Module: AdvBookAM
      View Object Instance : EmpDetailsVO1
      OA Page: EmployeeManagerPG
      OA Controllers: EmployeeManagerCO (handles the form request on submitbutton "Apply" and "Cancel")
      ResultsAdvTableCO (handles the "Add Another Row" on the advanced table "ResultsAdvTable")

      This whole project works perfect on compilation in local m/c, my files are in: 'F:\OAF\jdevhome\jdev\myclasses\MyAdvBookPR'
      SubDirectories: MyAdvBookPR.oracle.apps.fnd.adv.server , MyAdvBookPR.oracle.apps.fnd.adv.webui and MyAdvBookPR.oracle.apps.fnd.schema.server.

      I zipped the folder MyAdvBookPR and uploaded it in $JAVA_TOP, unzipped it there and imported the "EmployeeManagerPG" page from server.
      Server location of files: $JAVA_TOP/MyAdvBookPR/oracle/apps/fnd/adv

      Next I registered a function as:
      Function Name: XXAEPL_FWK_MYADV_BOOK
      Function User Name: Amrit Sample Employee Details
      Properties Type: SSWA jsp function
      HTML Call: OA.jsp?page=/d02/clone-appl/apps/apps_st/comn/java/classes/MyAdvBookPR/oracle/apps/fnd/adv/webui/EmployeeManagerPG

      Next i added this function in "System Administrator" responsibility main menu.

      On running: i get an exception:

      Exception Details.
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /d02/clone-appl/apps/apps_st/comn/java/classes/MyAdvBookPR/oracle/apps/fnd/adv/webui/EmployeeManagerPG;
      at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:529)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3745)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3467)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1100)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      at OA.jspService(_OA.java:212)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
      at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
      at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
      at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
      at RF.jspService(_RF.java:225)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:595)
      ## Detail 0 ##
      Exception:
      oracle.adf.mds.MetadataDefException: Unable to find component with absolute reference = /d02/clone-appl/apps/apps_st/comn/java/classes/MyAdvBookPR/oracle/apps/fnd/adv/webui/EmployeeManagerPG, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.
      at oracle.adf.mds.internal.MetadataManagerBase.findElement(MetadataManagerBase.java:1370)
      at oracle.adf.mds.MElement.findElement(MElement.java:97)
      at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:503)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3745)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3467)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1100)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      at OA.jspService(_OA.java:212)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
      at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
      at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
      at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
      at RF.jspService(_RF.java:225)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:595)
      Exception:
      oracle.adf.mds.MetadataDefException: Unable to find component with absolute reference = /d02/clone-appl/apps/apps_st/comn/java/classes/MyAdvBookPR/oracle/apps/fnd/adv/webui/EmployeeManagerPG, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.
      at oracle.adf.mds.internal.MetadataManagerBase.findElement(MetadataManagerBase.java:1370)
      at oracle.adf.mds.MElement.findElement(MElement.java:97)
      at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:503)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3745)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3467)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1100)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      at OA.jspService(_OA.java:212)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
      at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
      at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
      at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
      at RF.jspService(_RF.java:225)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
      at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      at java.lang.Thread.run(Thread.java:595)

      Plz help me resolve this error or if i've done anything wrong while deploying it plz feel free to pin-point it.
      I would like to apologise for any disobedience to the standards of this forum, in case i have. Plz forgive coz i admit i'm a newbie.
      Hoping and requesting for an immediate response from all the respected members.

      Regards
      Ari
        • 1. Re: OAF Error while deploying OA Project in APPS
          keerthioaf
          Hi Ari ,

          At the first look everything seems to be fine , you have not mentioned the XML import , please go ahead and do the xml import for every page (XML)
          and every region ( LOVRN)

          Use the below script : You need to run this from D:\JdeveloperwithOAExten\jdevbin\oaext\bin

          import D:\OAFENV\JDEVELOPER\R12\jdevbin\jdev\myprojects\oracle\apps\csi\counter\reading\webui\CounterMassReadingPG.xml -rootdir D:\OAFENV\JDEVELOPER\R12\jdevbin\jdev\myprojects -username apps -password apps -dbconnection (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.9.111.90)(PORT=1234))(CONNECT_DATA=(SID=CLONE)))"

          Kindly replace your details in the above scripts such as xml page , hostname , portnumber , sid etc .

          Let me know if its not clear .

          Keerthi
          • 2. Re: OAF Error while deploying OA Project in APPS
            ac4991
            Hi Keerthi,

            Thanks a lot for the reply :)

            Well !! I'm sorry, i didn't mention the XML Import part. Actually i did the XML Import through XMLImporter, but from the server itself where i've FTP the whole project.zip after unzipping it.

            But, From the above post by u, i guess i need to import it from my local m/c. Is it?

            Regards
            Ari
            • 3. Re: OAF Error while deploying OA Project in APPS
              Gyan Darpan
              Ari,

              Error message clearly specifies that the page has not be imported to the MDS Repository.

              You can run your XML Importer utility either from server, or local machine.

              If still you are facing the issue, then share the XML Importer script.

              Regards,
              Gyan
              • 4. Re: OAF Error while deploying OA Project in APPS
                ac4991
                Hi Gyan,

                Thanks for the reply :)

                But i did import it, anywayz on your insistence i re-imported it.
                Here's the command:

                java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/MyAdvBookPR/oracle/apps/fnd/adv/webui/EmployeeManagerPG.xml -username APPS -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<Host Name>)(PORT=<port>))(CONNECT_DATA=(SID=<SID>)))" -rootdir $JAVA_TOP;

                <Host Name>,<port> and <SID> where replaced properly.
                And the import succeeded with the following message:

                Importing file "/d02/clone-appl/apps/apps_st/comn/java/classes/MyAdvBookPR/oracle
                +/apps/fnd/adv/webui/EmployeeManagerPG.xml" as "/MyAdvBookPR/oracle/apps/fnd/adv/w+
                ebui/EmployeeManagerPG".

                Import completed.

                But still when i open the page it throws me the same error.

                Regards
                Ari
                • 5. Re: OAF Error while deploying OA Project in APPS
                  Gyan Darpan
                  Ari,

                  I checked ur utility as well as page path. All seems to be fine. Can you bounce the apache.

                  If still doesn't work drop me a test mail at gyan.ebs@gmail.com.

                  Regards,
                  Gyan
                  • 6. Re: OAF Error while deploying OA Project in APPS
                    ac4991
                    Hey Guyz,

                    Yipee !! Success !!

                    Our system administrator just bounced the apache server, and then onwards the page is opening perfectly and functioning perfectly.
                    I guess this was the step which was missing.

                    Thank a lot for the co-operation.

                    Regards
                    Ari