OBIA 11g: Unable To Access Objects/packages With Db Link From Target To Source Database 'ORA-06512: at "APPS.AP_INVOICES_UTILITY_PKG"' (Doc ID 2285505.1)

Last updated on JULY 13, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

Customer has a complex setup of replication using Golden Gate and Informatica and using ODI for BIApps

Oracle EBS: Not able to access objects using db link from Target to Source db

ORA-00942: table or view does not exist
ORA-06512: at "APPS.AP_INVOICES_UTILITY_PKG", line 620
ORA-06512: at line 1

To narrow down to the SQL statement which is failing on AP_INVOICES_UTILITY_PKG even from Toad/SQL-Developer (this fails in BIApps mapping but with a simple test case this fails in Toad/SQL-Developer so it’s a core EBS package access issue)

In summary this is not a BIApps OR ODI for issue now - it’s purely a EBS package access issue.

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