11.5.10.2 : Invalid package INV_DCP_PVT after applying Patch No. 6241631 (ATG RUP 7)
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 :
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:
0