My Oracle Support Banner

Transaction Summaries Form (INVTVTUS) Has Intermittent Slow Performance (Doc ID 1578107.1)

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.


  1. Navigate; Inventory > Transactions > Transaction Summaries.
  2. 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.




To view full details, 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 a vibrant support community of peers and Oracle experts.