Transaction Workbench: Expected Value Was Not Queried Using Folder In Transaction Summary Form
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms