My Oracle Support Banner

ODI 'getTargetTable("RES_NAME")' Returns Source Table Name Instead of Target (Doc ID 2701165.1)

Last updated on AUGUST 21, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.4.200304 and later
Information in this document applies to any platform.

Symptoms

When executing Oracle Data Integrator (ODI) API method to retrieve the target table name in a mapping, the incorrect table is returned. Instead of getting the name of the target table, the source table is retrieved.

For example, the code implemented on an LKM to "Drop target table" could be one of the following forms:

Upon execution, this is expected to drop the target table but it substitutes it with the source table name, resulting in incorrect behavior.

This is noted as occurring when a staging table is used in the mapping with a multi-technology knowledge module.

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.