Poor Performance When Running InjectorPriceEventBatch for Simple Promotions (Doc ID 1967242.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
Checked for relevance on 12-May-2017

Symptoms

We are experiencing a performance issue when running the InjectorPriceEvent batch for simple promotions in Retail Price Management (RPM) 13.2.x.

In our test case, we are attempting to process about 262,000 records at the store level.


Steps to Reproduce:

  1. Populate the RPM_STAGE_PROMO_COMP_SIMPLE
  2. Run the injectorpriceeventbatch for simple promotions
  3. Observe the slow processing time

Changes

 

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