Pick Selection List Generation Is Hanging or Taking a Long Time to Complete
(Doc ID 166251.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Shipping Execution - Version 11.5.9 and later
Information in this document applies to any platform.
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!