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 11.13.19.07.0 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