My Oracle Support Banner

Problems with Numeric Data Fields in Excel File Datastores Used in ODI (Doc ID 424471.1)

Last updated on NOVEMBER 17, 2023

Applies to:

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

Symptoms

After successfully setting up an Oracle Data Integrator (ODI) Source Datastore on a Microsoft Excel file named zone, it appears that only a subset of a numeric column is loaded to the Target Datastore.

Moreover, this is confirmed when consulting the Datastore (using the right-click > View menu-item) as only a certain number of fields are displayed with values while others are shown as blank fields although they do contain values.

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.