ODI Incorrectly Generates Empty String for Old Outer Join "(+)" Syntax
(Doc ID 2767704.1)
Last updated on APRIL 12, 2021
Applies to:Oracle Data Integrator - Version 220.127.116.11.6 to 18.104.22.168.210321 [Release 12c]
Information in this document applies to any platform.
Using ODI 22.214.171.124.210108, an Oracle Data Integrator (ODI) customized Knowledge Module (KM) is used to generate the old outer join syntax (+).
If the KM code only contains "(+)" to concatenate, ODI generates an empty string.
This worked in some older release 12.1.3 or 12.2.1. The same stopped working in 126.96.36.199.6 and later.
Executions with this syntax fail with the following error:
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