SIOCS Publishing RmsStoreOrder Message With No Header Details (Doc ID 3074472.1)

Last updated on MARCH 05, 2025

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

When a Store Order initiated in SIOCS is cancelled, SIOCS publishes RmsStoreOrder message to MFCS and the "SIM_RMS_IMPORT_STORE_ORDER_REVIEW_ADHOC_PROCESS' batch fails with data errors.

EXPECTED BEHAVIOR
-----------------------

SIOCS should not publish the message to MFCS when the Store Order request is cancelled if it is not externally generated from MFCS.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

MFCS Integrated with SIOCS via DirectDB

1. Create a Store Order for an Item
2. Status moves to In Progress
3. Delete the Store Order
4. Status moved to Cancelled (STORE_ORDER.STATUS = 4)
5. MPS_STAGED_MESSAGE table shows the following message published:

RmsStoreOrder [Message Family]

RmsStoreOrder[Message Type]

<?xml version="1.0" encoding="UTF-8"?>
<StoreOrderReviewRmsDeo>
<storeId>1111</storeId>
<lineItems>
<itemId>100000005</itemId>
<quantity>0</quantity>
</lineItems>
</StoreOrderReviewRmsDeo>

Due to this issue, incorrect data is loaded into the SIM_RMS_IMPORT_STORE_ORDER_REVIEW table which then causes batch failures on MFCS side.

Cause

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