Unable to Compile INVALIDS in Production.
Hi,
Welcome to Patching Community !!!
Issue: Unable to Compile INVALIDS in Production.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
52
SQL> col OBJECT_NAME for a30
SQL> select object_name,object_type,status from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------- -------
MSC_CL_PULL PACKAGE BODY INVALID
RLM_MANAGE_DEMAND_SV PACKAGE BODY INVALID
RLM_RD_SV PACKAGE BODY INVALID
ASO_QUOTE_HEADERS_PVT PACKAGE BODY INVALID
FV_FACTS_TRANSACTIONS PACKAGE BODY INVALID
FV_FACTS_TBAL_TRANSACTIONS PACKAGE BODY INVALID
FV_BUDGET_DISTRIBUTION_HDR_V VIEW INVALID
ASO_OPP_QTE_PUB PACKAGE BODY INVALID
Tagged:
0