R12.1.3 : PACKAGE BODY APPS.IBY_UPG_PPP_PKG is invalid
Hi,
On application of patch 12803250 the following error is encountered
PACKAGE BODY APPS.IBY_UPG_PPP_PKG
On line: 191
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
The package version and error are :
SQL> select text from user_source where name='IBY_UPG_PPP_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: ibypppus.pls 120.3.12010000.3 2009/12/15 01:47:36 svinjamu ship $ */
/* $Header: ibypppub.pls 120.3.12010000.6 2009/12/15 01:49:19 svinjamu ship $
*/
SQL> alter package IBY_UPG_PPP_PKG compile;
Warning: Package altered with compilation errors.
SQL> select line,text from user_errors where name='IBY_UPG_PPP_PKG';
LINE
----------
TEXT
--------------------------------------------------------------------------------
191
PL/SQL: ORA-00904: "INACTIVE_DATE": invalid identifier
102
PL/SQL: SQL Statement ignored