Table of Contents

1. Preface

1.1 Pre-requisites

1.2 Audience

1.3 Conventions Used

2. Setup and Configuration of the Database Server

2.1 Creating Database

2.1.1 Creating the Database Server Users and Groups

2.1.2 Creating the Database

2.2 Installing the Application Database

2.2.1 Running the installation script

2.2.2 Selecting the Install Type

2.2.3 Setting up the Installation Environment

2.2.4 Creating Application Home directory

2.2.5 Creating Application Tablespaces

2.2.6 Creating the Application Owner User and Grant Tablespace Quotas

2.2.7 Installing Database Objects and Seed Data

2.2.8 Installing Library Objects

2.2.9 Installing Directory Objects

2.3 Modifying Application System Parameters

2.4 Creating Users and Granting Access

2.5 Set the Oracle JVM File Permissions

2.6 Advanced Queues

2.7 Fine-Grained Access to Network Services in Oracle Database

2.8 Installing Upgrade

3. Security Features

3.1 Enabling Transparent Data Encryption to Secure Stored Data

3.2 Data Redaction for Data Masking

4. Optimize PS_TXN Table in Fusion Application

5. Perform Online Application Upgrade Using EBR

6. Machine Learning for Servicing Queue Creation

7. Oracle Autonomous Database for Transaction Processing

7.1 Pre- requisites

7.2 Installation