My Oracle Support Banner

Excel Returns NULL Values when Numeric and Alphanumeric Datatypes Are Intermixed Within the Same Column (Doc ID 424419.1)

Last updated on NOVEMBER 21, 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

In Oracle Data Integrator (ODI), having defined a Datastore based on a Microsoft Excel spreadsheet. One of the columns in the Datastore contains both numeric and NULL values.

In the Datastore definition, the column datatype has been set to NUMERIC, which is correct.

However, when consulting the Datastore content from Oracle Data Integrator Designer, all numeric values are returned as Null, while the underlying value is not a Null (for example 11,325).

If changing the column datatype in the Datastore definition to VARCHAR, all alphanumeric values will be now returned as Null, while the underlying value is not a Null (for example, AZERTY).

What is the problem here and is there a work around allowing the use of such Datastores in ODI Integration Interfaces / Mapping?

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.