My Oracle Support Banner

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.

Symptoms

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.

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.