Experience The Nowait Lock Error Even When Performing Operations On Different Item/location/supplier
(Doc ID 2183218.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.
1 - Users using the screen at the same time experience the nowait lock error even when performing operations on different item/location/supplier.
2 - Tracking the action on the database find that the screen calls the item_loc_sql.insert_item_cost_loc() .
3 - item_loc_sql.insert_item_cost_loc() uses the cursor C_LOCK_ITEM_SUPP_COUNTRY_LOC to lock the records to work with, using a select for update nowait
4 - The question here is that the lock should not lock so many records, because it's preventing other users of working in separated sets of item/location/supplier
calling the item_loc_sql.insert_item_cost_loc() at the same time in 2 separated session, for 2 different items and suppliers, for the same country and having the arguments to update child and loc_ind set to 'Y' will trigger this issue.
One session was locking the other one, many records being locked by the process for sets of different item/location/supplier.
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