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.
In Retail Merchandising System (RMS), processing of pricing events in bulk takes a longer than expected time to complete.
Steps to Reproduce:
- Create and approve multiple price events (Promotion, Price Change or Clearance) in Retail Price Management (RPM).
- Run PriceEventExecutionBatch and verify price event status.
- Run PriceEventExecutionRMSBatch to process the price events and update RMS tables.
- Note that batch takes more than expected time to delete records with location '-999' from PRICE_HIST table, impacting overall performance.
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