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

Last updated on NOVEMBER 20, 2024

Applies to:

Symptoms

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

Changes

 Not applicable

Cause

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