Performance Issue with Itemreclass Batch (Doc ID 2251891.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Retail Price Management - Version 14.1.2 and later
Information in this document applies to any platform.

Itemreclass batch is very slow for a 150 items to process

Expected Time: <10 mins

Actual Time: 2 hr+

Steps to Recreate:

1) Setup reclassification on Oracle Retail Merchandising System (RMS).

2) Run RECLASSDLY.PC job

3) See RPM_ITEM_MODIFICATION table has required number of records.

4) Run RPM itemReclassBatch job.

Item reclass batch runs for more then 2 hrs for 150 records.

	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

Symptoms

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