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

MOSC Banner

Invalids after applying Patch RUB6(16000686)

edited Jun 20, 2013 7:34AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
Hi,

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

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