7 Replies Latest reply: Sep 9, 2013 2:09 AM by Beginner Try RSS

    Deployment of OA Framework Custom Pages

    Beginner Try

      I want to deply custom OA pages and i follwoed theses steps:

       

      1- I create folder manuly under $JAVA_TOP/ oracle/apps  "xyka/expenses/"

      2.Transferring To Java_Top in ASCII mode

      3. Transfer CLASS files in BINARY mode

      4. change the mode of the class files to 777.

      5. // For R12 - JDevInstallDir\jdevbin\oaext\bin;

       

      import C:\JDeveloper\jdevhome\jdev\myprojects\oracle\apps\xyka\expenses\webui\ExpensesPG.xml -rootdir  C:\JDeveloper\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST==191.10.10.37)(PORT=1571))(CONNECT_DATA=(SID=DEV)))" 

      6. in server and cd $JAVA_TOP

      java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xyka/expenses/webui/ExpensesPG.xml -rootdir $JAVA_TOP/ -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=191.10.10.37)(PORT=1571))(CONNECT_DATA=(SERVICE_NAME=DEV)))"

       

      However , command get hang in the last step

       

      Kindly help

        • 2. Re: Deployment of OA Framework Custom Pages
          DilipG

          Hi,

           

           

          Step 1 : Move Your .xml and .class files to server  $JAVA_TOP/oracle/apps/xyka/expenses/

           

           

          Step 2 : Run Below Xml Importer command  in JAVA_TOP.

           

           

          java \

           

          oracle.jrad.tools.xml.importer.XMLImporter \

           

          /$JAVA_TOP/oracle/apps/xyka/expenses/webui/ExpensesPG.xml \

           

          -username apps \

           

          -password apps \

           

          -rootdir /$JAVA_TOP/ \

           

          -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=191.10.10.37)(PORT=1571)) (CONNECT_DATA= (SID=DEV)))"

           

           

          Step 3: Bounce the Apache Sever

           

           

          Step 4: Review your deployed custom OA page

           

           

          Note: Ensure that the necessary AOL objects referenced from your custom page (such as Functions, Menus, and Responsibilities) have been created or exist on the Release 12 instance to which you are deploying your custom page.

           

          Let me know if any issue.

           

           

          Thanks,

           

          Dilip

          • 3. Re: Deployment of OA Framework Custom Pages
            Beginner Try


            Thanks for help

             

            Still when i run Run Xml Importer command  in JAVA_TOP, it gets stuck.

            it will reach till CONNECT_DAT , then it will hang with no action.

             

            Regards

            Masooma

            • 4. Re: Deployment of OA Framework Custom Pages
              DilipG

              Hi Masooma,

               

              Above  XMLImporter is correct and valid, r u copied all files properly to Instance TOP?

               

              Also check below scenario.

               

              Step 1: Please Run Below Jdr_util in Database and check Your Page is imported or not in MDS Repository. It will show you XML tags of Page in DBMS Output.

               

               

              DECLARE

              BEGIN

              jdr_utils.printdocument

              (p_document => '/oracle/apps/xyka/expenses/webui/ExpensesPG');

              END;

               

               

               

              Step 2: If not then check your data base connectivity Credentials and Permissions with DBA.

               

              Thanks,

              Dilip

              • 5. Re: Deployment of OA Framework Custom Pages
                Beginner Try

                Hi Mr Dilip

                 

                 

                I run sql and  It shows XML tags of Page in DBMS Output.

                What is next?

                 

                Thanks

                 

                Regards

                • 6. Re: Deployment of OA Framework Custom Pages
                  DilipG

                  Hi,

                      It Means Your page is imported in MDS Respository. Now do below steps.

                   

                   

                  Step 1: Bounce the Apache Sever

                   

                  Step 2: Review your deployed custom OA page

                   

                  Note: Ensure that the necessary AOL objects referenced from your custom page (such as Functions, Menus, and Responsibilities) have been created or exist on the Release 12 instance to which you are deploying your custom page.

                     

                  If AOL Is not created yet then fallow below steps.

                   

                     a. Create form function with property "SSWA jsp function" and webhtml "OA.jsp?page=/oracle/apps/xyka

                   

                             /expenses/webui/ExpensesPG" .

                   

                   

                     b. Add function to menu.

                   

                   

                     c. Add menu to responsibility

                   

                  Also Refer Below link. for Custom Page Registration in AOL.

                   

                  https://blogs.oracle.com/prajkumar/entry/deploy_oaf_page


                   

                  Let me know if any issue.

                   

                  Thanks,

                  Dilip

                  • 7. Re: Deployment of OA Framework Custom Pages
                    Beginner Try

                    Thanks alot for your help

                    it works

                    it means no need for run Xml Importer command  in JAVA_TOP, it is enough to run import from my local machin (

                    import d:\jdevhome\jdev\myprojects\xx\oracle\apps\per\webui\EmployeeRN.xml -rootdir d:\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=camoradb9.xx.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))" 

                     

                    Thanks