After installting ASCP, the number of invalid objects has been increased.
Hi Vivek,
Welcome to Patching community !!!
Issue:
After installting ASCP, the number of invalid objects has been increased by 7 and while compiling them we have been facing errors.
select object_name,object_type,owner from dba_objects where status='INVALID';SQL
OBJECT_NAME OBJECT_TYPE OWNER
----------------------------------- ----------------------------------- --------
AHL_OSP_RCV_PVT PACKAGE BODY APPS
AHL_CMP_UTIL_PKG PACKAGE BODY APPS
AHL_COMPLEX_MX_PVT PACKAGE BODY APPS
AHL_COMPLEX_MX_RWSC_PVT PACKAGE BODY APPS
MSC_EXA_UTIL PACKAGE BODY APPS
7 rows selected.
SQL> alter PACKAGE AHL_OSP_RCV_PVT compile BODY;
Warning: Package Body altered with compilation errors.
select object_name,object_type,owner from dba_objects where status='INVALID';SQL
OBJECT_NAME OBJECT_TYPE OWNER
----------------------------------- ----------------------------------- --------
AHL_OSP_RCV_PVT PACKAGE BODY APPS
AHL_CMP_UTIL_PKG PACKAGE BODY APPS
AHL_COMPLEX_MX_PVT PACKAGE BODY APPS
AHL_COMPLEX_MX_RWSC_PVT PACKAGE BODY APPS
MSC_EXA_UTIL PACKAGE BODY APPS
7 rows selected.
SQL> alter PACKAGE AHL_OSP_RCV_PVT compile BODY;
Warning: Package Body altered with compilation errors.
Tagged:
1