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 DBA 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 Argus Mart Database Successful Installation: Confirmation Screen
• 3-19 Verifying the Argus Mart User and Database Details
• 3-20 Argus Mart to Argus Insight Database Link Creation — DB_LINK_INSIGHT
• 3-21 Argus Mart to Argus Insight Database Link Creation — ARGUS_MART_TO_INSIGHT_MART
• 3-22 Schema Validation Utility Dialog Box
• 3-23 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 Master Repository Creation Wizard
• 5-3 Authentication Screen
• 5-4 Password Storage Screen
• 5-5 Creating Login for Repository
• 5-6 Repository Connection Information
• 5-7 New Work Repository Option
• 5-8 Specify ODI Work Repository connection properties screen
• 5-9 Specify ODI Work Repository properties screen
• 5-10 Viewing New Work Repository
• 5-11 Import Link
• 5-12 Displaying Components Imported from the Zip File
• 5-13 Smart Import Report
• 5-14 Verifying the Smart Import
• 5-15 Creating Data Server Connection
• 5-16 Entering Database Details
• 5-17 Selecting New Physical Schema
• 5-18 Selecting Argus ETL User in Definition Section
• 5-19 Selecting Context for the Data Server
• 5-20 Viewing the New Physical Schema
• 5-21 Double-clicking the LP_INI_AM Load Plan
• 5-22 Load Plan Details
• 5-23 Adding Parallel Step to the List of Steps
• 5-24 Executing Load Plan Steps in Parallel
• 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 7.0.3
• 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 Oracle Data Integrator Login Screen
• 8-3 Load Plans and Scenarios
• 8-4 Load Plan for Initial ETL
• 8-5 Executing the Initial ETL
• 8-6 Status of the Load Plan
• 8-7 Stopping the Initial ETL
• 8-8 Stopped Initial ETL Session
• 8-9 Restarting the Initial ETL
• 8-10 Restarted Load Plan
• 8-11 Completed Load Plan
• 8-12 Select Statement 1 to Verify Successful Execution
• 8-13 Select Statement 2 to Verify Successful Execution
• 8-14 Navigating to the LP_INC_AM Load Plan
• 8-15 Viewing Steps of the Load Plan
• 8-16 Viewing the Status of the ETL Process
• 8-17 Viewing Completed Steps in the ETL Process
• 8-18 Viewing the Failed ETL Process
• 8-19 Viewing the Failed Step for the ETL Process
• 8-20 Viewing the Error Message
• 8-21 Viewing the Error Message using the Execution Section
• 8-22 Viewing Error Message using SQL Developer
• 8-23 Viewing the Restarted ETL Process Status
• 8-24 Viewing the Steps of the Restarted ETL
• 8-25 Oracle Data Integrator Console Screen
• 8-26 Scenarios/Load Plans
• 8-27 Executing the Initial ETL
• 8-28 Status of the Load Plan
• 8-29 Stopping the Initial ETL
• 8-30 Stopped Initial ETL Session
• 8-31 Restarting the Initial ETL
• 8-32 Navigating to the Load Plans
• 8-33 Viewing the Steps of the Load Plan
• 8-34 Initial ETL in Progress
• 8-35 Viewing Completed Steps in the ETL Process
• 8-36 Viewing the Failed ETL Process
• 8-37 Viewing the Failed Step for the ETL Process
• 8-38 Viewing the Error Message
• 8-39 Viewing the Stopped Session
• 8-40 Viewing the Error Details
• 8-41 Viewing Error Message using SQL Developer
• 8-42 Viewing the Restarted ETL Process Status
• 8-43 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 Oracle Data Integrator Login Window
• 13-4 Load Plans and Scenarios
• 13-5 Executing the Incremental ETL
• 13-6 Start Load Plan Window
• 13-7 Load Plan Started Confirmation Message
• 13-8 Status of the Load Plan
• 13-9 Stopping the Incremental ETL
• 13-10 Selecting the Physical Agent
• 13-11 Stopped Incremental ETL Session
• 13-12 Restarting the Incremental ETL
• 13-13 Restart Load Plan Dialog Box
• 13-14 Loan Plan restarted Confirmation Message
• 13-15 Restarted Load Plan
• 13-16 Completed Load Plan
• 13-17 Staging Phase: Incremental ETL Resumes from Failed or Stopped Point
• 13-18 Mart Phase: Incremental ETL Resumes from the First Step of Mart
• 13-19 Select Statement 1 to Verify Successful Execution
• 13-20 Select Statement 2 to Verify Successful Execution
• 14-1 Oracle Data Integrator Sign In Window
• 14-2 Oracle Data Integrator Console Screen
• 14-3 Scenarios/Load Plans
• 14-4 Executing the Incremental ETL
• 14-5 Execute Load Plan Window
• 14-6 Load Plan Started Confirmation Message
• 14-7 Status of the Load Plan
• 14-8 Stopping the Incremental ETL
• 14-9 Stop Load Plan Execution Dialog Box
• 14-10 Load Plan Stopped Confirmation Message
• 14-11 Stopped Incremental ETL Session
• 14-12 Restarting the Incremental ETL
• 14-13 Restart Load Plan Execution Dialog Box
• 14-14 Loan Plan restarted Confirmation Message
• 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