List of Figures

2-1 Installation Progress: Installing the AM Application
2-2 Database Details Screen
2-3 Summary Screen
3-1 Installation Progress: Creating the Argus Mart Data Structure
3-2 Schema Creation Tool
3-3 Oracle Database Connect Dialog Box
3-4 Argus Safety User Creation Dialog Box
3-5 Argus Safety User Creation
3-6 Entering Password for the Argus Safety SYSTEM or INSTALL User
3-7 Verifying AS Database, User, and Log File Details
3-8 Connecting to Argus Mart Database
3-9 Argus Mart Schema Creation Options Dialog Box
3-10 Creating VPD Admin User
3-11 Safety Database Link Information Details
3-12 Oracle Database Connect: Argus Stage User Password
3-13 Oracle Database Connect: Argus Mart User Password
3-14 Oracle Database Connect: Argus Mart Application User Password
3-15 SYS User Details
3-16 Verifying User and Argus Mart Database Details
3-17 Generating DataFile Path and Name
3-18 Verifying the Argus Mart User and Database Details
3-19 Argus Mart to Argus Insight Database Link Creation — DB_LINK_INSIGHT
3-20 Argus Mart to Argus Insight Database Link Creation — ARGUS_MART_TO_INSIGHT_MART
3-21 Schema Validation Utility Dialog Box
3-22 Verifying other Details
4-1 Installation Progress: Creating Multiple Enterprises in Multi-tenant Environment
4-2 Entering TNS Name to Connect to Database
4-3 Connecting to the Database
4-4 Displaying List of Enterprises to be Created in Argus Mart
4-5 Displaying Enterprise Creation Confirmation
5-1 Installation Progress: Configuring ODI Settings
5-2 Creating Login for Repository
5-3 Repository Connection Information
5-4 Import Link
5-5 Displaying Components Imported from the Zip File
5-6 Smart Import Report
5-7 Verifying the Smart Import
5-8 Creating Data Server Connection
5-9 Entering Database Details
5-10 Selecting New Physical Schema
5-11 Selecting Argus ETL User in Definition Section
5-12 Selecting Context for the Data Server
5-13 Viewing the New Physical Schema
5-14 Double-clicking the LP_INI_AM Load Plan
5-15 Load Plan Details
6-1 Installation Progress: Configuring the Argus Mart Application
6-2 System Management Link on Argus Safety Console
7-1 Steps to Upgrade Argus Mart 8.0
7-2 Oracle Database Connect Screen
7-3 Upgrade Parameters Screen
7-4 Tablespace Management Screen
7-5 Add Data File Screen
8-1 Installation Progress: Extracting, Transforming, and Loading Data
8-2 Executing the Initial ETL
8-3 Status of the Load Plan
8-4 Stopping the Initial ETL
8-5 Stopped Initial ETL Session
8-6 Restarting the Initial ETL
8-7 Restarted Load Plan
8-8 Completed Load Plan
8-9 Select Statement 1 to Verify Successful Execution
8-10 Select Statement 2 to Verify Successful Execution
8-11 Navigating to the LP_INC_AM Load Plan
8-12 Viewing Steps of the Load Plan
8-13 Viewing the Status of the ETL Process
8-14 Viewing Completed Steps in the ETL Process
8-15 Viewing the Failed ETL Process
8-16 Viewing the Failed Step for the ETL Process
8-17 Viewing the Error Message
8-18 Viewing the Error Message using the Execution Section
8-19 Viewing Error Message using SQL Developer
8-20 Viewing the Restarted ETL Process Status
8-21 Viewing the Steps of the Restarted ETL
8-22 Oracle Data Integrator Console Screen
8-23 Scenarios/Load Plans
8-24 Executing the Initial ETL
8-25 Status of the Load Plan
8-26 Stopping the Initial ETL
8-27 Stopped Initial ETL Session
8-28 Restarting the Initial ETL
8-29 Navigating to the Load Plans
8-30 Viewing the Steps of the Load Plan
8-31 Initial ETL in Progress
8-32 Viewing Completed Steps in the ETL Process
8-33 Viewing the Failed ETL Process
8-34 Viewing the Failed Step for the ETL Process
8-35 Viewing the Stopped Session
8-36 Viewing the Error Details
8-37 Viewing Error Message using SQL Developer
8-38 Viewing the Restarted ETL Process Status
8-39 Viewing the Steps of the Restarted ETL
9-1 Deleting Oracle Argus Mart through Start Menu
11-1 Study is eligible for Unblinding Checkbox in Argus Safety
13-1 Scheduling ETL
13-2 Scheduling the Load Plan Dialog Box
13-3 Load Plans and Scenarios
13-4 Executing the Incremental ETL
13-5 Start Load Plan Window
13-6 Status of the Load Plan
13-7 Stopping the Incremental ETL
13-8 Selecting the Physical Agent
13-9 Stopped Incremental ETL Session
13-10 Restarting the Incremental ETL
13-11 Restarted Load Plan
13-12 Completed Load Plan
13-13 Staging Phase: Incremental ETL Resumes from Failed or Stopped Point
13-14 Mart Phase: Incremental ETL Resumes from the First Step of Mart
13-15 Select Statement 1 to Verify Successful Execution
13-16 Select Statement 2 to Verify Successful Execution
14-1 Oracle Data Integrator Console Screen
14-2 Scenarios/Load Plans
14-3 Executing the Incremental ETL
14-4 Execute Load Plan Window
14-5 Status of the Load Plan
14-6 Stopping the Incremental ETL
14-7 Stop Load Plan Execution Dialog Box
14-8 Stopped Incremental ETL Session
14-9 Restarting the Incremental ETL
14-10 Restart Load Plan Execution Dialog Box
15-1 Confirmation of Resetting the Mart Environment
15-2 Entering TNS Name to Connect to Database
15-3 Connecting to the Database
15-4 Writing Enterprise Creation Logs
16-1 Dictionary Reload Error Message
16-2 Dictionary Reload Error Message: SQL Developer
16-3 Pre-Requisite Check Failed Error
16-4 FR Consistency Error
16-5 MedDRA Mismatch Error