SAVED QUERY RESULT SCREEN SORTING ONLY ONE PAGE
(Doc ID 472582.1)
Last updated on OCTOBER 22, 2020
Applies to:Oracle Transportation Management - Version 5.5.02 and later
Information in this document applies to any platform.
-- Problem Statement:
On 184.108.40.206 :
When you create a saved query using plsql, for example, "select shipment_gid from shipment where shipment_gid like 'xyz'" the query results in "n" pages of shipments. If you sort by the Start Date on the first page (from the results page sort based on the Start Date - by clicking on the column header). The expected result would be all the shipments from all the 10 pages to be sorted by Start Date, instead OTM sorts only the first page.
However, if you use the finder screen instead of a saved query, the same set of results when sorted from results page sorts all the 10 pages.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to Transportation Planning and Execution -> Shipment Management -> Buy Shipments
2. Select a previously created Saved Query built using sql and execute it.
3. Sort by START_TIME.
4. The SQL version is not sorting the entire results, only the ones within the current page.
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