My Oracle Support Banner

Why The CSV Data Extract Files Have Fields Delimited By Comma and Descriptive Text Fields Are Enclosed By Double Quotes (Doc ID 2628205.1)

Last updated on FEBRUARY 09, 2020

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version and later
Information in this document applies to any platform.


Why the  CSV data extract files have fields delimited by comma and descriptive text fields are enclosed by double quotes ?

When the text field contains double quotes, it causes problems and errors in the data warehouse ETL data loading programs as it throws the whole format off. 
So to avoid this problem is it possible to configure BICCC extracts TO USE A DIFFERENT CHARACTER TO ENCLOSE THE TEXT FIELDS or to escape the double quotes as in \"  ?



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.