My Oracle Support Banner

E1: UBE: DB: Data Sequencing Is Not Sorting the Records Based on Specific Alphabet Sorting (Doc ID 2427190.1)

Last updated on FEBRUARY 04, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
Oracle Database


On a system which uses an Oracle Database server, after designing a new UBE and a new version, when the UBE is submitted locally on the Development Client where it has been designed, the UBE output shows the records sorted alphabetically, ascending or descending, as specified in the Data Sequencing. The same UBE, when is submitted to the Enterprise Server, produces an output where the records are not sorted based on the same alphabetic sorting rules.
For example, for Turkish, below is the proper linguistic sorting and this is how the records are shown in the UBE output submitted on Development Client:

In the UBE execution details the SQL query which is executed is showing that the order criteria is set according to the Data Sequencing rules


 Not applicable


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.