My Oracle Support Banner

Inappropriate Group By Expression Generated by ODI when Using Analytical Functions (Doc ID 807527.1)

Last updated on MARCH 02, 2023

Applies to:

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


After having set up a Column mapping in an ODI Integration Interface with the following code which implements the COUNT ...OVER analytical functions:

a Group By expression is generated.

This is not what is to be expected when using analytical functions.


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.