My Oracle Support Banner

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

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.200618 [Release 12c]
Information in this document applies to any platform.

Symptoms

After upgrading Oracle Data Integrator (ODI) 11g to ODI 12.2.1.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:

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!

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