11 Replies Latest reply on Mar 8, 2016 8:22 PM by Beauty_and_dBest

    Compile forms error

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      RHEL6.5

       

       

      I applied patch  21261629  on our instance, but after applying it some forms do not generate successfully

       

      The following Oracle Forms objects did not generate successfully:

       

      ap      forms/US        APXIISIM.fmx

      inv     forms/US        INVSDOIO.fmx

      ar      forms/US        ARXTWMAI.fmx

      ap      forms/US        APXINWKB.fmx

       

       

      I tried to compile it manually but I can not see the error.

       

      frmcmp_batch userid=apps/apps module_type=form batch=no compile_all=yes module=/u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/forms/US/APXIISIM.fmb output_file=/u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/forms/US/APXIISIM.fmx

       

      Compiling package body MO_TRANSACTION_FUNCTIONS...

      Compilation error on package body MO_TRANSACTION_FUNCTIONS:

      PL/SQL ERROR 49 at line 362, column 10

      bad bind variable 'parameter.g_query_find'

      PL/SQL ERROR 49 at line 362, column 10

      bad bind variable 'parameter.g_query_find'

       

      Compiling package specification TAX_CONTROL...

         No compilation errors.

       

      Compiling package body TAX_CONTROL...

         No compilation errors.

       

      Compilation errors have occurred.

       

      Form not created



      Please help how to resolve compilation error.

       

       

      Kind regards,

      jc

        • 1. Re: Compile forms error
          Narsi M-Oracle

          Hello Jenna,

           

          Can you compare these forms with the ones in your PROD environment. You can use adident or strings command.

          Try to check if you can manually copy these forms from PROD or other environments and compile them manually.

           

           

          Regards,

          Narsi

          1 person found this helpful
          • 2. Re: Compile forms error
            Beauty_and_dBest

            Thanks Narsi long time no "see".

             

            By doing that, will it not defeats or depletes the purpose of appying the patch?

            Or is patch 21261629 not "appropriate"?

             

             

            Kind regards,

            • 3. Re: Compile forms error
              Narsi M-Oracle

              Hello Jenna,

               

              Yes. Was caught up in some other activities.

               

               

              Sometimes, the patch might have an older version of the file which is entirely based on when the patch was created.

              If there is an issue with the forms compilation of all forms, it is a different scenario.

              But, in your case, only a few forms couldn't be compiled.

              So, you can try below:

              1) Check for the version of the fmb on both PROD and environment you are applying patch

              2) If the forms version is higher in PROD, then take backup of the fmb and copy it from PROD and compile it using frmcmp_batch.sh

              3) If the form version from Patch is higher, it could be some other issue which we would need to investigate.

               

               

              Regards,

              Narsi

              1 person found this helpful
              • 4. Re: Compile forms error
                Beauty_and_dBest

                Hi Narsi,

                 

                In PROD:

                 

                $ strings -a APXIISIM.fmb|grep '$Header'

                FDRCSID('$Header: APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship $');

                +FDRCSID('$Header: APXIISIM.fmb 120.79.12010000.26 2010/04/01 09:46  sjetti ship  $');

                +FDRCSID('$Header: APXIISIM.fmb 120.79.12010000.26 2010/04/01 09:46  sjetti ship  $');

                 

                in UAT or TEST

                 

                $ strings -a APXIISIM.fmb|grep '$Header'

                FDRCSID('$Header: APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship $');

                +FDRCSID('$Header: APXIISIM.fmb 120.79.12010000.26 2010/04/01 09:46  sjetti ship $');

                +FDRCSID('$Header: APXIISIM.fmb 120.79.12010000.26 2010/04/01 09:46  sjetti ship $');



                It seems they are the same

                But I have 3 database invalid objects, could it be the culprit?


                AHL_UTIL_UC_PKG, PACKAGE BODY

                OPI_EDW_OPMINV_DAILY_STAT_F_C, PACKAGE BODY

                EDW_SUPPLIER_ITEM_PKG, PACKAGE BODY

                 

                How do you resolve package error :

                • Error(34,1): PLS-00452: Subprogram 'GETCSI_LOCATIONDESC' violates its associated pragma

                Capture.PNG

                 

                 

                Kind regards,

                • 5. Re: Compile forms error
                  VishnuVinnakota

                  Fix that invalid issue 1st.

                   

                  Package AHL_UTIL_UC_PKG Becomes Invalid after Upgrade to EBS 12.1.3 (Doc ID 1547020.1)

                  What's Causing the Error --> ORA-00904: "MRH"."WARRANTY_TEMPLATE_ID": invalid identifier ? (Doc ID 1917938.1)

                   

                  1st Link looks very close.

                  1 person found this helpful
                  • 6. Re: Compile forms error
                    Beauty_and_dBest

                    Thanks Vishnu, Narsi and ALL,

                     

                    I guess I need to further test it on another fresh cloned instance. It seems the instance I run it to is "corrupted"

                     

                    By the way, how can I compile a single specific form "INVTVTXN"  by using adadmin?

                     

                    I run compile ALL forms for a long time and I got 1 left out. I want to compile it again so I can check and "single-out" one log.

                     

                    The following Oracle Forms objects did not generate successfully:


                    inv     forms/US        INVTVTXN.fmx

                     

                     

                    Kind regards,

                    • 7. Re: Compile forms error
                      VishnuVinnakota

                      Run adadmin

                      Option 1-->2 (For Forms)

                      Then:

                      Product: INV

                      Specific Form: Yes

                      Choose the INVTVTXN.fmx

                       

                      Then you can compile specific form.

                      1 person found this helpful
                      • 8. Re: Compile forms error
                        Beauty_and_dBest

                        Hi Vishnu and ALL,

                         

                        Do I choose INVTVTXN.fmx or  INVTVTXN.fmb?


                        Supposing it will not compile and has errors, which specific log file will it go?



                        Thanks.

                        • 9. Re: Compile forms error
                          VishnuVinnakota

                          It should show ideally show only .FMX

                           

                          It will pick up FMB from AU_TOP automatically to generate FMX in respective PRODUCT_TOP

                          1 person found this helpful
                          • 10. Re: Compile forms error
                            VishnuVinnakota

                            Check the ADADMIN log itself.. $APPL_TOP/admin/SID/log... Then name of the logfile you specified when you started ADADMIN

                            1 person found this helpful
                            • 11. Re: Compile forms error
                              Beauty_and_dBest

                              Thanks ALL,