My Oracle Support Banner

After Upgrading To ODI 12.2.1 Mapping Fails with Error "ORA-25156: old style outer join (+) cannot be used with ANSI joins" (Doc ID 2152086.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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


Mappings previously worked in Oracle Data Integrator (ODI) 12.1.2

After upgrading To ODI 12.2.1 the same mappings are failing.

The following errors are recorded:

ODI-1227: Task Insert new rows-IKM SQL to File Append- fails on the source connection <NAME>.
Caused By: java.sql.SQLException: ORA-25156: old style outer join (+) cannot be used with ANSI joins

Note the "Generate ANSI Syntax" property of Mapping JOIN component is set to default.


Upgraded from ODI 12.1.2 to ODI 12.2.1.


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.