Invalid objects (AHL) after applying patch 13973499 - R12.1.3.5: cMRO Rollup Patch
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