Mobile User Are Having Locks (Doc ID 1309550.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Warehouse Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
File versions less than WMSOPIBB.pls 115.28.115100.11


Symptoms

Mobile users are getting blocked.

Lock begins when users leave their computer with the form open and a new field is requesting a value to transact.

Users are working on mobile devices, when other users request the same form or the same table, they are locked. Customer is training users to close and log out of the mobile forms or devices when they are not being used. This minimizes the occurrences but still the issue continues now and again and causes delays in production.

Also this can occur when multiple receipts are done into same LPN, sometimes the putaway of the LPN would fail after a long "Please Wait message". The task will error out after a long time due to a deadlock.

ERROR
-----------------------
ORA--00054: resource busy and acquire with NOWAIT specified or timeout expired in package inv_loc_wms_utils procedure LOC_EMPTY_MIXED_FLAG. Press any key to continue.




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