My Oracle Support Banner

Mobile User Are Having Locks (Doc ID 1309550.1)

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.