Column Name Getting Replaced by Project Variable Name in ODI 11g
(Doc ID 2229541.1)
Last updated on JUNE 04, 2019
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 to 22.214.171.124.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 - <PROJECT>.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:
The target (Command On Target) code is:
The generated target code is:
The issue is the colon (:) in front of ":[COL_NAME]", is causing the replacement of the BUSINESS_GROUP_ID column name with the project variable name <PROJECT>.BUSINESS_GROUP_ID.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document