My Oracle Support Banner

Using ODI Customized KM '#' Characters are Moved in Generated Java Code if Concatenated to a String (Doc ID 2863269.1)

Last updated on FEBRUARY 07, 2023

Applies to:

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


NOTE: In the examples and/or the attached document, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database. Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.


Variables are not substituted correctly in an Oracle Data Integrator (ODI) custom Knowledge Module (KM) when using # and + for concatenation. More specifically, when using # and + for concatenation of a string to a variable (not an ODI

variable), the # is moved incorrectly in front of the string.


KM code:


Patch 32950970 was applied and double-quotes implemented as documented:

Document 2827377.1 After Upgrade from ODI to, Incorrect Runtime Substitution of Variables in 12c Mapping


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.