My Oracle Support Banner

SOSTATUS Message Does Not Retry After 2 Attempts and Does Not Release Lock on the ITEM_LOC_SOH Table (Doc ID 2891322.1)

Last updated on AUGUST 23, 2022

Applies to:

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

Symptoms

The SOSTATUS message is not attempted two times, and the lock is intact, causing Transfers to Fail with locking. This issue happens almost daily but cannot be replicated in the lower regions.

Error
-----------------------
"RMSSUB_SOSTATUS.CONSUME(?,?,?,?)}: [E] Table ITEM_LOC_SOH with key values of PACK_NO:xxxxx, FROM_LOC:xxxxx/TO_LOC:xxxx is locked by another user."


Changes

 

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
Changes
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.