My Oracle Support Banner

ODI Generates Incorrect Code if Mapping Attribute Matches Name of a Variable Using ":" Binding Syntax in Knowledge Module or Procedure Step (Doc ID 2617079.1)

Last updated on JUNE 08, 2023

Applies to:

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

Symptoms

Incorrect code is generated by Oracle Data Integrator (ODI) 11g and 12c when a Procedure or Knowledge Module implements code that refers to an Expression (or Mapping Attribute) that uses colon (:), and the value passed (:BIND_VARIABLE) matches a Variable name.

ODI appears to substitute the :BIND_VARIABLE expression with the Variable name (:<PROJECT CODE or GLOBAL>.<BIND_VARIABLE>)

The behavior persists after having applied the fix from:

Unpublished Bug 28103040 - Wrong Code Generated When a Variable is Named as a Source Column
Document 2592584.1 - ODI 12c Generates Incorrect Code if a Mapping Attribute Matches the Name of a Variable

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.