My Oracle Support Banner

Pick Selection List Generation Is Hanging or Taking a Long Time to Complete (Doc ID 166251.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Shipping Execution - Version 11.5.9 and later
Information in this document applies to any platform.
***Checked for relevance on 11-May-2016***


This note was originally entered for release 11.5.3, but is also valid for Releases 11.5.10 through 12.1.1.

Any of the following conditions might be present:
1   Pick Selection List Generation or Interface Trip Stop is hanging or taking a long time to complete.
2.  Inventory Transaction Managers are deadlocked
3.  Deadlock error messages reference table MTL_ONHAND_QUANTITIES
4.  Deadlock error messages reference table  MTL_TRANSACTIONS_INTERFACE

Symptoms 2 through 4 will also have error:  ORA-00060: Deadlock detected while waiting for resource


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.