Performance Issue When Processing Price Events in Bulk in Retail Merchandising System (RMS)
Last updated on MAY 03, 2016
Applies to:Oracle Retail Merchandising System - Version 13.2.4 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.
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