ITEM_LOC_SOH Table Locking While Performing Store Receiving In RMS

(Doc ID 2378998.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

ITEM_LOC_SOH table locking while performing store receiving in Retail Merchandising System(RMS).

Steps To Recreate:

1. Create 3 transfer for the item-1 and from-location is say: from-1 and to-location say to-1, to-2 and to-3.
2. Let 3 different user receive the above 3 transfer simultaneously.
3. Notice that while receiving from GUI in RMS it throws the above error.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms