EDW Related Invalid Objects (Doc ID 554036.1)

Last updated on JULY 26, 2017

Applies to:

Oracle E-Business Intelligence - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Oracle Operations Intelligence - Version 11.5.9 to 12.0.4 [Release 11.5 to 12.0]
Oracle Procurement Intelligence - Version 11.5.9 to 12.0.4 [Release 11.5 to 12.0]
Information in this document applies to any platform.
Checked for relevance on 12-MAR-2013

Symptoms

Both database objects EDW_MTL_INVENTORY_LOC_M_C and EDW_GEOGRAPHY_M_C appear as invalid objects.

When manually compiling the objects messages such as these are common:

09/4 PL/SQL: SQL Statement ignored
147/9 PL/SQL: ORA-04052: error occurred when looking up remote object
APPS.EDW_GEOG_LOCATION_LCV@APPS_TO_APPS.<name>.COM
ORA-00604: error occurred at recursive SQL level 1
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from APPS_TO_APPS

211/4 PL/SQL: SQL Statement ignored
259/7 PL/SQL: ORA-04052: error occurred when looking up remote object
APPS.EDW_GEOG_POSTCODE_CITY_LCV@APPS_TO_APPS.<name>.COM
ORA-00604: error occurred at recursive SQL level 1

LINE/COL ERROR
-------- -----------------------------------------------------------------
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from APPS_TO_APPS

304/4 PL/SQL: SQL Statement ignored
349/9 PL/SQL: ORA-04052: error occurred when looking up remote object
APPS.EDW_GEOG_CITY_LCV@APPS_TO_APPS.<name>.COM
ORA-00604: error occurred at recursive SQL level 1
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from APPS_TO_APPS

394/4 PL/SQL: SQL Statement ignored

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms