'WHDel' Message Published By RMS Fails In SIM And Retried Several Times In 'MPS_STAGED_MESSAGE' Table

(Doc ID 2366303.1)

Last updated on MARCH 30, 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms