ODI 12c SQL CUSTOM_TEMPLATE Code is Missing Line Breaks After the Mapping is Executed

(Doc ID 2364004.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

On Oracle Data Integrator (ODI) 12.2.1.3.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:

A.XYZ_CODE as XYZ_CODE
FROM
(
SELECT
LTRIM(RTRIM(STU_INST_UID)) STU_INST_UID ,

It will be converted into the following when the carriage return/line feeds are removed:

A.XYZ_CODE as XYZ_CODEFROM( SELECT LTRIM(RTRIM(STU_INST_UID)) STU_INST_UID ,

Note that in the updated query there is now a syntax error, as there is no whitespace between 'XYZ_CODE' and the 'FROM' keyword.

Cause

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