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 AUGUST 28, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 2.0.2 to 12.2.1.4.200413
Oracle Data Integrator - Version 12.2.1.4.200123 to 12.2.1.4.200413 [Release 12c]
Information in this document applies to any platform.

Symptoms

On Oracle Data Integrator (ODI) 12.2.1.4, a mapping executes 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" knowledge module. 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!

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