My Oracle Support Banner

Incorrect DML Generated for ODI Mapping with LEFT JOIN (Doc ID 2486900.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Information in this document applies to any platform.


In ODI, when attempting to run a mapping that contains a reusable mapping containing a left join, the following error occurs.

The issue can be reproduced with the following steps:

  1. Create a reusable mapping that has in it one or two inner joins.
  2. Create a mapping that uses the above reusable mapping and run it. It will complete successfully.
  3. Change one inner join into a left one by checking the box for left join.
  4. Run the mapping again and observe the 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!

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