My Oracle Support Banner

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.

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

Changes

 

Cause

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.