Performance Problem With RPM Online Conflict Checking Process for Department/Zone Level Promotions

(Doc ID 1677313.1)

Last updated on JANUARY 20, 2018

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.

Symptoms

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 aand 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 (test case = 48) and a large total number of locations (test case = 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.

Cause

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