Pick Selection List Generation Is Hanging or Taking a Long Time to Complete
Last updated on MAY 23, 2018
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
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