How to Resolve Locking Issue in ASN Interface?
(Doc ID 1081104.1)
Last updated on SEPTEMBER 02, 2020
Applies to:Oracle Retail Merchandising System - Version 10.1.22 and later
Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 to 19.0 [Release 19.0]
Information in this document applies to any platform.
Checked for relevance on 25-July-2013
Checked for relevance on 07-Jan-2017
We are facing locking issues in ASN processing due to multi-threading. ASNs are threaded by Location, when ASNs coming from the same WareHouse (WH) are processed by a different thread it causes a locking error when the ASN processing attempts to update the FROM_LOCATION's Stock On Hand (SOH) in ITEM_LOC_SOH table.
Is there any workaround to resolve contention/locking issue on the ASN interface ?
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