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!