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.

Symptoms

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.

Steps

  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.



Changes

 

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