My Oracle Support Banner

FAW - Issue With Loading NUMBER Data Type From OCI Bucket xlsx File (Doc ID 2923924.1)

Last updated on MAY 01, 2023

Applies to:

Fusion Analytics Warehouse - Version 22.R4.x and later
Information in this document applies to any platform.


Refer FAW document Section Load Data from Oracle Object Storage into Fusion Analytics Warehouse (Preview),

Object Storage Connection created successfully and you are able to test connection and refresh metadata successfully also.

And then you create New Dimension through data augmentation using files from Object Storage.

Job ran successfully, Table created in backend ADW data warehouse.

Everything looks good for csv data source,

but numeric column value not correct for xlsx data source, i.e 738884.04 loaded as 738884.0400000002.




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

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