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 DECEMBER 14, 2017

Applies to:

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


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:


 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:


     instead of:



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