Post Upgrade to 12c the Outer Join Code Is Not Being Generated
(Doc ID 2484657.1)
Last updated on AUGUST 17, 2020
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.2 [Release 12c]
Information in this document applies to any platform.
Oracle Data Integrator (ODI) 11g Interfaces have been defined with Filters and outer joins using the (+) syntax.
After having upgraded to ODI 12c, the Mappings still have the (+) outer joins defined, but the (+) no longer is applied in the Filter during the execution.
Although no errors are reported, the code generated for the Mapping by ODI 12c is incorrect, and the data returned is incorrect as well.
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