My Oracle Support Banner

Performance Issue When Processing Price Events in Bulk in Retail Merchandising System (RMS) (Doc ID 2132050.1)

Last updated on DECEMBER 11, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

In Retail Merchandising System (RMS), processing of pricing events in bulk takes a longer than expected time to complete.


Steps to Reproduce:

  1. Create and approve multiple price events (Promotion, Price Change or Clearance) in Retail Price Management (RPM).
  2. Run PriceEventExecutionBatch and verify price event status.
  3. Run PriceEventExecutionRMSBatch to process the price events and update RMS tables.
  4. Note that batch takes more than expected time to delete records with location '-999' from PRICE_HIST table, impacting overall performance.

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.