My Oracle Support Banner

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 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

When setting the OBIA load plan to run using a dblink in BIACM, the following error is shown:

ODI-1228: Task SDE_ORA_EmployeeExpenseCreditCardFact.W_EXPENSE_CC_FS (Integration) fails on the target ORACLE connection BIAPPS_DW.
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.

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.