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

MOSC Banner

VCP 12.1.3.8 PATCH has invalidated objects

edited Dec 9, 2012 10:53PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓
Problem Summary---------------------------------------------------
VCP Patch invalides objects related to "MSC_CL_AHL_" and "MSC_RP_PUB"

Problem Description
---------------------------------------------------
VCP 12.1.3.8 PATCH has invalidated the following objects:

 1* select * from dba_errors where type != 'JAVA CLASS'
SQL> /

OWNER                          NAME                           TYPE
------------------------------ ------------------------------ ------------
 SEQUENCE       LINE   POSITION
---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
APPS                           MSC_CL_AHL_ODS_LOAD            PACKAGE BODY
        1       2596         71
PLS-00357: Table,View Or Sequence reference 'MSC_SUPPLIES_S.NEXTVAL' not allowed
in this context
ERROR                357

APPS                           MSC_CL_AHL_ODS_LOAD            PACKAGE BODY
        2       2596         21
PL/SQL: Statement ignored
ERROR                  0

APPS                           MSC_RP_PUB                     PACKAGE BODY
        1        230         29
PLS-00382: expression is of wrong type
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