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 AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

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.


Cause

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