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 DECEMBER 23, 2016

Applies to:

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

Symptoms

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 DFINB_DEV.
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.

Changes

Upgraded from ODI 12.1.2 to ODI 12.2.1.

Cause

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 hundreds of Community platforms