"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 220.127.116.11.200123 and later
Information in this document applies to any platform.
On ODI 18.104.22.168, 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
|123||Drill 12", for concrete|
|456||Drill 14", for wood|
Data inserted in the target ADW table:
|123||Drill 12||for concrete|
|456||Drill 14||for wood|
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