Poor Performance of RPM Item Reclass Batch
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.
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:
- Setup reclassification in Oracle Retail Merchandising System (RMS).
- Run RECLASSDLY.PC job.
- Ensure that the RPM_ITEM_MODIFICATION table has the required number of records.
- Run RPM itemReclassBatch job.
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