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.

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

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