Item Induction Performance Issue In V16
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.
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
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