Column Name Getting Replaced By Project Variable Name In ODI 11g
Last updated on FEBRUARY 14, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 11gR1]
Information in this document applies to any platform.
The following issues with KM code is observed in these circumstances:
A Project variable - HCMBATCHLOADER_EHR2HR.BUSINESS_GROUP_ID
A column name in Content Item VO - BUSINESS_GROUP_ID
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.
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