"LKM BICC to ADW External Table" Treats Double-Quotes Followed by Comma on CSV Files Incorrectly
(Doc ID 2662863.1)
Last updated on DECEMBER 27, 2022
Applies to:Oracle Data Integrator on Marketplace - Version 2.0.2 to 126.96.36.199.200413
Oracle Data Integrator - Version 188.8.131.52.200123 to 184.108.40.206.200413 [Release 12c]
Information in this document applies to any platform.
On ODI 220.127.116.11, 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