My Oracle Support Banner

Best Practices when Managing Microsoft Excel NUMBER Values with ODI (Doc ID 424608.1)

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

Goal

In an Oracle Data Integrator (ODI) Integration Interface or Mapping having a Microsoft Excel Source Datastore which contains numeric values (defined as NUMBER in the Datastore's Column description), when transformations are executed on the Staging Area, the numeric columns of the C$ Load Table are defined without Scale.

As a result the numeric values are rounded down to the nearest whole number e.g. 15.12 is transformed into 15.00 on the Target System.

When the same transformations are executed on "Source", the Target information is correctly set.

Solution

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.