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

Last updated on JUNE 05, 2024

Applies to:

Symptoms

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

ERROR
-----------------------
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

Changes

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.