My Oracle Support Banner

ODI 12c SQL CUSTOM_TEMPLATE Code is Missing Line Breaks After the Mapping is Executed (Doc ID 2364004.1)

Last updated on SEPTEMBER 14, 2022

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(TABLE_COLUMN)) 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(TABLE_COLUMN)) TABLE_COLUMN ,

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.