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).
Open as Default: Checked
Include Query: Checked
5. Push the Show Query button.
(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?|