Transaction Batch Form Perfomance Issue: When Querying Batches On GL Date Performance Is Slow Then Returned Results Are Not Filtered on Specified GL Date Value
Last updated on FEBRUARY 15, 2018
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
In the Transactions Batch Summary form, when you run a query using GL Date, the form takes a long time to return results. When the results are finally returned, it shows all batches and ignores the GL Date value provided when the query was run.
Further, this issue occurs only the very first time the form is opened and the query is run, when the same criteria is given in the Find window from the second time onwards, it works fine.
Another workaround to get the query to perform properly is to override / re-enter the defaulted Operating Unit value, then the query works right even the first time.
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