My Oracle Support Banner

Case Sensitivity of Header Records Is Lost After Update of "IKM SQL To File Append" with ODI 11g Mandatory Changes (Doc ID 1684203.1)

Last updated on NOVEMBER 02, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 1.0.2 to 1.0.2
Oracle Data Integrator - Version 11.1.1.3.0 to 12.2.1.3.200626 [Release 11gR1 to 12c]
Information in this document applies to any platform.

Symptoms

NOTE: In the examples below, column names represent a fictitious sample. Any similarity to actual tablenames, is purely coincidental and not intended in any manner.

After having upgraded from Oracle Data Integrator (ODI) 10g to 11g or 12c, and having updated the knowledge modules with the mandatory changes, the IKM SQL To File Append no longer writes the header records of target File when it is to be wriitten in either :

For example, a File Datastore defined with one header row, and following column names:

mycol1        (observe lower case letter is used)
MyCol2        (observe mixed case letter is used)
MYCOL3        (observe upper case letter is used)

The header record before upgrade to ODI 11g was generated with the exact names above (respecting the type case)...

... while in ODI 11g, with the updated IKM, the header row is set in upper case only :

MYCOL1        (observe upper case letter is used instead of expected lower case)
MYCOL2        (observe upper case letter is used instead of expected mixed case)
MYCOL3        (observe upper case letter is used)

Changes

The code implemented in the Generate header step of referred IKM differs between ODI 10g and ODI 11g:

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.