My Oracle Support Banner

"LKM BICC to ADW External Table" Treats Double-Quotes Followed by Comma on CSV Files Incorrectly (Doc ID 2662863.1)

Last updated on MAY 21, 2020

Applies to:

Oracle Data Integrator on Marketplace - Version 2.0.2 and later
Oracle Data Integrator - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

On ODI 12.2.1.4, when executing a load that pushes data using the Business Intelligence Cloud Connector (BICC) to Autonomous Data Warehouse (ADW) via the "LKM BICC to ADW External Table", if the the data on the source system contains double quotes followed by commas, the data is injected incorrectly in the ADW target table.  The result is that for each case of double quotes found in the CSV file, the execution pushes the data following the double quote to the next column causing the data to be inserted incorrectly on the target table.

Original data in BICC

Col1 Col2
123 Drill 12", for concrete
456 Drill 14", for wood

 

 

 

Data inserted in the target ADW table:

Col1 Col2 Col3
123 Drill 12 for concrete
456 Drill 14 for wood

 

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!


In this Document
Symptoms
Cause
Solution
References


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