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 188.8.131.52.0 to 184.108.40.206.0 [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:
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