10 Replies Latest reply on Jun 1, 2015 6:18 AM by Mohammed Abdul Muqeet

    R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors

    Mohammed Abdul Muqeet

      Dear All,

       

      We are getting this Error while apply the R12.2.4 upgrade patch  (12.2.0 to R12.2.4) patch.

       

      Error

       

       

      sqlplus -s APPS/***** @/app/u01/d02/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/app/u01/d02/fs1/EBSapps/appl/csm/12.0.0/patch/115/sql/csmlobmf.sql &un_apps &pw_apps'

      Connected.

       

      PL/SQL procedure successfully completed.

           

      DECLARE

      *

      ERROR at line 1:

      ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors

      ORA-06508: PL/SQL: could not find program unit being called:

      "APPS.CSM_UTIL_PKG"

      ORA-06512: at line 211

      ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors

      ORA-06508: PL/SQL: could not find program unit being called:

      "APPS.CSM_UTIL_PKG

       

      Regards

      Mohammed Abdul Muqeet

        • 1. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
          Jagadekara

          Hi,

           

          Did you check CSM_UTIL_PKG?

           

          select * from all_errors where name='CSM_UTIL_PKG';

          • 2. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
            Mohammed Abdul Muqeet

            SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jun 1 06:05:59 2015

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

            Connected to:

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

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

             

            SQL> select * from all_errors where name='CSM_UTIL_PKG';

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     1        262         10

            PLS-00323: subprogram or cursor 'IS_HTML5_USER' is declared in a package specifi

            cation and must be defined in the package body

            ERROR                323

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     2        263         10

            PLS-00323: subprogram or cursor 'IS_HTML5_USER' is declared in a package specifi

            cation and must be defined in the package body

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            ERROR                323

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     3        264         10

            PLS-00323: subprogram or cursor 'GET_INQ_TAB' is declared in a package specifica

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            tion and must be defined in the package body

            ERROR                323

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     4        265         10

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            PLS-00323: subprogram or cursor 'BOOL2YN' is declared in a package specification

            and must be defined in the package body

            ERROR                323

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

                     5        266         10

            PLS-00323: subprogram or cursor 'GET_FND_USER_LANGUAGE' is declared in a package

            specification and must be defined in the package body

            ERROR                323

             

             

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     6        267         10

            PLS-00323: subprogram or cursor 'GET_STRING_FROMLIST' is declared in a package s

            pecification and must be defined in the package body

            ERROR                323

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     7        268         10

            PLS-00323: subprogram or cursor 'IS_OPERATION_ALLOWED' is declared in a package

            specification and must be defined in the package body

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            ERROR                323

             

             

            APPS                           CSM_UTIL_PKG                   PACKAGE BODY

                     8        269         10

            PLS-00323: subprogram or cursor 'GET_ASSOCIATED_TASK_NUMBER' is declared in a pa

             

             

            OWNER                          NAME                           TYPE

            ------------------------------ ------------------------------ ------------

              SEQUENCE       LINE   POSITION

            ---------- ---------- ----------

            TEXT

            --------------------------------------------------------------------------------

            ATTRIBUTE MESSAGE_NUMBER

            --------- --------------

            ckage specification and must be defined in the package body

            ERROR                323

             

            8 rows selected.

            SQL>

             

            Regards

            Mohammed Abdul Muqeet

            • 3. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
              Jagadekara

              hi,

               

              It clearly shows errors.

               

              Have you changed this package?

               

              Which version you are using?

              • 4. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                Mohammed Abdul Muqeet

                We Were in the process of doing an upgrade from R12.2.0 to R12.2.4 .. While applying the patch for R12.2.4 upgrade one of the worker has failed and we have noticed this error in the worker logfile. Then we have tried compiling the invalid objects using adadmin and utlrp.sql script.

                 

                regards

                Mohammed

                • 5. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                  Jagadekara

                  Ok,

                   

                  Check any test instance, that code is same as in current instance code or not?

                   

                  Some objects declared in package specification and those are not in package body.

                   

                  I checked in my instance, we don't have those errors.

                   

                  Use diffnow.com to compare code.

                  • 6. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                    Pk

                    Check the dependencies in dba_depedencies, if any other object needs to be upgraded.

                    There could be a chance that other module is pointing to this object.

                    • 7. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                      Mohammed Abdul Muqeet

                      cd $CSM_TOP/patch/115/sql

                      sqlplus apps/...

                      @csmeutlb.pls

                       

                      Check if the package body CSM_UTIL_PKG is valid. Then restart the adop

                       

                       

                      And our patch got restarted. Will keep you posted.

                       

                      Appreciate your quick response each time.

                       

                      Regards

                      Mohammed Abdul Muqeet

                      • 8. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                        Mohammed Abdul Muqeet

                        SQL>  select object_type,status from dba_objects where object_name = 'CSM_UTIL_PKG' and owner = 'APPS';

                         

                        OBJECT_TYPE         STATUS

                        ------------------- -------

                        PACKAGE             VALID

                        PACKAGE BODY        VALID

                        • 10. Re: R12.2.4 Patch failed due to  ORA-04063: package body "APPS.CSM_UTIL_PKG" has errors
                          Mohammed Abdul Muqeet

                          Yes - i have restarted the adop after the above step suggested by SR support and now it is working fine.

                           

                          regards

                          Mohammed