Transaction Workbench: Expected Value Was Not Queried Using Folder In Transaction Summary Form (Doc ID 824783.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Receivables - Version 12.0.6 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
FORM:ARXTWMAI.FMB - Transactions


Symptoms

In order to see some specific value in Transaction summary form, a folder has been created with some conditions.

Using this folder the query condition is not taken into account.

The transaction summary form and the receipt summary form could not query the records after the user defined the folder with the query conditions.

ERROR
-----------------------
Please fill in selective criteria in at least one of the following fields for performance reason: GL Date, Number, Bill to: Location, Ship To: Location, Receipt Method, Date, Source, Bill To: Name, Bull To:Number, Ship To: Name,Ship To: Number

Steps To Reproduce:

1. Open the transaction summary.
2. Push the Find button and set the condition.
    Bill to: Name and Number
    Transaction date: From - To
3. Push the Find button.
4. Create new folder (Folder -> New).
    Folder: Test
    Autoquery: Always
    Open as Default: Checked
    Include Query: Checked
5. Push the Show Query button.
    Folder Query:
   (Date BETWEEN to_date('2009/03/19 00:00:00', 'YYYY/MM/DD HH24:MI:SS')
   AND to_date('2009/03/19 23:59:59', 'YYYY/MM/DD HH24:MI:SS')) and
   (BILL_TO_CUSTOMER_ID=14040)
6. Close the transactions summary.
7. Open the transactions summary and get the error message.

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