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
Last updated on DECEMBER 14, 2017
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.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, 22.214.171.124.0 or 126.96.36.199.0 Mappings, the generated code contains a GROUP BY, which is incorrect.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms