My Oracle Support Banner

ODI Substitution API Method "odiRef.getTargetColList" with Selector "UK" Does Not Return Active Column with Update/Alternative Key Constraints (Doc ID 2646256.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

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

Symptoms

The Oracle Data Integrator (ODI) Substitution API method "odiRef.getTargetColList()" with Selector "UK" does not return the column Update/Alternative Key constraints. For example, the following code in the knowledge module...

DECLARE
TYPE REC IS RECORD (
<%=odiRef.getTargetColList("", "[COL_NAME] " + odiRef.getTable("L", "TARG_NAME", "A")+".[COL_NAME]%TYPE", ",\n ", "", "UK")%>
);
R REC;

… results in the following generated code that does not return any columns, even though there is a column with Update/Alternative Key constraints.

DECLARE
TYPE REC IS RECORD ();
R REC;

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.