EDW Related Invalid Objects
(Doc ID 554036.1)
Last updated on FEBRUARY 08, 2024
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.
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |