My Oracle Support Banner

Transfer ASN Shipments Not Updating Base Tables Even After Its Processed From MPS_STAGED_MESSAGE (Doc ID 2949746.1)

Last updated on MAY 18, 2023

Applies to:

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


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.

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.


<?xml version="1.0" encoding="UTF-8"?>


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

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