Defining Sort Order In Custom Screenset Causes Error In Returned Sql (Doc ID 423126.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5, A custom screen set with Sort Order defined on fields and attached to a Business Monitor Query with sub-selects, makes the Results hang and/or produce duplicate records.

EXPECTED BEHAVIOR
Expect that the query generated internally does not bring out duplicate records.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Set up a custom screen set based on the BUY_SHIPMENT screen set with 2 result fields defined with sort order.
2. Attach the custom screen set to a Business Monitor that has a query with sub-selects.
3. Run the business monitor and verify the results to see duplicate records.

-- Business Impact:
The issue has the following business impact:
Due to this issue, Business Monitors with sub-selects cannot be used in conjunction with Custom screen sets that have sort order defined in result fields.

Cause

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 hundreds of Community platforms