Invalids after applying Patch RUB6(16000686)
Customer applied the patch RUB6(16000686) and there are generate 2 invalid objects.
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------------------ -------------------------------------------------- ------------------- ----------
APPS OPI_EDW_COGS_F_C PACKAGE BODY INVALID
APPS HR_EDW_WRK_CMPSTN_F_C PACKAGE BODY INVALID
SQL> alter package APPS.OPI_EDW_COGS_F_C compile body;
alter package APPS.OPI_EDW_COGS_F_C compile body
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
APPS.EDW_LOCAL_INSTANCE@EDW_APPS_TO_WH.GRUPOMAYAN.LOCAL
ORA-00604: error occurred at recursive SQL level 1
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from EDW_APPS_TO_WH