My Oracle Support Banner

Poor Pick Slip Perfomance Caused by Missing Indexes on the MTL_MATERIAL_TRANSACTIONS Table (Doc ID 299174.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Shipping Execution - Version 11.5.8 to 11.5.9 [Release 11.5.8 to 11.5]
Information in this document applies to any platform.

Symptoms

Pick slip performance becomes increasingly slow when pick releasing a batch of orders.
For example, the pick slip process used to take 2 minutes or under to complete, but is now taking 2 hours plus to complete.

Trace file of the pick slip performance identifies the following select statement as the most expensive or in some instances, the second most expensive:

 

Changes

Upgraded to 11.5.8 from a previous Release of 11i

Upgraded to 11.5.8 or 11.5.9 from Release 10.7 or 11.03

Cause

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.