My Oracle Support Banner

SuperGroup.sql Script Missing in 16.0 RMS Installation (Doc ID 2338073.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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

Goal

User have installed Retail Merchandising System (RMS)16.0.1 with no demo data option.

As per RMS 16.0.1 Installation Guide (Page 38) under Batch Security Setup it is mentioned that :

If RMS was installed without DEMO Data, additional data setup is required to be able to run batch programs.  Data in the table USER_ATTRIB, SEC_USER, SEC_GROUP, and SEC_USER_GROUP need to be populated using the below scripts.

1. Log on to Sqlplus as the RMS schema owner.
2. Insert row into USER_ATTRIB table.
3. Insert into SEC_GROUP and entry for Super Group:
@<STAGING_DIR>/rms/installer/create_db/superGroup.sql

However, the superGroup.sql is missing as part of installer.

Solution

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
Goal
Solution
References


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