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

MOSC Banner

After Applying 11.2.10.2 Maintenance Pack, There are Packages that Cannot be Compiled

edited Oct 19, 2013 4:38AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 11 commentsAnswered
Hi,
Unable to compile the below packages.

OBJECT_NAME                    OBJECT_TYPE         STATUS
------------------------------ ------------------- -------
GL_MC_INQUIRY_PKG              PACKAGE             VALID
GL_MC_INQUIRY_PKG              PACKAGE BODY        INVALID

AR_RECEIVABLE_APPLICATIONS     VIEW                INVALID
AR_RECEIVABLE_APPLICATIONS     SYNONYM             INVALID

AR_RECEIVABLE_APPS_MRC_V       VIEW                INVALID
AR_RECEIVABLE_APPS_MRC_V       SYNONYM             INVALID



SQL> ALTER PACKAGE apps.GL_MC_INQUIRY_PKG COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY APPS.GL_MC_INQUIRY_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
980/7    PL/SQL: SQL Statement ignored
1065/19  PL/SQL: ORA-04063: view "APPS.AR_RECEIVABLE_APPLICATIONS" has errors
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