My Oracle Support Banner

'WHDel' Message Published By RMS Fails In SIM And Retried Several Times In 'MPS_STAGED_MESSAGE' Table (Doc ID 2366303.1)

Last updated on NOVEMBER 07, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Store Inventory Management (SIM) , warehouse delete(WHDel) message fails in MPS_STAGED_MESSAGE with the following error :

 

Steps to Reproduce:


Prerequisite :

a. SIM should be integrated with Retail Merchandising System (RMS) via Retail Integration Bus (RIB).
b. Warehouse should have been setup in SIM.

 

1. From RMS publish warehouse delete message for warehouse (which is present in SIM) and run 'dlyprg.pc' batch.
2. Warehouse delete message flows into SIM.MPS_STAGED_MESSAGE table and fails with the error .

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


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