ODI 12c SQL CUSTOM_TEMPLATE Code is Missing Line Breaks After the Mapping is Executed
(Doc ID 2364004.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 12c]
Information in this document applies to any platform.
On Oracle Data Integrator (ODI) 18.104.22.168.0, carriage return/line feeds are removed from a datastore's CUSTOM_TEMPLATE extract option when the mapping is run leading to execution failures. The FROM keyword appears at the end of the preceding line, appended to the SQL code without any whitespace separation.
For example, take the following SQL code excerpt:
It will be converted into the following when the carriage return/line feeds are removed:
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