Pick Selection List Generation Is Hanging or Taking a Long Time to Complete

(Doc ID 166251.1)

Last updated on JANUARY 03, 2017

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***

Symptoms

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

Cause

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