Transfer ASN Shipments Not Updating Base Tables Even After Its Processed From MPS_STAGED_MESSAGE
(Doc ID 2949746.1)
Last updated on NOVEMBER 04, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and laterInformation in this document applies to any platform.
Goal
Transfer ASN Shipments not updating Base tables Even after its Processed from MPS_STAGED_MESSAGE.
The Transfer ASN Shipments messages WH to ST are not updating base SIOCS tables even after its Processed from MPS_STAGED_Messages in SIOCS Dev2 environment.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Warehouse to STORE transfer SHIPMENT Creation and Receiving in SIOCS with HH SOCS.
2. Create a TRANSFER from WH to STORE in RMS.
3. Create a SHIPMENT from WH to STORE. (WH is a Custom application Warehouse)
4. Check SIOCS MPS_STAGED_MESSAGE ASNIn message Family.
5. Message Status is Processed.
6. Check Base SIOCS TSF_DELV and TSF_DELV_CARTON tables.
7. No data populating.
It can be observed that this scenario is based on missing of one of the tag in xml " <stockHolding>Y</stockHolding>" . But the MPS_STAGED_MESSAGE processing this without any ERROR and base tables are not updating.
Example:
<?xml version="1.0" encoding="UTF-8"?>
<AsnInDeo>
<toLocType>S</toLocType>
<toLocation>31203</toLocation>
<fromLocType>W</fromLocType>
<fromLocation>900006</fromLocation>
<asn>3322300085-103-POT</asn>
<shipmentDate>2023-05-10T21:00:00Z</shipmentDate>
<autoConfirm>false</autoConfirm>
<asnInPoList>
<poNumber>3015012920</poNumber>
<docType>T</docType>
<containerList>
<containerId>AG0-32</containerId>
<itemDeoList>
<itemId>320806197</itemId>
<unitQty>275</unitQty>
</itemDeoList>
<itemDeoList>
<itemId>320032144</itemId>
<unitQty>275</unitQty>
</itemDeoList>
</containerList>
</asnInPoList>
</AsnInDeo>
Solution
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
Goal |
Solution |