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 JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 to 12.2.1.2.0 [Release 12c]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:
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
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
Symptoms |
Changes |
Cause |
Solution |
References |