My Oracle Support Banner

POS Transactions in MPS_STAGED_MESSAGE Table Are Processed Extremely Slowly (Doc ID 2503235.1)

Last updated on JANUARY 27, 2021

Applies to:

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

Symptoms

In Retail Store Inventory Management (SIM), when transactions are sent in real time via web services from POS, the POS transaction records in SIM.MPS_STAGED_MESSAGE table are processed very slow.

Steps to Reproduce:

Pre-Req :

This issue is observed when there are more than 100,000 records in the MPS_STAGED_MESSAGE table


1. Populate staged_message table with many POS transactions via WebServices. Observe the slow performance as the number of new records are increasing as some of the records are being processed.

Changes

 

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
Changes
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.