Wrong Source Used by ODI when a Variable is Named the Same as a Target Column
(Doc ID 2406432.1)
Last updated on OCTOBER 28, 2019
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
When executing a mapping or procedure 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)".
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