Performance Issue With Xitem Item/Zone/Price Processing Which Takes 7+ Hours (Doc ID 2233517.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms


When XItem is used to populate items into Oracle Retail Merchandising System(RMS)  and XIZP structure is included in the message presented, processing time for the pricing records is excessive and some items take 7+ hours to process.

Since the XIZP structure is by Store, for each Zone Group/Zone defined in RPM and item being processed, there is a loop on the records provided in the message (pulled from SVC_XITEM_RIZP and SVC_XITEM_RIZP_LOCS).

Inner loop is performed on each zone/location as defined in RPM for the Zone Group/Zone which includes a query performed by cursor C_MATCH_LOC to match locations.
In a case of 6,000+ locations there are more than 30 milllion loops as the structures in each loop will have over 6,000 elements.

The issue can be reproduced at will with the following steps:

  1. Item is created that contains more than 100+ stores in the base zone
  2. include 1 Store in the XIZP structure



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