Pick Selection List Generation Ends In Errors ORA-00054 And ORA-20000

(Doc ID 1397203.1)

Last updated on JUNE 02, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


Pick Release completes with the following warning

Error occurred in INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired in
Package inv_loc_wms_utils Procedure LOC_EMPTY_MIXED_FLAG
ORA-20000: MTL_MMTT_T:S15:ORA-01086: savepoint 'REVERT_LOC_SUGGESTED_CAP_SP' 

The issue can be reproduced at will with the following steps:
1.Responsibility : Oracle Order Management
2.Navigate to Shipping
3.release sales orders


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