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

MOSC Banner

Unable to Compile INVALIDS in Production.

edited Jun 25, 2018 12:48PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 9 commentsAnswered ✓
 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:

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