My Oracle Support Banner

Oracle Data Integrator (ODI) "getFrom()" Method Generates Incorrect SQL Outer Join Clauses (Doc ID 459925.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 4.1.01.07 to 10.1.3.4.4 [Release 4.1.01 to 10gR3]
Information in this document applies to any platform.

Symptoms

In certain Oracle Data Integrator (ODI) Integration Interfaces - and depending on Technology - when the SQL is generated from outer join operations, unwanted supplementary table aliases are inserted into the SQL Join clause instruction.

This renders the SQL Join clause instruction inoperative and inhibits the use of the Integration Interface.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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