Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
7
Data Viewer
Data Viewer is a workspace that provides read-only access to the Merchandising functional data in production environments and read/write access in non-production environments. In production environments, this extension is a workspace for customer support personnel to view the data to troubleshoot issues. In non-production environments, there is more flexibility to assist with conversion of data, configuration of the solution, and some minor data correction, when required. This chapter provides the steps to configure your workspace in a SaaS environment. This will need to be done for each of your environments where you want this enabled.
Workspace
A workspace <RETAILER_WORKSPACE> is predefined for you and is where workspace users can view the application data. The workspace has the privilege to the allocated <RETAILER_WORKSPACE_SCHEMA> database schema. The schema has the synonyms with read only privileges (in production) or read-write privileges (in non-production) to the Merchandising database tables and views. There are a few tables that are excluded, which are either used internally only (e.g. temp tables) or tables in the encrypted schema.
Users and Roles
Data Viewer has two types of users, workspace viewer and workspace administrators. As a workspace administrator, you can create and edit workspace viewer accounts, monitor the activities.
For SaaS implementations, the first time that you access the Data Viewer, only the person designated as your initial service administrator (such as, the receiver of the welcome email) will be setup with access. You will need to log in with that username/password in order to provide other users with access, including other administrators. Before you create accounts for your users, you must create users in Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) with the same user name.
Create a Workspace Viewer
Perform the following procedure to create a workspace viewer:
1. Log in to Merchandising.
Note
Although data from other Merchandising cloud services can also be viewed using this capability, the only access for this link is in Merchandising.
2. From the Tasks list, under Application Administration, select Data Viewer.
Administration Guide G59101-01 Copyright© 2026, Oracle and/or its affiliates.
Application Administration
Oracle Application Express
(R ‘rms_admin
Please select a workspace from the list below
In this guide
- Guide: Merchandising Cloud Services Administration Guide
- Previous: 6 Other Settings