Receipts Workbench: Search Receipts Using Payment Method as a Query Criteria When the Profile: AR: Query Criteria Check Set Receive Error - Please Fill in Selective Criteria in at Least One of the Following Fields for Performance Reasons (Doc ID 1584372.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

Attempting to search on the Receipts form, using the Payment Method field and receive the following error:

Error Message:
Please fill in selective criteria in at least one of the following fields for performance reasons: Receipt Method, Receipt Number, Receipt Date, GL Date, Name, Number, Location, Taxplayer ID, Payment Server Order Number, Account, Deposit Date, Batch, Issuer Bank Name, Issuer Bank Branch.

If the profile option AR: Query Criteria Check is set to "WARN" or "NONE," the query returns with no error.
However, it is a problem, if the System Profile is set to "ERROR."

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