My Oracle Support Banner

Transactions Workbench Issue: Unable to Sort Data in AR Transaction Summary Window (Doc ID 1618614.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Unable to sort data in AR Transaction Summary window.  The following error occurs:

Please fill in selective criteria in at least one of the following fields for performance reasons:  GL Date, Number, Bill To: Location, Ship To: Location, Receipt Method, Date, Source, Bill To: Name, Bill To: Number, Ship To: Name, Ship To: Number.

Steps to Reproduce:
Responsibility:  Receivables
Navigation: Transactions > Transactions Summary
Click on flashlight icon and enter a range of gl dates to query data
Click on the column header NUMBER to attempt to sort the data
Error is raised


Profile Option "AR: Query Criteria Check"  is null at all Four (4) levels: Site, Application, Responsibility and User.


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.