OBIA 11g: Unable To Access Objects/packages With Db Link From Target To Source Database 'ORA-06512: at "APPS.AP_INVOICES_UTILITY_PKG"'
Last updated on JULY 13, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
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.
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