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