My Oracle Support Banner

Using ODI 12c, the Execution on Oracle Source Fails with Error "Window Functions Are Not Valid For Technology XML" (Doc ID 2970242.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version to
Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


An Oracle Data Integrator (ODI) 12c Mapping loads data from an Oracle source Datastore, and writes into a target XML file, using "IKM SQL to SQL", and the staging area is set on the source.

While the execution of above succeeds in ODI 11g, the following error is received in ODI 12c when executing the same:

The Mapping attribute facing the error uses the following Window Function, which is executed on the source Oracle technology:

rank() over (partition by ... order by ...)




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.