Item Induction Performance Issue In V16

(Doc ID 2309107.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

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

Symptoms

In RMS 16:

Item Induction performance issue where are many ( 2000 +)  Items in SVC_ITEM_MASTER table.

1) Login  in RMS front end
2) Under Tasks -- > Items -- > Download items from Staging
3) Enter Item Description, Dept, Class and Subclass

Notice the it takes  very long time. Following query executed which taking time:


SELECT DISTINCT item.ITEM ITEM, item.ITEM_DESC item_desc
  FROM V_IINDUCT_SEARCH_STG item



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