OBIA 11g: Using a Dblink Causes The OBIA Load Plan To Fail ODI-1228 Task SDE_ORA_EmployeeExpenseCreditCardFact.W_EXPENSE_CC_FS (Integration) fails on the target ORACLE connection BIAPPS_DW
(Doc ID 1998808.1)
Last updated on FEBRUARY 15, 2019
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
When setting the OBIA load plan to run using a dblink in BIACM, the following error is shown:
Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
This error does not occur when the DBLINK is not enabled.
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