Poor Performance of RPM Item Reclass Batch

(Doc ID 2068482.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.4 to 13.2.4 [Release 13.2]
Oracle Retail Price Management - Version 14.0 to 14.0.3 [Release 14.0]
Oracle Retail Price Management - Version 14.1 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.

Symptoms

The Retail Price Management (RPM) item reclassification job takes an unacceptable amount of time, even for small numbers of records.  In a typical sample set, this job takes more than 1 hour 30 minutes to complete 150 records. It is expected that job should take about 20 to 25 minutes for a volume of about 200 records.


Steps to Reproduce:

  1. Setup reclassification in Oracle Retail Merchandising System (RMS).
  2. Run RECLASSDLY.PC job.
  3. Ensure that the RPM_ITEM_MODIFICATION table has the required number of records.
  4. Run RPM itemReclassBatch job.

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