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 FEBRUARY 01, 2021

Applies to:

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


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 .




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.