Transactions Workbench Issue: Unable to Sort Data in AR Transaction Summary Window

(Doc ID 1618614.1)

Last updated on JUNE 20, 2016

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.


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