Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 6241631-11i.ATG_PF.H.RUP7 : ORA-04063: package body "APPS.FND_WEB_SEC" has errors

edited Jun 10, 2012 3:57PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 comments
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 $ */
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center