My Oracle Support Banner

RMS Data Level Security (Doc ID 1211385.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.0 to 13.1 [Release 13.0 to 13.1]
Information in this document applies to any platform.


This document describes data level security in Retail Merchandising System (RMS) - how to setup data filtering for both Group and Area levels. This can be used to prevent users from creating/viewing data for other companies in the setup or organization and merchandise hierarchies.

Questions and Answers

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
Questions and Answers
 Is it possible to only define data filtering for merchandise hierarchy and 'G'roup level, and Org hierarchy filtering at 'A'rea. level?
 Is it necessary to define data security for Transfer Entities, Org Units, Internal/External Finisher?
 Will transfers and order functionality make use of the two proposed filtering definitions Group & Area?
 What other tables are required for data level security besides filter_group_org, filter_group_merch, sec_group, sec_user_group?

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