My Oracle Support Banner

ItemLocMod, ItemLocDel Msg Not Updating WAREHOUSE_ITEM.STATUS Table (Doc ID 2965079.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
ItemLocMod, ItemLocDel msg not updating WAREHOUSE_ITEM.STATUS table

When you initiate ItemLocMod and ItemLocDel msg from RMS/MFCS for Warehouse Item, message is reaching to the MPS_STAGED_MESSAGE table and getting processed fine, but status mentioned in ItemLocMod is not getting updated in the WAREHOUSE_ITEM table STATUS column.

ItemLocDel message is not updating the WAREHOUSE_ITEM table STATUS column as D.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish an ItemLocMod/ItemLocDel message from MFCS to SIOCS
2. Check the status in the WAREHOUSE_ITEM table, the status was not changed

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.