Data Type Errors When Loading Using The Database Link Mode To Load Data Into The BI Applications (Doc ID 1991060.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.8.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

To increase performance of the Data Load Process (ELT), Database Link Mode was enabled to load the Data Warehouse from EBS 12.1.3 to BI Applications 11.1.1.8.1 instance by using the "Is DBLink to Source Available" data load parameter set to True (Parameter Code: ETL_SRC_VIA_DBLINK), executed the Data Load and getting as results the below errors messages on different tasks. Including the following two:

1) SDE_ORA_EmployeeExpenseCreditCardFact.W_EXPENSE_CC_FS ORA-01790: expression must have same datatype as corresponding expression
2) SDE_ORA_CSTItemCostDailyFact.W_CST_ITEM_COST_DAILY_FS ORA-00932: inconsistent datatypes: expected NUMBER got CHAR

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