My Oracle Support Banner

ODI Method odiRef.getColList() Changes Column Order in 12.2.1.4 (Doc ID 2660787.1)

Last updated on OCTOBER 13, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading Oracle Data Integrator (ODI) 11g to ODI 12.2.1.2.4, the odiRefgetColList() method in the loading knowledge module queries columns in a different order. 

For example, a table is defined in the following order. COLUMN2 has a transformation. This is the order generated by an interface in ODI 11g:

TABLE.COLUMN1,
REPLACE (Table.Column2,'"','')
TABLE.COLUMN3,
TABLE.COLUMN4

After upgrading to ODI 12.2.1.2.4, the order is changed in the same mapping, with COLUMN2 moved to the end:

TABLE.COLUMN1,
TABLE.COLUMN3,
TABLE.COLUMN4,
REPLACE (Table.Column2,'"','')

This results in a mapping execution failure, or incorrect data.

Changes

Upgraded from ODI 11g to ODI 12.2.1.4

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
Changes
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.