9 Replies Latest reply on Aug 26, 2015 5:50 PM by 1451673

    Customized OAF pages not working in Upgraded R 12.2.4

    2725480

      Hi Guys,

       

      We are upgrading to R 12.2.4 from R 11.5.10.2. We have copied our build instance from Production and upgraded it to R 12.2.24. Now there is a problem with customized OAF pages. It seems that custom java class files are not getting referred by the application.

       

      Since it is build instance, I am applying custom patch directly into run file system (fs1) and I am getting below error while running one of the custom OAF page:

       

      oracle.apps.fnd.framework.OAException: Could not create Java class: (oracle.apps.xxfe.f486.asn.lead.webui.ASNLeadQryCOEx) associated with region: (ASNLeadQryRN). This is probably because the class name is wrong or not included in project.

      at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)

      at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)

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

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

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

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

       

      I think it is simply saying that it could not find the java class. But I checked in the system as shown below, class files are pretty much there:

       

      $ cd $JAVA_TOP

      $ cd oracle/apps/xxfe/f486/asn/lead/webui/

      $ ls -ltr

      total 10

      -rw-r--r-- 1 a2bur12a dba 5693 Jan  7 13:23 ASNLeadLstCOEx.class

      -rw-r--r-- 1 a2bur12a dba 3397 Jan  7 13:23 ASNLeadQryCOEx.class

       

      I also checked the class path, which is also pointing to java top:

       

      $ cd $JAVA_TOP

      $ pwd

      /opt/lapp121/fs1/EBSapps/comn/java/classes

       

      $ echo $CLASSPATH

      /opt/lapp121/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/opt/lapp121/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/opt/lapp121/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/opt/lapp121/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/opt/lapp121/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/opt/lapp121/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/opt/lapp121/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/opt/lapp121/fs1/EBSapps/comn/java/classes:/opt/lapp121/fs1/EBSapps/10.1.2/forms/java:/opt/lapp121/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/opt/lapp121/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/opt/lapp121/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar

       

      I got to know that we need to run adcgnjar utility and when I tried I got below message:

       

      Generating customall.jar ...

      Not creating customall.jar as no custom java directories found under JAVA_TOP.

       

      It may be because of location of custom folder which is $JAVA_TOP/oracle/apps/xxfe

       

      I have also tried installing this custom OAF functionality in online patching (As per my understanding following online patching functionality is not mandatory (It is just a build instance) so earlier I had installed directly in run file system). But while following patch mode, I got some error in ADOP (prepare) as below:

      *******FATAL ERROR*******

      PROGRAM : (/opt/lapp121/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

      TIME    : Fri Jan  9 15:07:37 2015

      FUNCTION: main::validatePatchLocation [ Level 1 ]

      ERRORMSG: Directory /opt/lapp121/fs_ne/EBSapps/patch/19258581 does not exists.

       

      [UNEXPECTED]Error occurred while executing "perl /opt/lapp121/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -


      Note, I am using below commands to bounce the middle tier:

      1. adapcctl.sh stop
      2. admanagedsrvctl.sh stop oacore_server1
      3. Enter Weblogic Password: <pass>
      4. admanagedsrvctl.sh start oacore_server1
      5. Enter Weblogic Password: <pass>
      6. adapcctl.sh start


      Mainly I am looking for installing this customization in run file system if it is absolutely not necessary to do it in patch file system.


      Please let me know if someone knows about this issue or any way forward?

       

      Thanks,

      Anupam

        • 1. Re: Customized OAF pages not working in Upgraded R 12.2.4
          2725480

          Hi,

           

          I was able to fix this issue. I am writing the solution that worked for reference:

           

          1. When custom java files are placed in one of the Oracle shipped application's directories (e.g. $JAVA_TOP/oracle/apps/fnd, $JAVA_TOP/oracle/apps/ad, etc.) then, the custom jar file creation is not needed.

           

          1. When custom java files are placed in $JAVA_TOP/<Company identifier>/ then run the adcgnjar utility.

           

          1. Deploy customizations that are created in the package oracle.apps.xxprod.* rather than xxprod.oracle.apps.* or xxprod.oracle.apps.xxprod.* on EBS 12.2.X?

           

          This was our case as we have custom directory under $JAVA_TOP/oracle/apps/xxfe

           

          When custom java files are placed in any other non-standard locations (e.g. $JAVA_TOP/oracle/, $JAVA_TOP/oracle/java/, etc.) then, custom jar file must be created manually and it must be made available for WebLogic to pick it up.

           

          Detailed steps are given below:

           

          Create a temporary custom.zip file which contains all the custom application's directories/files at non-standard location:

           

              1) cd $JAVA_TOP

           

              2) zip -r customprod.zip. Where the list of all directory paths are present, relative to $JAVA_TOP, for custom application's java files at non-standard location.

           

              3) Generate & sign customprod.jar file.

          Command: adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

              

              4) Delete temporary customprod.zip.

           

          Command: rm $JAVA_TOP/customprod.zip

           

              5) Follow below steps to make the custom jar available for WebLogic

           

          a) Take a back-up of existing /admin/template/ebsProductManifest_xml.tmp

           

          b) Modify /admin/template/ebsProductManifest_xml.tmp to add entry for customprod.jar (after customall.jar)  

           

          c) Run AutoConfig

           

          d) Bounce the Mid-tier services

           

          Thanks,

          Anupam

          1 person found this helpful
          • 2. Re: Customized OAF pages not working in Upgraded R 12.2.4
            2880479

            Hi Anupam,

             

            I am new to OAF and have started with the extension of a controller( Create Customer page) in 12.2.4 instance.

             

            I am getting the same error.

             

            Could you please tell me in any easier language to fix this error.

             

            I have the .class file in below directory

            [applmgr@gfs3devapp1 webui]$ pwd

            /opt/oracle/gfs2d/fs1/EBSapps/comn/java/classes/oracle/apps/xxar/cusstd/createcus/webui

            [applmgr@gfs3devapp1 webui]$ ls -ltr

            total 4

            -rw-r-----. 1 applmgr oinstall 1177 Feb 25 10:17 xxArCreCusCO.class

             

            Awaiting your response.


            Thanks,

            Prakhar

            • 3. Re: Customized OAF pages not working in Upgraded R 12.2.4
              2725480

              Hi,

               

              You need to follow below steps:

               

              1) cd $JAVA_TOP

               

                  2) zip -r customprod.zip. Where the list of all directory paths are present, relative to $JAVA_TOP, for custom application's java files at non-standard location.

               

                  3) Generate & sign customprod.jar file.

              Command: adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

                 

                  4) Delete temporary customprod.zip.

               

              Command: rm $JAVA_TOP/customprod.zip

               

                  5) Follow below steps to make the custom jar available for WebLogic

               

              a) Take a back-up of existing /admin/template/ebsProductManifest_xml.tmp

               

              b) Modify /admin/template/ebsProductManifest_xml.tmp to add entry for customprod.jar (after customall.jar) 

               

              c) Run AutoConfig

               

              d) Bounce the Mid-tier services

               

              Thanks,

              Anupam

              • 4. Re: Customized OAF pages not working in Upgraded R 12.2.4
                Ali Raza Memon

                Dear,

                 

                We are also facing the same problem in our newly upgraded environment. Please, consider our scenario down:

                 

                JAVA_TOP: /d01/PLIVE/appsTier/fs1/EBSapps/comn/java/classes

                 

                Custom Forms: $JAVA_TOP/oracle/apps/xxca/rvfc/p2/Med_Compilation/webui

                 

                Following forms are present in above mentioned directory:

                 

                DemandCreatePGCO.class DemandDetailPGCO.class DemandQueryPGCO.class DemandCreatePG.xml DemandDetailPG.xml DemandQueryPG.xml


                1) Create a temporary custom.zip

                 

                $ cd $JAVA_TOP

                 

                $ zip -r customprod.zip oracle/apps/xxca/rvfc/p2/Med_Compilation/webui

                 

                2) Generate and sign the customprod.jar file.

                 

                $ adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

                 

                 

                Copyright (c) 2002, 2012 Oracle Corporation

                Redwood Shores, California, USA

                 

                AD Java

                 

                Version 12.2.0

                 

                NOTE: You may not use this utility for custom development

                unless you have written permission from Oracle Corporation.

                 

                Reading product information from file...

                 

                Reading language and territory information from file...

                 

                Reading language information from applUS.txt ...

                Temporarily resetting CLASSPATH to:

                "/d01/PLIVE/appsTier/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/d01/PLIVE/appsTier/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/d01/PLIVE/appsTier/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/d01/PLIVE/appsTier/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/d01/PLIVE/appsTier/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/d01/PLIVE/appsTier/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/d01/PLIVE/appsTier/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/d01/PLIVE/appsTier/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/d01/PLIVE/appsTier/fs1/EBSapps/comn/java/classes:/d01/PLIVE/appsTier/fs1/EBSapps/10.1.2/forms/java:/d01/PLIVE/appsTier/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/d01/PLIVE/appsTier/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/d01/PLIVE/appsTier/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

                 

                Calling /d01/PLIVE/appsTier/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...

                The JDK version is 1.7.0_25

                WARNING: -keyPass option has not provided. Hence using default password while signing jar files

                WARNING: -storePass option has not provided. Hence using default password while signing jar files

                 

                Validating the files/directories specified for -areas option

                 

                 

                About to Analyze the input areas : Mon May 11 2015 11:40:50

                 

                WARNING: Unable to load metadata entry from zip file /d01/PLIVE/appsTier/fs1/EBSapps/comn/java/classes/customprod.zip

                Cause: Error while trying to read metadata from file /d01/PLIVE/appsTier/fs1/EBSapps/comn/java/classes/customprod.zip: No metadata entry META-INF/JRIMETA.DAT found

                Action needed: None. This message is for information only and can safely be ignored.

                 

                3) Deleted the temporary customprod.zip.

                 

                4) Updated ebsProductManifest_xml.tmp.


                5) Executed autoconfig. It went successful. and bounced the middle-tier services.

                 

                At the end we got the error while accessing form.



                load-application-error.gif

                Best Regards

                • 5. Re: Customized OAF pages not working in Upgraded R 12.2.4
                  2880479

                  Hi,

                   

                  Please follow the below steps simply and it will work.

                   

                  Go to the custom path where class file is present

                  run adcgnjar

                   

                  then

                   

                  cd $ADMIN_SCRIPTS_HOME

                   

                  ./admanagedsrvctl.sh stop oacore_server1

                   

                  ./admanagedsrvctl.sh start oacore_server1

                   

                  then apache restart

                   

                  ./adapcctl.sh stop

                   

                  ./adapcctl.sh start

                   

                  Thanks,

                  Prakhar

                  • 6. Re: Customized OAF pages not working in Upgraded R 12.2.4
                    Ali Raza Memon

                    Thanks buddy! We done it while.

                     

                    Regards,

                    Ali

                    • 7. Re: Customized OAF pages not working in Upgraded R 12.2.4
                      1451673

                      Hi Prabhakar,

                       

                      can u please provide the steps to add external jar libraries such as poi jxl etc in r12.2.4.

                       

                      regards,

                      vinoth

                      • 8. Re: Customized OAF pages not working in Upgraded R 12.2.4
                        2880479

                        Hi Vinoth,

                         

                        Follow the below steps

                         

                        Go to the custom path where class file is present

                        run adcgnjar

                         

                        then

                         

                        cd $ADMIN_SCRIPTS_HOME

                         

                        ./admanagedsrvctl.sh stop oacore_server1

                         

                        ./admanagedsrvctl.sh start oacore_server1

                         

                        then apache restart

                         

                        ./adapcctl.sh stop

                         

                        ./adapcctl.sh start

                         

                        Thanks,

                        Prakhar

                        • 9. Re: Customized OAF pages not working in Upgraded R 12.2.4
                          1451673

                          Hi prabhakar,

                          Thanks for Reply and sorry for late response.

                           

                          Actually my jar file and import page is available like below structure.

                           

                           

                          Java_top/xxcust/Oracle/apps/fnd/salesupload/jxl.jar

                          My page class files also same location.

                           

                          Do i need to move jar file under java_top/ oracle/apps/xxcust with page class file or jar file only required?

                           

                          As mentioned above

                          1. Deploy customizations that are created in the package oracle.apps.xxprod.* rather than xxprod.oracle.apps.* or xxprod.oracle.apps.xxprod.* on EBS 12.2.X?

                           

                          This was our case as we have custom directory under $JAVA_TOP/oracle/apps/xxfe


                          Thanks in advance,

                          Vinoth