Performance Problem With RPM Online Conflict Checking Process for Department/Zone Level Promotions
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.
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:
- Create one simple promotion involving 3 departments aand a large number of items (in the test case, there were 78590 items).
- Choose a zone group which has a large number of zones (test case = 48) and a large total number of locations (test case = 180).
- Select change_type as percent off.
- Try to approve the promotion and note that it takes a long time to complete conflict checking.
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