In ODI 12c, odRef.getTargetTable("TABLE_NAME") Incorrectly Returns The Datastore Resource (RES_NAME) Instead Of The Datastore Name

(Doc ID 2278186.1)

Last updated on JUNE 23, 2017

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, there is a Datastore where the Resource Name is different from the Datastore name. For example:

 

A Mapping that loads data into the above Datastore uses an IKM that implements the following ODI method:

<%=odiRef.getTargetTable("TABLE_NAME")%>

 When executing the Mapping, the above gets substituted with the Resource Name instead of the expected Datastore name. In the example above, ODI 12c returns:

CHIA/chia_denclm_hdr_ext

     instead of:

CHIA_DENCLM_HDR_EXT

Changes

 

Cause

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 hundreds of Community platforms