10 Replies Latest reply: Feb 13, 2013 7:51 AM by 990595 RSS

    adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be

    990595
      Hi Guru's....

      This is my first post.I am a new dba.

      while applying adpatch , I am getting the below error.Please help. this is on r12.

      About to do IREP processing...

      Attempting to process IREP files ...

      AutoPatch error:
      Error in adusnapRunAdPostPatch() while executing statement

      AutoPatch error:
      ORA-06550: line 1, column 16:
      PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      ORA-06512: at "APPS.FND_GLOBAL", line 413
      ORA-06512: at "APPS.FND_GLOBAL", line 2272
      ORA-06512: at "APPS.FND_GLOBAL", line 2546
      ORA-06512: at "APPS.FND_GLOBAL", line 2698
      ORA-06512: at "APPS.FND_GLOBAL", line 2636
      ORA-06512: at "APPS.FND_ADPATCH", line 53
      ORA-06512: at line 3


      Error while processing IREP files, continuing...

      Done IREP processing.

      Thank you.....
        • 1. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.

          What is the patch number you are applying?

          Do you have any invalid objects in the database?

          Did you apply all pre-req. patches mentioned in the patch README file?

          Thanks,
          Hussein
          • 2. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
            Rrademak-Oracle
            Hi,

            Please check if this function exist when you do a :

            sqlplus apps/<pass>
            desc FND_DATE


            Upload the result of:

            column rcsid format a35 word
            break on name skip 1
            select name
            , type
            , substr(text,instr(text,'$Header: ')+9,
            instr(text,' ',instr(text,'$Header: '),4)
            - instr(text,'$Header: ') - 9) rcsid
            from all_source
            where text like '%$Header: %'
            and name like upper('%%FND_DATE%%') escape '\'
            order by name
            , type
            /
            undefine 1
            clear breaks

            Also let me know which patch you are trying to Apply.

            Regards,
            Ronald
            • 3. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
              990595
              Hi Ronald and Hussein,


              Thank you for your response.
              There are no invalids in my environment.
              I am applying
              R12.1.X: FORMS INTEROPERABILITY PATCH FOR 10.1.2.3 -- 13001977

              >>
              OS:

              SunOS sandebus03 5.10 Generic_147440-01 sun4v sparc SUNW,T5240


              >>


              RELEASE_NAME
              --------------------------------------------------
              12.1.2


              DB:11.2.0.3


              >>
              SQL> desc fnd_date
              FUNCTION ADJUST_DATETIME RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATE_TIME DATE IN
              FROM_TZ VARCHAR2 IN
              TO_TZ VARCHAR2 IN
              FUNCTION CANONICAL_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CANONICAL VARCHAR2 IN
              FUNCTION CHARDATE_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CHARDATE VARCHAR2 IN
              FUNCTION CHARDT_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CHARDT VARCHAR2 IN
              FUNCTION DATE_TO_CANONICAL RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              FUNCTION DATE_TO_CHARDATE RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              FUNCTION DATE_TO_CHARDT RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              FUNCTION DATE_TO_DISPLAYDATE RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              FUNCTION DATE_TO_DISPLAYDT RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              FUNCTION DATE_TO_DISPLAYDT RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              DATEVAL DATE IN
              NEW_CLIENT_TZ_CODE VARCHAR2 IN
              FUNCTION DISPLAYDATE_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CHARDATE VARCHAR2 IN
              FUNCTION DISPLAYDT_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CHARDT VARCHAR2 IN
              FUNCTION DISPLAYDT_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              CHARDT VARCHAR2 IN
              NEW_CLIENT_TZ_CODE VARCHAR2 IN
              PROCEDURE INITIALIZE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              P_USER_MASK VARCHAR2 IN
              P_USERDT_MASK VARCHAR2 IN DEFAULT
              FUNCTION STRING_TO_CANONICAL RETURNS VARCHAR2
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              P_STRING VARCHAR2 IN
              P_MASK VARCHAR2 IN
              FUNCTION STRING_TO_DATE RETURNS DATE
              Argument Name Type In/Out Default?
              ------------------------------ ----------------------- ------ --------
              P_STRING VARCHAR2 IN
              P_MASK VARCHAR2 IN
              PROCEDURE TEST

              SQL>

              >>
              SQL> column rcsid format a35 word
              break on name skip 1
              SQL> select name,type,substr(text,instr(text,'$Header: ')+9,
              instr(text,' ',instr(text,'$Header: '),4)
              SQL> 2 3 - instr(text,'$Header: ') - 9) rcsid
              4 from all_source
              5 where text like '%$Header: %'
              6 and name like upper('%%FND_DATE%%') escape '\'
              7 order by name
              8 , type
              9 /
              undefine 1
              clear breaks

              NAME TYPE RCSID
              ------------------------------ ------------ -----------------------------------
              FND_DATE PACKAGE AFDDATES.pls 115.11 2003/10/28
              PACKAGE BODY AFDDATEB.pls 120.1 2005/07/02

              FND_DATE_TZ PACKAGE AFDATTZS.pls 115.4 2003/10/28
              PACKAGE BODY AFDATTZB.pls 115.4 2003/10/28


              SQL> SQL> breaks cleared
              SQL>
              • 4. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                Hussein Sawwan-Oracle
                Do you have any invalid objects in the database?
                NAME TYPE RCSID
                ------------------------------ ------------ -----------------------------------
                FND_DATE PACKAGE AFDDATES.pls 115.11 2003/10/28
                PACKAGE BODY AFDDATEB.pls 120.1 2005/07/02

                FND_DATE_TZ PACKAGE AFDATTZS.pls 115.4 2003/10/28
                PACKAGE BODY AFDATTZB.pls 115.4 2003/10/28
                Please see the solutions in these docs.

                ORA-04062: signature of package APPS.FND_DATE has been changed APP-FND-01926 [ID 1442096.1]
                R12: Patch 10281212 fails with error "component 'CALENDAR_AWARENESS_PROFILE' must be declared" for APPCORE.pll and APPCORE2.pll [ID 1359027.1]

                Thanks,
                Hussein
                • 5. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                  990595
                  Hi Hussein,

                  I have followed the MOS :ORA-04062: signature of package APPS.FND_DATE has been changed APP-FND-01926 [ID 1442096.1]

                  and recreated the packages AFSCGBLS.pls and AFSCGBLB.pls , which are related to FND_GLOBAL.But after doing this , My front itself is not coming up.

                  I have the below two invalids , which are acceptable in my environment.

                  OWNER OBJECT_NAME OBJECT_TYPE STATUS
                  ------- ------------------------------ --------------- -------
                  APPS IGW_REPORT_PROCESSING PACKAGE BODY INVALID
                  APPS IGW_BUDGET_CATEGORY_V VIEW INVALID

                  SQL>

                  I tried compiling apps schema,recreating grants and synonyms, relinking,compiling jsp etc...but of no use.

                  Accroding to the note : 1359027.1
                  SQL> select text from dba_source where name='FND_DATE' and line=2;

                  TEXT
                  --------------------------------------------------------------------------------
                  /* $Header: AFDDATES.pls 115.11 2003/10/28 16:04:13 psloan ship $ */
                  -- $Header: AFDDATEB.pls 120.1 2005/07/02 04:04:35 appldev ship $

                  strings -a $FND_TOP/patch/115/sql/AFDDATEB.pls|grep Header
                  -- $Header: AFDDATEB.pls 120.1.12010000.5 2010/05/20 00:56:58 dbowles ship $

                  Hussein , I have doubt ..is my issue related to FND_GLOABL or with FND_DATE?


                  Thank you....
                  • 6. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                    Hussein Sawwan-Oracle
                    I have followed the MOS :ORA-04062: signature of package APPS.FND_DATE has been changed APP-FND-01926 [ID 1442096.1]
                    What is the status of the package?
                    and recreated the packages AFSCGBLS.pls and AFSCGBLB.pls , which are related to FND_GLOBAL.But after doing this , My front itself is not coming up.
                    Have you bounced the services?
                    I have the below two invalids , which are acceptable in my environment.

                    OWNER OBJECT_NAME OBJECT_TYPE STATUS
                    ------- ------------------------------ --------------- -------
                    APPS IGW_REPORT_PROCESSING PACKAGE BODY INVALID
                    APPS IGW_BUDGET_CATEGORY_V VIEW INVALID
                    Yes they are acceptable but are there any other invalid objects?
                    Accroding to the note : 1359027.1
                    SQL> select text from dba_source where name='FND_DATE' and line=2;

                    TEXT
                    --------------------------------------------------------------------------------
                    /* $Header: AFDDATES.pls 115.11 2003/10/28 16:04:13 psloan ship $ */
                    -- $Header: AFDDATEB.pls 120.1 2005/07/02 04:04:35 appldev ship $

                    strings -a $FND_TOP/patch/115/sql/AFDDATEB.pls|grep Header
                    -- $Header: AFDDATEB.pls 120.1.12010000.5 2010/05/20 00:56:58 dbowles ship $

                    Hussein , I have doubt ..is my issue related to FND_GLOABL or with FND_DATE?
                    Looks like the error is related to both packages. Would you please verify again the status of these 2 packages?

                    Thanks,
                    Hussein
                    • 7. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                      990595
                      Hussein,


                      OWNER OBJECT_NAME OBJECT_TYPE STATUS
                      ------- ------------------------------ --------------- -------
                      APPS FND_GLOBAL PACKAGE VALID
                      APPS FND_GLOBAL PACKAGE BODY VALID
                      APPS FND_DATE PACKAGE VALID
                      APPS FND_DATE PACKAGE BODY VALID




                      I red some where the below.

                      Set the Parameter:REMOTE_DEPENDENCIES_MODE> to SIGNATURE on releases supporting this.


                      What you think...will this support to my DB Version? will this work?

                      Yes , I have bounced the services , ran autoconfig on both db and apps..which was successful..



                      Shall I recreated the FND_DATE packages as well as per the given note? will that helps?


                      Thank you...
                      • 8. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                        990595
                        --------------------------------------------------------------------------------
                        /* $Header: AFSCGBLS.pls 120.6.12010000.5 2010/03/21 09:08:42 absandhw ship $ */

                        /* $Header: AFSCGBLB.pls 120.32.12010000.22 2010/05/04 13:50:18 absandhw ship
                        $ */


                        ksh-sandebus03(applmgr/oed6bas2): strings -a $FND_TOP/patch/115/sql/AFSCGBLB.pls|grep Header
                        /* $Header: AFSCGBLB.pls 120.32.12010000.22 2010/05/04 13:50:18 absandhw ship $ */
                        /* $Header: AFSCGBLS.pls 120.6.12010000.5 2010/03/21 09:08:42 absandhw ship $ */
                        ksh-sandebus03(applmgr/oed6bas2)
                        • 9. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                          Hussein Sawwan-Oracle
                          Shall I recreated the FND_DATE packages as well as per the given note? will that helps?
                          If it is higher, then it may help -- Please take a backup of the existing package code before you recreate it then re-apply the patch.

                          Thanks,
                          Hussein
                          • 10. Re: adpatch fails with PLS-00302: component 'INITIALIZE_WITH_CALENDAR' must be
                            990595
                            Thanks hussein....

                            now the front end and the forms are opening fine....
                            will take a backup before I apply the patch again.

                            Thank you sooo much for your help in this.....