Patch 6241631-11i.ATG_PF.H.RUP7 : ORA-04063: package body "APPS.FND_WEB_SEC" has errors
Hi,
Issue: While applying patch ATG RUP 7 getting the error:
sqlplus -s APPS/***** @/d02/oracle/devappl/fnd/11.5.0/patch/115/sql/afgstusr.sql &un_fnd &pw_fnd
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.FND_WEB_SEC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"
ORA-06512: at line 58
Cause: Mismatch of AFSCJAVS.pls version on system.
$ cd $FND_TOP/patch/115/sql
$ adident Header AFSCJAVS.pls
AFSCJAVS.pls:
$Header AFSCJAVS.pls 115.39 2007/11/22 15:10:14 stadepal ship $
$
SQL> select text from user_source where name = 'FND_WEB_SEC' and text like '%Header%';
TEXT
--------------------------------------------------------------------------------
/* $Header: AFSCJAVS.pls 115.37 2007/06/06 21:12:37 fskinner ship $ */
Issue: While applying patch ATG RUP 7 getting the error:
sqlplus -s APPS/***** @/d02/oracle/devappl/fnd/11.5.0/patch/115/sql/afgstusr.sql &un_fnd &pw_fnd
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.FND_WEB_SEC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"
ORA-06512: at line 58
Cause: Mismatch of AFSCJAVS.pls version on system.
$ cd $FND_TOP/patch/115/sql
$ adident Header AFSCJAVS.pls
AFSCJAVS.pls:
$Header AFSCJAVS.pls 115.39 2007/11/22 15:10:14 stadepal ship $
$
SQL> select text from user_source where name = 'FND_WEB_SEC' and text like '%Header%';
TEXT
--------------------------------------------------------------------------------
/* $Header: AFSCJAVS.pls 115.37 2007/06/06 21:12:37 fskinner ship $ */
Tagged:
0