My Oracle Support Banner

Incorrect Mapping of STORE_HIERARCHY for New Area (Doc ID 2686654.1)

Last updated on JULY 06, 2020

Applies to:

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


A new area was created in Retail Merchandising System ( RMS ) and mapped the expected regions to be under it. In RMS the recors are linked, but the STORE_HIERARCHY table was not updated with this new values.
The associations for the new created area should be updated also in STORE_HIERARCHY table.

Steps to reproduce:
1. Log in RMS.
2. Navigate to "Tasks"
3. Select "Foundation Data"
4. Select "Location"
5. Select "Organizational Hierarchy"
6. Navigate to "Area"
7. Click "Create" > Click "+" sign to create (add details)
8. Click "OK" > Click "Save and Close"
9. Navigate to "Region"
10. Click "Edit"
11. Select a region that should fall for the newly created Area
12. Click "Edit"
13. Change the Area (selecting the newly created Area)
14. Click "Ok"
15. Click "Save and Close"
16. Navigate to "Area"
17. Validate the attached Region by clicking the icon in "Regions" column - this should reflect the moved region
18. In Database, Validate in STORE_HIERARCHY table if the Area-Region mapping is updated.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.