My Oracle Support Banner

Loading a File to a Table with Null Values Are Inserted Into Incorrect Columns (Doc ID 2997435.1)

Last updated on JANUARY 17, 2024

Applies to:

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

Symptoms

Oracle Data Integrator (ODI) is used to transfer data from a file to a table. The file includes extended ASCII characters aka diacritics (such as Å Ä Ö å ä ö), some of the columns have null values.

The ODI File Technology data server has correctly set encoding to "UTF-8" and the property "MULTIBYTE_MODE=1".

When loading the data from the file, the values that are null are incorrectly moved to the last columns, regardless of which field in the file has the actual null value. Following is an example: 

File:

The same behavior occurs when using Chinese characters.

 

Changes

 

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.