My Oracle Support Banner

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

Last updated on NOVEMBER 03, 2023

Applies to:

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


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.




To view full details, 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 a vibrant support community of peers and Oracle experts.