Performance Issue on RPM NewItemLocation (NIL) Batch (Doc ID 2100270.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

Performance issue when running NewItemLocationBatch.

Steps to Recreate
------------------
1. Create and approve some promotions in the future.
2. Make sure that the promotion will be inherited by the all the new Item/Locations in the subsequent steps below. For example, create and approve a simple promotions at Dept/Zone Level.
3. Create and approve a new Item Parent with three differentiators (DIFFs) in Oracle Retail Merchandising System (RMS) to make sure there are enough Transaction level items.
4. Range these new Items to a lot of locations from the same zone.
5. Make sure that all these Item/Locations are under the same Parent/Zone with the total of more than 15,000 Item/Locations.
6. Run the RPM New Item Location Batch for those 15,000+ Item/Locations.
7. Note that there is a performance issue when running batch.

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