11.5.10.2 : Invalid Package ARP_PROCESS_APPLICATION after patching
Hi,
Installing SEPA patches for 11.5.10.2,
applied merged patches : 13434486, 13510283, 6246635, 7585468, 8452606, 8529225, 8623783 and 8627857 (SEPA patches + prerequisites and corequisites)
the package ARP_PROCESS_APPLICATION is invalid :
SQL> select text from user_source where name='ARP_PROCESS_APPLICATION' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: ARCEAPPS.pls 115.36.15104.9 2007/05/23 06:55:16 mpsingh ship $ */
/* $Header: ARCEAPPB.pls 115.117.15104.18 2008/08/14 13:35:46 mgaleti ship $ */
SQL> alter package ARP_PROCESS_APPLICATION compile;
Warning: Package altered with compilation errors.
SQL> select line,text from user_errors where name='ARP_PROCESS_APPLICATION';
LINE TEXT
---------- --------------------------------------------------------------------------------
328 PLS-00302: component 'ON_ACCT_CUST_ID' must be declared
270 PL/SQL: Declaration ignored
479 PLS-00302: component 'ON_ACCT_CUST_ID' must be declared
406 PL/SQL: Declaration ignored
Installing SEPA patches for 11.5.10.2,
applied merged patches : 13434486, 13510283, 6246635, 7585468, 8452606, 8529225, 8623783 and 8627857 (SEPA patches + prerequisites and corequisites)
the package ARP_PROCESS_APPLICATION is invalid :
SQL> select text from user_source where name='ARP_PROCESS_APPLICATION' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: ARCEAPPS.pls 115.36.15104.9 2007/05/23 06:55:16 mpsingh ship $ */
/* $Header: ARCEAPPB.pls 115.117.15104.18 2008/08/14 13:35:46 mgaleti ship $ */
SQL> alter package ARP_PROCESS_APPLICATION compile;
Warning: Package altered with compilation errors.
SQL> select line,text from user_errors where name='ARP_PROCESS_APPLICATION';
LINE TEXT
---------- --------------------------------------------------------------------------------
328 PLS-00302: component 'ON_ACCT_CUST_ID' must be declared
270 PL/SQL: Declaration ignored
479 PLS-00302: component 'ON_ACCT_CUST_ID' must be declared
406 PL/SQL: Declaration ignored
Tagged:
0