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.
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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!