After Upgrade from 11g Incorrect GROUP BY in ODI 12c Mappings where Analytic Functions Such as FIRST_VALUE, RANK, RN (ROW_NUMBER, ROWNUMBER) Are Used
(Doc ID 2196990.1)
Last updated on MARCH 03, 2021
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
Integration Interfaces using analytic functions such as FIRST_VALUE, RANK, RN (ROW_NUMBER, ROWNUMBER), etc were successfully running in Oracle Data Integrator (ODI) 11g.
After upgrading to ODI 12.2.1..0.0, 12.2.1.1.0 or 12.2.1.2.0 Mappings, the generated code contains a GROUP BY, which is incorrect.
Note the behavior is also observed when smart exporting the Integration Interface from ODI 11g, and importing into ODI 12c.
Changes
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 |