My Oracle Support Banner

Substitution Methods Like getTargetColList() and getColList() Do Not Pick Columns with User Defined Flag in ODI 12c (Doc ID 2697721.1)

Last updated on AUGUST 10, 2020

Applies to:

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

Symptoms

Oracle Data Integrator (ODI) substitution methods, like getTargetColLit() and getColList(), do not pick UserDefined (UD) columns while extracting the column Expression to form the select query of a SQL merge statement. As a result of this, the expression for columns with only UD flag attribute selected are created as an empty string ('') and not the actual out-of-the-box or custom expressions.

Example:

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.