ODI 12c SQL CUSTOM_TEMPLATE Code is Missing Line Breaks After the Mapping is Executed
Last updated on FEBRUARY 26, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 12c]
Information in this document applies to any platform.
On Oracle Data Integrator (ODI) 22.214.171.124.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:
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 hundreds of Community platforms