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

MOSC Banner

EB Invalid objects: 11.5.10.2 to 12.1.3 upgrade - Linux x86-64

edited Mar 25, 2013 10:39PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
Michael says:Invalid objects After  upgrading from 11.5.10.2 to 12.1.3
VIEW                         EB_AR_CUSTOMERS_V   
PACKAGE BODY                 EB_PARTY_CUSTOMER_PVT

VIEW                         EB_AR_CUSTOMERS_V    
PACKAGE BODY                 EB_PARTY_CUSTOMER_PVT
***********************************************************
SQL> alter view EB_AR_CUSTOMERS_V compile;

Warning: View altered with compilation errors.

SQL> show error;
Errors for PACKAGE BODY ARP_STAX_MINUS99:

LINE/COL ERROR
-------- -----------------------------------------------------------------
370/9    PLS-00341: declaration of cursor 'SEL_CC' is incomplete or
       malformed

371/9    PL/SQL: SQL Statement ignored
384/16   PL/SQL: ORA-00942: table or view does not exist
387/25   PL/SQL: Item ignored
393/9    PL/SQL: SQL Statement ignored
393/27   PLS-00320: the declaration of the type of this expression is
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