My Oracle Support Banner

GROUP BY Missing After Upgrading Interface from ODI 11g to ODI when Expression Uses Database PARTITION BY Function (Doc ID 2994377.1)

Last updated on JANUARY 17, 2024

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


After upgrading from Oracle Data Integrator (ODI) 11g to ODI 12c an interface which uses database aggregate functions such as MAX, MIN, SUM, and PARTITION BY, which had a GROUP BY present in ODI 11g is missing the GROUP BY in ODI 12c.


To view full details, 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 a vibrant support community of peers and Oracle experts.