My Oracle Support Banner

ODI 12c Generates Incorrect Code if a Mapping Attribute Matches the Name of a Variable (Doc ID 2592584.1)

Last updated on JUNE 08, 2023

Applies to:

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

Symptoms

Incorrect code is generated by Oracle Data Integrator (ODI) 12c when a Mapping uses source or target Datastores with column names <NAME> that match the name of a variable (<PROJECT CODE>.<NAME>).

During the binging mechanism, instead of :NAME, ODI will generate :PROJECT CODE.NAME

To replicate the behavior:

  1. In ODI 12c Studio, create a Variable called MYNAME, in Project MYPROJECT
     
  2. Create a Mapping that has either
    • a source Datastore with one columns named MYNAME... or
    • a target Datastore with one columns named MYNAME...
       
  3. Execute the Mapping and observe :MYPROJECT.MYNAME is used instead of the expected :MYNAME

Changes

 

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.