My Oracle Support Banner

Saved Query Not Using "Use In Finder" Check Box Does Not Sort The Full Record Set (Doc ID 2882881.1)

Last updated on JULY 13, 2022

Applies to:

Oracle Transportation Management Cloud Service - Version 22.2 and later
Information in this document applies to any platform.


You have a saved query that does not use the "Use In Finder" checkbox.

In this example the query returns approximately 143 invoices, when the sort is performed on the "Service Provider Alias Value" the system sorts the rows in 75 row batches instead of the entire set. This is confusing to the end user when they believe that all sorted records are grouped correctly by Service Provider but they are not.

When using a saved query that uses the same parameters but does have the "Use in Finder" checkbox checked when sorting by the same "Service Provider Alias Value" it performs the sort of the entire set.

This is the expected behavior for sorting returned records.


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.