My Oracle Support Banner

Performance Problem With RPM Online Conflict Checking Process for Department/Zone Level Promotions (Doc ID 1677313.1)

Last updated on NOVEMBER 19, 2020

Applies to:

Oracle Retail Price Management - Version 13.2.5 to 14.0.1 [Release 13.2 to 14.0]
Information in this document applies to any platform.


We are encountering a performance issue with the Retail Price Management (RPM) conflict checking process for department / zone level promotions containing a large volume of items/locations.

Steps to Reproduce:

  1. Create one simple promotion involving 3 departments and a large number of items (in the test case, there were 78590 items).
  2. Choose a zone group which has a large number of zones (48) and a large total number of locations ( 180). 
  3. Select change_type as percent off. 
  4. Try to approve the promotion and note that it takes a long time to complete conflict checking.




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.