My Oracle Support Banner

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 (Doc ID 884651.1)

Last updated on FEBRUARY 13, 2019

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.


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

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