My Oracle Support Banner

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.

Error :

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

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