My Oracle Support Banner

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

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 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.

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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