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

MOSC Banner

Invalid objects (AHL) after applying patch 13973499 - R12.1.3.5: cMRO Rollup Patch

edited Aug 22, 2013 3:39AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered ✓

Find that the below objects have become invalid after applying patch 13973499 - R12.1.3.5: cMRO Rollup Patch

OWNER                          OBJECT_NAME                                   OBJECT_TYPE

------------------------------ --------------------------------------------- -------------------

APPS                           AHL_CMP_UTIL_PKG                              PACKAGE BODY

APPS                           AHL_COMPLEX_MX_PVT                            PACKAGE BODY

APPS                           AHL_COMPLEX_MX_RWSC_PVT                       PACKAGE BODY

Below is the errors

SQL> alter package AHL_COMPLEX_MX_RWSC_PVT compile body;

 

Warning: Package Body altered with compilation errors.

 

SQL> show error

Errors for PACKAGE BODY AHL_COMPLEX_MX_RWSC_PVT:

 

LINE/COL ERROR

-------- -----------------------------------------------------------------

1539/9   PLS-00341: declaration of cursor 'GET_INSTANCE_ATTRIBUTES' is

         incomplete or malformed

 

1540/2   PL/SQL: SQL Statement 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