My Oracle Support Banner

White Spaces Are Added when Inserting Data from Fixed Format File to Database Using ODI (Doc ID 2904312.1)

Last updated on AUGUST 18, 2023

Applies to:

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


Using Oracle Data Integrator (ODI) release and loading data from file to Oracle in a mapping.
If a fixed format file with a column of 6 character is loaded, and the attribute value is set to 20 characters, ODI will insert 20 characters, adding 14 blank spaces.

This was not observed in ODI where there were no blank spaces added when loading files format files.

To reproduce:

  1. Create a fixed file data server and model
  2. Make sure that one of the fixed file format columns has column size set to 20 characters
  3. Create a file that only has 6 characters for the same column of actual data, and fill the rest of the 14 characters with blank spaces
  4. Create a mapping loading fixed file format to Oracle
  5. Execute the mapping and look at the data loaded in the target table




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.