Go to primary content
Oracle® Retail RICS Data Viewer (APEX/DDS) RICS Data Viewer Guide
Release 19.3.000
F79086-01
Next
Contents
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Customer Support
Improved Process for Oracle Retail Documentation Corrections
Oracle Help Center (docs.oracle.com)
Conventions
1
Introduction to RICS on APEX
What is APEX?
Need for RICS on APEX
Functionality Offered
Accessibility
What is Web Accessibility?
Principles of Accessibility
Why Accessibility is Important
About Building for Accessibility
2
Basic Functions of APEX
Adding Users to a Workspace
Create a New User
Create Multiple Users
Querying Data
Viewing Tables
Describe Tables
Query Table Data
3
Introduction to Dynamic Data Services (DDS)
What is DDS?
Need for DDS
Functionality Offered
Accessibility
4
DDS Installation Prerequisites
Installation and Setup Instructions
Prerequisites
Installing WebLogic
Creating the Required Schema Using Repository Creation Utility
Creating a WebLogic Domain with JRF
5
Deploying DDS Web Application
Preparing the Database for DDS Installation
Deploying DDS Web Application on the WebLogic Servers
Redeploying DDS Web Application
Testing the Deployment
6
DDS Security
Access Levels
Table Level Security
Column Level Security
Row Level Security
Security Setup
System Options
7
DDS RESTful Services
Discover
Get Data
Get Data from a Table
Insert Data
Update Data
Delete Data
Get Schemas
Get Tables
Get Columns for a Table
Get System Options
Create System Options
Update System Options
Delete System Options
Reset Cache
8
DDS Security RESTful Services
Get Security Groups
Get Security Group Permissions
Get Access Levels
Get Security Config for a Schema
Get All Security Config
Get All Table Level Securities
Get Table Level Security for Table
Get Table Level Security for Table and Group
Get Column Level Security for Table and Group
Get Row Level Security for Table and Group
Create Access Level
Update Access Level
Delete Access Level
Create Table Level Security
Create Table Level Securities
Update Table Level Security
Update Table Level Securities
Delete Table Level Security
Delete Table Level Security by Id
Delete Table Level Securities by Type
Create Column Level Security
Update Column Level Security
Delete Column Level Security
Create Data Security Configuration
Update Data Security Configuration
Delete Data Security Configuration
Create Security Group
Delete Security Group
Create Row Level Security
Update Row Level Security
Delete Row Level Security
Create Default Security Setup
9
DDS User Interface
Admin Tab Guide
Initial Permissions Setup
Manage Access Levels
Manage Security Groups
Manage Security Permissions
Designer Tab Guide
Table Definition
Query Builder
10
DDS Advanced Backend Features
LIKE Statement
IN Statement
Comparative Operators
Filtering DATE Column
Combinations of OR, AND & BETWEEN Statements
Viewing Clob Data
Viewing Query Response as JSON Data
JOINing Two or More Tables
Count of Records