Transaction Summaries Form (INVTVTUS) Has Intermittent Slow Performance
Last updated on JUNE 12, 2018
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
When trying to query some items in the Transaction Summaries form (INVTVTUS), the form can take as much as 30 minutes to return results.
The expectation is for the form should only take a few seconds.
- Navigate; Inventory > Transactions > Transaction Summaries.
- Parameters used are generally an item with a date range of 2 years or less.
The bad performing SQL Statement is as follows as seen in the TKProf file timed_statistics set to true.
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