My Oracle Support Banner

Poor Performance of RPM Item Reclass Batch (Doc ID 2068482.1)

Last updated on MAY 03, 2021

Applies to:

Oracle Retail Price Management - Version 14.1 to 14.1.3 [Release 14.1]
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 15.0 to 15.0.3 [Release 15.0]
Oracle Retail Price Management - Version 16.0 to 16.0.1 [Release 16.0]
Information in this document applies to any platform.


The 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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.