My Oracle Support Banner

Different Order Results In Reports After Upgrade (Doc ID 1268443.1)

Last updated on APRIL 02, 2021

Applies to:

Oracle Reports Developer - Version 10.1.2.2 and later
Information in this document applies to any platform.

Symptoms

After migrating from Oracle Reports 6i to Oracle Reports 10GR2 (10.1.2.x), it was detected that in Oracle Reports 10GR2 that the order by clause is formatting in a different order -- ie. the numbers are displayed first and then the letters.
 
EXPECTED BEHAVIOR
-----------------------
In Oracle Reports 6i the letters are displayed first and then the numbers.

BUSINESS IMPACT
-----------------------
The data is not ordered the same in Oracle Reports 10GR2 as compared to Oracle Reports 6i.

Changes

The environment was upgraded from Reports 6i to Reports 10GR2 (10.1.2.x).

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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