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

MOSC Banner

11.5.10.2 : Invalid Package ARP_PROCESS_APPLICATION after patching

edited Oct 9, 2013 5:03AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓
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
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