Stock Order Status 'SI' Msg Is Not Updating ITEM_LOC_SOH For Pre Allocated PO
(Doc ID 3044228.1)
Last updated on OCTOBER 09, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 to 24.0 [Release 23.1 to 24.0]Information in this document applies to any platform.
Symptoms
When an SI (Stock Increase) stock order status message is passed into MFCS via the ReST API, the QTY_ALLOCATED is updated.
However the corresponding updates for the increased qty is not updating the TSF_RESERVED_QTY & TSF_EXPECTED_QTY on ITEM_LOC_SOH.
The ALLOC_DETAIL.PO_RCVD_QTY is also not being updated.
Steps to Reproduce :
--------------------
1. Create a PO for 52 units
2. Create an allocation for the above PO for 22 units to StoreA and 30 units to StoreB via th ReST API
3. Notice the TSF_RESERVED & TSF_EXPECTED are updated on ITEM_LOC_SOH
4. Now send a stock order status message for this allocation to increase (SI) StoreA by 3 units and decrease (SD) StoreB by -3 units.
5. Notice that the SD message correctly updates ALLOC_DETAIL and ITEM_LOC_SOH
6. However, while the SI message correctly updates ALLOC_DETAIL.QTY_ALLOCATED, it does not update the qty expected and reserved on ITEM_LOC_SOH
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 |
| Cause |
| Solution |
| References |