My Oracle Support Banner

ODI 12c Legacy Export-Import in Duplication Mode Reverses the Order of 'Unpivot Transforms' (Doc ID 2756721.1)

Last updated on FEBRUARY 10, 2023

Applies to:

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


Using Oracle Data Integrator (ODI), after standard (aka legacy) export / import of a mapping or mapping duplication the order of "unpivot transforms" is reversed.

The issue is not observed when using smart export / import.

Also, this issue did not occur in ODI

To reproduce:

  1. Create a mapping using "unpivot" component
  2. Right-click to export in legacy mode.
  3. Import the mapping in duplication mode
  4. Select the "unpivot" component of the imported mapping and go to the "Unpivot Transforms" in "Properties"
    => Notice that the order is reversed





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.