PriceEventExecutionBatch Performance Issue with Customer Segment Promotions in RPM 13.2 (Doc ID 2073489.1)

Last updated on NOVEMBER 03, 2015

Applies to:

Oracle Retail Price Management - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Price Management (RPM) 13.2.4, we note a PriceEventExecutionBatch performance issue.


Example:
Have around 2500 customer segment promotions with starting vdate + 1.
The batch runs for many hours without completing.


Steps to Reproduce:


   1. Have large number of customer segment promotions:
       Have 4000+ customers and offer 200 to 2500 promotions (with starting vdate+1) to different specific customers or customer types.     
       The promotions have a customer type column so that a subset/segment of the customers is offered the promotion.
  2. Run the PriceEventExecutionBatch process and observe long runs.

 

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