My Oracle Support Banner

ODI Unable to Sort Data from DB Source into Complex File Like JSON (Doc ID 2763801.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

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

Symptoms

A JSON file created by an Oracle Data Integrator (ODI) mapping which pulls from a database source and uses SORTER transformation to sort data based on a particular column to be placed into the JSON file target is not having the output files data sorted as expected.

Expecting to see the output sorted on the column in used in SORTER

Cause

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.