Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Known Installation and Configuration Issues
• Conventions

Part I Installation

1 Introduction

• 1.1 Oracle Argus Mart Overview
• 1.2 How this Guide is Organized

2 Installing the Argus Mart Application

• 2.1 Before You Install the Argus Mart Application
• 2.2 Installing Argus Mart Components

3 Creating the Argus Mart Database Structure

• 3.1 Before Running the Argus Mart Schema Creation Tool
• 3.2 Argus Mart Tablespaces
• 3.3 Starting the Argus Mart Schema Creation Tool
• 3.4 Creating the Database Schema
  • 3.4.1 Creating User for the Argus Safety Database
  • 3.4.2 Clearing the Cache
  • 3.4.3 Creating a New Database Schema for Argus Mart
  • 3.4.4 Loading Factory Data
• 3.5 Validating the Schema

4 Creating Multiple Enterprises in Multi-tenant Environment

5 Configuring ODI Settings

• 5.1 Minimum Components Required
• 5.2 Before Configuring ODI Settings
  • 5.2.1 Creating the Database Users for Master and Work Repositories
  • 5.2.2 Granting Privileges to the Database Users
• 5.3 Creating Master Repository
• 5.4 Creating Work Repository
• 5.5 Importing Argus Mart Schema Object
• 5.6 Creating and Testing Data Server Connection
• 5.7 Creating New Physical Schema
• 5.8 Validating Load Plan
• 5.9 Managing the ODI Agent
  • 5.9.1 Managing the Standalone ODI Agent
    • 5.9.1.1 Setting up the Standalone ODI Agent
    • 5.9.1.2 Encoding User's Password
    • 5.9.1.3 Starting the Standalone ODI Agent
  • 5.9.2 Creating the Java EE Agent
• 5.10 Executing Steps of a Load Plan in Parallel

6 Configuring the Argus Mart Application

7 Upgrading the Argus Mart

• 7.1 Before Upgrading Argus Mart
• 7.2 Upgrading Argus Mart Application
• 7.3 Upgrading Argus Mart Database
• 7.4 Validating Upgraded Schema
• 7.5 Upgrading ODI Metadata
• 7.6 Post Upgrade Processes
  • 7.6.1 Upgrading SM Tables
    • 7.6.1.1 Pre-requisites
    • 7.6.1.2 Executing the Scripts

8 Extracting, Transforming, and Loading Data

• 8.1 Managing Initial ETL Process: ODI Studio
  • 8.1.1 Running the ETL
  • 8.1.2 Stopping the ETL
  • 8.1.3 Restarting the ETL
  • 8.1.4 Processing a Failed ETL
    • 8.1.4.1 Continuing the Failed Initial ETL
    • 8.1.4.2 Restarting the Failed Initial ETL
• 8.2 Monitoring Initial ETL Process: ODI Studio
  • 8.2.1 Viewing the Steps of Load Plan
  • 8.2.2 Monitoring the ETL
  • 8.2.3 Debugging the Failed ETL
  • 8.2.4 Monitoring the Restarted ETL (Resume)
• 8.3 Managing Initial ETL Process: ODI Console
  • 8.3.1 Running the ETL
  • 8.3.2 Stopping the ETL
  • 8.3.3 Restarting the ETL
  • 8.3.4 Processing a Failed ETL
    • 8.3.4.1 Continuing the Failed Initial ETL
    • 8.3.4.2 Restarting the Failed Initial ETL
• 8.4 Monitoring Initial ETL Process: ODI Console
  • 8.4.1 Viewing the Steps of Load Plan
  • 8.4.2 Monitoring the ETL
  • 8.4.3 Debugging the Failed ETL
  • 8.4.4 Monitoring the Restarted ETL (Resume)
• 8.5 Running the Incremental ETL

9 Uninstalling the Argus Mart Application

Part II Administration

10 Setting Context in Multi-tenant Environment

11 Secure Unblinding in Argus Mart

12 Incremental ETL: ODI Studio

• 12.1 Scheduling Incremental ETL
• 12.2 Monitoring Incremental ETL Process
• 12.3 Managing Incremental ETL Process
  • 12.3.1 Running the ETL
  • 12.3.2 Stopping the ETL
  • 12.3.3 Restarting the ETL
  • 12.3.4 Processing a Stopped or a Failed ETL
    • 12.3.4.1 Continuing the Failed Incremental ETL
    • 12.3.4.2 Restarting the Failed Incremental ETL

13 Incremental ETL: ODI Console

• 13.1 Scheduling an ETL
• 13.2 Monitoring Incremental ETL Process
• 13.3 Managing Incremental ETL Process
  • 13.3.1 Running the ETL
  • 13.3.2 Stopping the ETL
  • 13.3.3 Restarting the ETL
  • 13.3.4 Processing a Stopped or a Failed ETL

14 Re-initializing the ETL Process

15 Troubleshooting

• 15.1 Dictionary Reload Error
• 15.2 ETL Execution Pre-Requisite Check Failed Error
• 15.3 FR Consistency Log Error
• 15.4 MedDRA Mismatch Error
• 15.5 Multiple Enterprise Creation Messages
  • 15.5.1 Source Enterprise Does Not Exist In Mart
  • 15.5.2 Enterprise Does Not Exist In Argus Safety
  • 15.5.3 Enterprise Does Not Exist For Configuration In Mart
• 15.6 SMQ-CMQ Loop Error

Index