SIOCS: Inventory Reserved at Store Receiving Location for Wh To Store Transfer (Doc ID 2909346.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Symptoms

Warehouse to Store Transfer inbound message processed by SIOCS, when auto approved, reserves inventory at the destination store.

EXPECTED BEHAVIOR
-----------------------
All inventory movements should probably only occur on the sending store IF the transfer is from a sending store.

Steps to Reproduce:

1. Create a warehouse to store transfer in RMS.
2. Let the SOCre message process in SIOCS
3. Verify in store_item_stock table. STORE_ITEM_STOCK.QUANTITY_RESERVED is updated for Store 30140 .

EICS DB

STORE_ITEM_STOCK.QUANTITY_RESERVED = 0 for Item 124729168 and store ID 30140

RMS DB

Item 124729168 and LOC 30140 --> ITEM_LOC_SOH.TSF_RESERVED_QTY = 0


Create TSF from WH 800006 to ST 30140 Qty 3.

RMS DB

Item 124729168 and LOC 30140 --> ITEM_LOC_SOH.TSF_RESERVED_QTY = 3

EICS DB


STORE_ITEM_STOCK.QUANTITY_RESERVED = 3 for Item 124729168 and store ID 30140

Changes

Cause

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