My Oracle Support Banner

A Merchandise Hierarchy Deleted in RMS is Not Deleted in SIM (Doc ID 2081241.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

In the Store Inventory Management (SIM) application, we find that the PurgeItemHierarchy.sh batch does not delete a merchandise hierarchy from SIM database table ITEM_HIERARCHY.


Steps to Recreate:

  1. In Retail Merchandising System (RMS), mark a department (or class or subclass) of a merchandising hierarchy for deletion.
  2. Let the message flow to SIM.
  3. Query SIM database table ITEM_HIERARCHY and find that the above merch hierarchy is marked with a STATUS of 'D'.
  4. Run the PurgeItemHierarchy.sh batch.
  5. Query SIM database table ITEM_HIERARCHY and find that the above merch hierarchy is not deleted.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.