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

MOSC Banner

11.5.10.2 : Invalid package INV_DCP_PVT after applying Patch No. 6241631 (ATG RUP 7)

edited Apr 7, 2013 4:34AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
HI,

Invalid package INV_DCP_PVT after applying Patch No. 6241631 (ATG RUP 7)

Error
SQL> alter package apps.INV_DCP_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.INV_DCP_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
762/4    PL/SQL: Statement ignored
762/52   PLS-00302: component 'SOURCE_LOT_NUMBER' must be declared
SQL> alter package apps.FND_OID_DIAG compile body;

Warning: Package Body altered with compilation errors.

version


SQL> select text from user_source where name='INV_DCP_PVT' and line=2;

TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------
/* $Header: INVDCPPS.pls 115.0.115100.3 2006/01/06 02:14:26 anverma noship $ */
/* $Header: INVDCPPB.pls 115.0.115100.4 2006/01/06 02:15:52 anverma noship $ */


Code creating the error :
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