1 2 Previous Next 21 Replies Latest reply on Mar 13, 2016 3:06 PM by Beauty_and_dBest

    Patch 11659432 for EBS12.1.3

    Beauty_and_dBest

      Hi ALL,

       

       

      ebs r12.1.3

      rhel6.5

      11gR2

       

      I applied patch 11659432  to our EBS12.1.3 instance

      And it generate error for one form only.

       

      The following Oracle Forms objects did not generate successfully:

       

      inv     forms/US        INVTVTXN.fmx



      I compared the version of the old and new form


      OLD  is   120.41.12010000.14

      NEW is 120.41.12010000.26



      I copied back the "old" version and the compile was successful.

      Is this acceptable solution? That Old version is better than the new version? It seems ironic

       

       

      Kind regards,

      jc



        • 1. Re: Patch 11659432 for EBS12.1.3
          Ssukhija-Oracle

          Hi Jenna

           

          Suggested to check point  11 of Top Adpatch Patching Issues For Release 11i And 12.x (Doc ID 1444322.1)



          Thanks

          Shalini

           

           


          1 person found this helpful
          • 3. Re: Patch 11659432 for EBS12.1.3
            Pravin Takpire

            No this is not acceptable but yes it is work around. I would suggest you compile that form manually and check for errors. Resolve these errors

            regards

            Pravin

            1 person found this helpful
            • 4. Re: Patch 11659432 for EBS12.1.3
              Srini Chavali-Oracle

              There is possibly a mismatch now between the forms code and code / objects in the database, which could lead to logical data corruption.

               

              You should troubleshoot the forms errors.

              1 person found this helpful
              • 5. Re: Patch 11659432 for EBS12.1.3
                Beauty_and_dBest

                Thanks Pravin, Srini, and ALL.

                 

                I tried to manually compile the form using:

                 

                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/INVTVTXN.fmb output_file=/u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/forms/US/INVTVTXN.fmx

                 

                But they get error even if the clean compile form in adadmin. I mean it  gets error if u manually compile it

                 

                Below is the output log:

                 

                Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

                Forms 10.1 (Form Compiler): Release  - Production

                Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

                     With the Partitioning, OLAP, Data Mining and Real Application Testing options

                PL/SQL Version 10.1.0.5.0 (Production)

                Oracle Procedure Builder V10.1.2.3.0 - Production

                Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)

                Oracle Multimedia Version 10.1.2.0.2 (Production)

                Oracle Tools Integration Version 10.1.2.0.2 (Production)

                Oracle Tools Common Area Version 10.1.2.0.2

                Oracle CORE     10.1.0.5.0      Production

                FRM-18108: Failed to load the following objects.

                Source Module:CSTFQITD

                  Source Object: INV_TRANSACTION_DISTRIBUTION

                Source Module:CSTFQITD

                  Source Object: C_DISTRIBUTIONS_1

                Source Module:CSTFQITD

                  Source Object: C_DISTRIBUTIONS_2

                Source Module:CSTFQITD

                  Source Object: C_DISTRIBUTIONS_3

                Source Module:CSTFQITD

                  Source Object: C_DISTRIBUTIONS_4

                Source Module:CSTFQITD

                  Source Object: C_DISTRIBUTIONS_5

                Source Module:CSTFQITD

                  Source Object: DISTRIBUTION_QF

                Source Module:CSTFQITD

                  Source Object: REVISION

                Source Module:CSTFQITD

                  Source Object: INV_TRANSACTION_DISTRIBUTION

                Source Module:APPSTAND

                  Source Object: STANDARD_PC_AND_VA

                Source Module:INVSTAND

                  Source Object: INV_PARAMS

                Source Module:INVSTAND

                  Source Object: INV_STANDARD_PC

                Source Module:APPSTAND

                  Source Object: STANDARD_FOLDER

                Source Module:APPSTAND

                  Source Object: STANDARD_TOOLBAR

                Source Module:APPSTAND

                  Source Object: STANDARD_CALENDAR

                Source Module:INVSTAND

                  Source Object: MTL_ENABLED_TXN_TYPES

                Source Module:INVSTAND

                  Source Object: MTL_ENABLED_SOURCE_TYPES

                Source Module:CSTFQITD

                  Source Object: INV_TRANSACTION_DISTRIBUTION

                Source Module:CSTFQITD

                  Source Object: DISTRIBUTION_QF

                Compiling package specification PROJECT_PREQUERY...

                   No compilation errors.

                Compiling package specification INVTVTXN...

                   No compilation errors.

                Compiling package specification WMS_ADD...

                   No compilation errors.

                Compiling package specification ERES...

                   No compilation errors.

                Compiling package specification PROJECT_PREQUERY...

                   No compilation errors.

                Compiling package body PROJECT_PREQUERY...

                   No compilation errors.

                Compiling package specification INVTVTXN...

                   No compilation errors.

                Compiling package body INVTVTXN...

                Compilation error on package body INVTVTXN:

                PL/SQL ERROR 49 at line 64, column 8

                bad bind variable 'parameter.chart_of_accounts_id'

                PL/SQL ERROR 49 at line 64, column 8

                bad bind variable 'parameter.chart_of_accounts_id'

                PL/SQL ERROR 49 at line 69, column 26

                bad bind variable 'parameter.org_id'

                PL/SQL ERROR 49 at line 69, column 26

                bad bind variable 'parameter.org_id'

                Compiling package specification WMS_ADD...

                   No compilation errors.

                Compiling package body WMS_ADD...

                Compilation error on package body WMS_ADD:

                PL/SQL ERROR 49 at line 20, column 57

                bad bind variable 'PARAMETER.ORG_ID'

                PL/SQL ERROR 49 at line 20, column 57

                bad bind variable 'PARAMETER.ORG_ID'

                Compiling package specification ERES...

                   No compilation errors.

                Compiling package body ERES...

                   No compilation errors.

                Compiling procedure HEADER...

                   No compilation errors.

                 

                Compilation errors have occurred.

                Form not created

                 

                 

                It seems has dependencies missing?

                 

                Please help how to manually compile without error

                 

                Kind regards,

                • 6. Re: Patch 11659432 for EBS12.1.3
                  Bashar.

                  You must do one of the following before attempting to compile a form manually:

                   

                  • cd $AU_TOP/forms/US
                    OR
                  • export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

                   

                  Regards,

                  Bashar

                  1 person found this helpful
                  • 7. Re: Patch 11659432 for EBS12.1.3
                    Beauty_and_dBest

                    Thanks Bashar,

                     

                    I did that but still have these:

                     

                    Compiling package specification WMS_ADD...

                       No compilation errors.

                    Compiling package body WMS_ADD...

                    Compilation error on package body WMS_ADD:

                    PL/SQL ERROR 49 at line 20, column 57

                    bad bind variable 'PARAMETER.ORG_ID'

                    PL/SQL ERROR 49 at line 20, column 57

                    bad bind variable 'PARAMETER.ORG_ID'

                    Compiling package specification ERES...

                       No compilation errors.

                    Compiling package body ERES...

                       No compilation errors.

                    Compiling procedure HEADER...

                       No compilation errors.

                     

                    Compilation errors have occurred.

                     

                    Form not created

                     

                     

                    Kind regards,

                    • 8. Re: Patch 11659432 for EBS12.1.3
                      Bashar.

                      Please post the full message stack including the compilation command and the previous command.

                       

                      Regards,

                      Bashar

                      1 person found this helpful
                      • 9. Re: Patch 11659432 for EBS12.1.3
                        Beauty_and_dBest

                        Thanks,

                         

                        The command used is same above.

                         

                        Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

                        Forms 10.1 (Form Compiler): Release  - Production

                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                        Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

                             With the Partitioning, OLAP, Data Mining and Real Application Testing options

                        PL/SQL Version 10.1.0.5.0 (Production)

                        Oracle Procedure Builder V10.1.2.3.0 - Production

                        Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)

                        Oracle Multimedia Version 10.1.2.0.2 (Production)

                        Oracle Tools Integration Version 10.1.2.0.2 (Production)

                        Oracle Tools Common Area Version 10.1.2.0.2

                        Oracle CORE     10.1.0.5.0      Production

                        FRM-18108: Failed to load the following objects.

                        Source Module:CSTFQITD

                          Source Object: INV_TRANSACTION_DISTRIBUTION

                        Source Module:CSTFQITD

                          Source Object: C_DISTRIBUTIONS_1

                        Source Module:CSTFQITD

                          Source Object: C_DISTRIBUTIONS_2

                        Source Module:CSTFQITD

                          Source Object: C_DISTRIBUTIONS_3

                        Source Module:CSTFQITD

                          Source Object: C_DISTRIBUTIONS_4

                        Source Module:CSTFQITD

                          Source Object: C_DISTRIBUTIONS_5

                        Source Module:CSTFQITD

                          Source Object: DISTRIBUTION_QF

                        Source Module:CSTFQITD

                          Source Object: REVISION

                        Source Module:CSTFQITD

                          Source Object: INV_TRANSACTION_DISTRIBUTION

                        Source Module:APPSTAND

                          Source Object: STANDARD_PC_AND_VA

                        Source Module:INVSTAND

                          Source Object: INV_PARAMS

                        Source Module:INVSTAND

                          Source Object: INV_STANDARD_PC

                        Source Module:APPSTAND

                          Source Object: STANDARD_FOLDER

                        Source Module:APPSTAND

                          Source Object: STANDARD_TOOLBAR

                        Source Module:APPSTAND

                          Source Object: STANDARD_CALENDAR

                        Source Module:INVSTAND

                          Source Object: MTL_ENABLED_TXN_TYPES

                        Source Module:INVSTAND

                          Source Object: MTL_ENABLED_SOURCE_TYPES

                        Source Module:CSTFQITD

                          Source Object: INV_TRANSACTION_DISTRIBUTION

                        Source Module:CSTFQITD

                          Source Object: DISTRIBUTION_QF

                        Compiling package specification PROJECT_PREQUERY...

                           No compilation errors.

                        Compiling package specification INVTVTXN...

                           No compilation errors.

                        Compiling package specification WMS_ADD...

                           No compilation errors.

                        Compiling package specification ERES...

                           No compilation errors.

                        Compiling package specification PROJECT_PREQUERY...

                           No compilation errors.

                        Compiling package body PROJECT_PREQUERY...

                           No compilation errors.

                        Compiling package specification INVTVTXN...

                           No compilation errors.

                        Compiling package body INVTVTXN...

                        Compilation error on package body INVTVTXN:

                        PL/SQL ERROR 49 at line 64, column 8

                        bad bind variable 'parameter.chart_of_accounts_id'

                        PL/SQL ERROR 49 at line 64, column 8

                        bad bind variable 'parameter.chart_of_accounts_id'

                        PL/SQL ERROR 49 at line 69, column 26

                        bad bind variable 'parameter.org_id'

                        PL/SQL ERROR 49 at line 69, column 26

                        bad bind variable 'parameter.org_id'

                        Compiling package specification WMS_ADD...

                           No compilation errors.

                        Compiling package body WMS_ADD...

                        Compilation error on package body WMS_ADD:

                        PL/SQL ERROR 49 at line 20, column 57

                        bad bind variable 'PARAMETER.ORG_ID'

                        PL/SQL ERROR 49 at line 20, column 57

                        bad bind variable 'PARAMETER.ORG_ID'

                        Compiling package specification ERES...

                           No compilation errors.

                        Compiling package body ERES...

                           No compilation errors.

                        Compiling procedure HEADER...

                           No compilation errors.

                         

                        Compilation errors have occurred.

                         

                        Form not created

                         

                         

                        I think they are just the same because in the first , I have sourced the env. So wherever directory I am, it will still be okay?


                        Kind regards,

                        • 10. Re: Patch 11659432 for EBS12.1.3
                          Bashar.

                          The required libraries are either missing or not in the path.

                          Please post the output of the following command:

                           

                          ls -l $AU_TOP/resource/CSTFQITD* $AU_TOP/forms/US/CSTFQITD*

                           

                          Regards,

                          Bashar

                          1 person found this helpful
                          • 11. Re: Patch 11659432 for EBS12.1.3
                            Beauty_and_dBest

                            I think they are just the same becuase in the first , I have sourced the env. So wherever directory I am, it will still be okay

                             

                             

                            [appuat@erp US]$ ls -l $AU_TOP/resource/CSTFQITD* $AU_TOP/forms/US/CSTFQITD*

                            -rwxrwxrwx. 1 appuat dba 811008 Jan 19  2010 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/forms/US/CSTFQITD.fmb

                            -rwxrwxrwx. 1 appuat dba  94208 Mar 31  2009 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/resource/CSTFQITD.pll

                            -rwxrwxrwx. 1 appuat dba 126976 Mar  9 02:55 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/resource/CSTFQITD.plx

                             

                            [appuat@erp US]$ ls -l $AU_TOP/resource/INVTVTXN* $AU_TOP/forms/US/INVTVTXN*

                            -rwxr-xr-x. 1 appuat dba 2093056 Mar  9 02:15 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/forms/US/INVTVTXN.fmb

                            -rwxr-xr-x. 1 appuat dba  217088 Mar  9 02:15 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/resource/INVTVTXN.pll

                            -rwxrwxrwx. 1 appuat dba  299008 Mar  9 02:55 /u01/appuat/UAT/apps/apps_st/appl/au/12.0.0/resource/INVTVTXN.plx

                             

                             

                            Kind regards,

                            • 12. Re: Patch 11659432 for EBS12.1.3
                              Narsi M-Oracle

                              Hello Jenna,

                               

                              Following error is also seen while compiling:

                               

                              Compiling package body WMS_ADD...

                              Compilation error on package body WMS_ADD:

                              PL/SQL ERROR 49 at line 20, column 57

                              bad bind variable 'PARAMETER.ORG_ID'

                              PL/SQL ERROR 49 at line 20, column 57

                              bad bind variable 'PARAMETER.ORG_ID'



                              Could you please try to check on this as well.



                              Regards,

                              Narsi

                              • 13. Re: Patch 11659432 for EBS12.1.3
                                Beauty_and_dBest

                                Hi Narsi,

                                 

                                When this form is compile using adadmin, it does not get error. What is the syntax used in admin then?

                                 

                                 

                                Kind regards

                                • 14. Re: Patch 11659432 for EBS12.1.3
                                  Narsi M-Oracle

                                  Hello Jenna,

                                   

                                  When you compile forms using adadmin, it will use frmpcmp_batch.sh.

                                  You can check this by doing below:

                                  "ps -ef | grep frmpcmp" (Do this while compiling forms using adadmin and it will give the exact command used)

                                   

                                   

                                  Regards,

                                  Narsi

                                  1 person found this helpful
                                  1 2 Previous Next