My Oracle Support Banner

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

Last updated on MAY 07, 2019

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


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.

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
6. Close the transactions summary.
7. Open the transactions summary and get the error message.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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