After Upgrading To ODI 12.2.1 Mapping Fails with Error "ORA-25156: old style outer join (+) cannot be used with ANSI joins"
Last updated on DECEMBER 23, 2016
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
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:
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.
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