My Oracle Support Banner

Join Conditions are not Picked up by ODI 12c when Executing the Code (Doc ID 2379816.1)

Last updated on JULY 02, 2020

Applies to:

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


After having upgraded from Oracle Data Integrator (ODI) 11g to 12c, Mappings containing a combination of outer Joins and full Joins lose the full Join block when executed: the full Join is not generated in the WHERE clause of IKM "Insert flow into I$ table" task.

Note that the behavior is observed when ANSI with non-ANSI Joins are combined, as well when all the Joins use ANSI, or all Joins use non-ANSI.

This behavior can be observed in ODI Studio as follows:



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.