Wrong Source used by ODI when a Variable is Named the Same as a Target Column
Last updated on JUNE 15, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 12c]
Information in this document applies to any platform.
When executing a mapping in Oracle Data Integrator (ODI) which transfers data to a target table that has a column with the same name as a variable (global or local), ODI will incorrectly generate SQL code using the variable name instead of the source column.
For example, when there is a variable named "SAMPLE_REF_CODE" that matches the name of the target column, the source will be replaced with the variable reference instead of the mapped source column.
This issue occurs when using a Loading Knowledge Module (LKM) based on the binding mechanism (on step "Insert new rows"), such as "LKM SQL to Oracle (Built-In)" or "LKM SQL to SQL (Built-In)".
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