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 FEBRUARY 26, 2019
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.0 [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, 22.214.171.124.0 or 126.96.36.199.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