This discussion is archived
10 Replies Latest reply: Feb 13, 2013 5:51 AM by 990595 RSS

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

990595 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    --------------------------------------------------------------------------------
    /* $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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points