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

MOSC Banner

After apply few patches PSA_AP_BC_PVT package body is invalid.

edited Sep 10, 2012 12:43AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
Hi,

After apply few patches  PSA_AP_BC_PVT package body is invalid.

QL> select *
from dba_source
where name =  2    3  'PSA_AP_BC_PVT' and instr(text,'$Header')<>0;

OWNER            NAME                           TYPE               LINE
---------------- ------------------------------ ------------ ----------
TEXT
--------------------------------------------------------------------------------
APPS             PSA_AP_BC_PVT                  PACKAGE               2
--$Header: psavapbs.pls 120.12.12010000.2 2008/08/04 07:16:44 cjain ship $

APPS             PSA_AP_BC_PVT                  PACKAGE BODY          2
--$Header: psavapbb.pls 120.49.12010000.26 2010/10/27 20:17:56 sasukuma ship $

APPS             PSA_AP_BC_PVT                  PACKAGE BODY         37
      '$Header: psavapbb.pls 120.49.12010000.26 2010/10/27 20:17:56 sasukuma sh
ip $';


QL> alter package PSA_AP_BC_PVT compile body
 2  ;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY PSA_AP_BC_PVT:
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