A Merchandise Hierarchy Deleted in RMS Is Not Deleted in SIM (Doc ID 1318436.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 13.1 to 13.2.2 [Release 13.1 to 13.2]
Information in this document applies to any platform.
Checked for relevance Jun-2013
Checked for relevance as on 13-Nov-14

Symptoms

NOTE: The issue reported in this document is observed in SIM versions 13.0.X and also in 13.2.X. This note contains the resolution for both versions. Please download and apply the correct patch matching your version of SIM.

 

A Merchandise Hierarchy deleted in Retail Merchandising System (RMS) is not deleted in Store Inventory Management (SIM).


Steps to Reproduce:

   1. Log in to RMS.
   2. Delete a Subclass/Class/Dept.
   3. The MerchHierarchy remove message flows to SIM, and as a result the RIB_DELETE_FLAG is set to 'Y' in RK_HIERARCHY table.
   4. Log in to SIM.  Even after the Dept/Class/Subclass is deleted, the dropdown in the Item Lookup screen still shows the deleted hierarchy element.
   5. Note that the Unique Identification Number (UIN) Attributes screen still displays the deleted merchandise hierarchy for maintenance.

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