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 DECEMBER 14, 2017
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 to 184.108.40.206.6 [Release 12c]
Information in this document applies to any platform.
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, 220.127.116.11.0 or 18.104.22.168.0 Mappings, the generated code contains a GROUP BY, which is incorrect.
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