Column Name Getting Replaced By Project Variable Name In ODI 11g (Doc ID 2229541.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 to 11.1.1.9.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

The following issues with KM code is observed in these circumstances:

Declarations
    A Project variable - HCMBATCHLOADER_EHR2HR.BUSINESS_GROUP_ID
    A column name in Content Item VO - BUSINESS_GROUP_ID

Desired outcome:
    Insert data into a D$ table having the columns marked with UD1 or UD4 and having the bind variables whose values are selected in the source.

The source (Command on Source) code is (Schema - ORACLE_FUSION) :

 

The issue is, the colon (:) in front of ":[COL_NAME]", is replacing the BUSINESS_GROUP_ID column name with the project variable name HCMBATCHLOADER_EHR2HR.BUSINESS_GROUP_ID.



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