List of Figures

• 2-1 Installation Progress: Installing the AM Application
• 2-2 Welcome Screen
• 2-3 About Oracle Universal Installer
• 2-4 List of Installed Products
• 2-5 Specify Home Details Screen
• 2-6 Oracle Home Location Screen
• 2-7 Database Details Screen
• 2-8 Summary Screen
• 2-9 End Of Installation Screen
• 2-10 Verifying Successful Argus Mart Installation
• 2-11 Exit Confirmation Window
• 3-1 Installation Progress: Creating the Argus Mart Data Structure
• 3-2 Schema Creation Tool
• 3-3 Schema Creation Tool: Creating Argus Safety User
• 3-4 Oracle Database Connect Dialog Box
• 3-5 Argus Safety User Creation Dialog Box
• 3-6 New User Dialog Box
• 3-7 Argus Safety User Creation
• 3-8 Save Log File Dialog Box
• 3-9 Saving Log File
• 3-10 Entering Password for the SYSTEM User
• 3-11 Verifying User and Database Details
• 3-12 Verifying AS Database, User, and Log File Details
• 3-13 User Creation Confirmation
• 3-14 Clearing Cache
• 3-15 Schema Creation Tool: Create Schema
• 3-16 Connecting to Argus Mart Database
• 3-17 Argus Mart Schema Creation Options Dialog Box
• 3-18 New User Dialog Box
• 3-19 Creating VPD Admin User
• 3-20 Selecting Users in the Argus Mart Schema Creation Options Dialog Box
• 3-21 Safety Database Link Information Details
• 3-22 Oracle Database Connect: Argus Stage User Password
• 3-23 Oracle Database Connect: Argus Mart User Password
• 3-24 SYS User Details
• 3-25 Verifying User and Argus Mart Database Details
• 3-26 Tablespace Creation Dialog Box
• 3-27 Generating DataFile Path and Name
• 3-28 Argus Mart Database Installation Dialog Box
• 3-29 Argus Mart Database Successful Installation: Confirmation Screen
• 3-30 Schema Creation Tool
• 3-31 The Connect to Argus Mart Database Screen
• 3-32 Entering Argus Mart User Password
• 3-33 Verifying the Argus Mart User and Database Details
• 3-34 Loading Factory Data
• 3-35 Loading Factory Data Successful: Confirmation Screen
• 3-36 Schema Creation Tool: Validating the Schema
• 3-37 Schema Validation: Connecting to Argus Mart Database
• 3-38 Schema Validation Utility Dialog Box
• 3-39 Schema Validation: Selecting CTL File
• 3-40 Schema Validation: Selecting Folder for the Log Files
• 3-41 Schema Validation: Log Files Location
• 3-42 Entering SYSTEM User Password
• 3-43 Verifying User and Database Details
• 3-44 Verifying other Details
• 3-45 Entering Database Administrator Password
• 3-46 Schema Validation: Successful Confirmation Screen
• 4-1 Installation Progress: Creating Multiple Enterprises in Multi-tenant Environment
• 4-2 Entering TNS Name to Connect to Database
• 4-3 Entering Argus ETL User
• 4-4 Connecting to the Database
• 4-5 Displaying List of Enterprises to be Created in Argus Mart
• 4-6 Displaying Enterprise Creation Confirmation
• 5-1 Installation Progress: Configuring ODI Settings
• 5-2 Minimum Components Required for Setting-up ODI
• 5-3 Creating Master Repository
• 5-4 Master Repository Creation Wizard
• 5-5 Connection Successful Confirmation Message
• 5-6 Authentication Screen
• 5-7 Password Storage Screen
• 5-8 Creating Master Repository
• 5-9 Master Repository Creation Successful Confirmation Message
• 5-10 Creating Login for Master Repository
• 5-11 Repository Connection Information
• 5-12 New Work Repository Option
• 5-13 Specify ODI Work Repository connection properties screen
• 5-14 Specify ODI Work Repository properties screen
• 5-15 Creating Work Repository
• 5-16 Displaying the Option to Create Work Repository Login
• 5-17 Viewing New Work Repository
• 5-18 Creating Login for Work Repository
• 5-19 Repository Connection Information
• 5-20 Import Link
• 5-21 Import Selection Dialog Box
• 5-22 Smart Import Window
• 5-23 Displaying Components Imported from the Zip File
• 5-24 Import Summary Screen
• 5-25 Smart Import Report
• 5-26 Save Report Window
• 5-27 Path of the Saved Report File
• 5-28 Report File Saved Confirmation
• 5-29 Verifying the Smart Import
• 5-30 Creating Data Server Connection
• 5-31 Entering Connection Details
• 5-32 Entering Database Details
• 5-33 Testing the Connection
• 5-34 Test Connection Dialog Box
• 5-35 Successful Connection Confirmation
• 5-36 Selecting New Physical Schema
• 5-37 Selecting Argus ETL User in Definition Section
• 5-38 Selecting Context for the Data Server
• 5-39 Selecting Context and Logical Schema
• 5-40 Viewing the New Physical Schema
• 5-41 Double-clicking the LP_INI_AM Load Plan
• 5-42 Selecting No in the Object Locking Screen
• 5-43 Load Plan Details
• 5-44 No Errors Confirmation for the Load Plan
• 5-45 Setting the Standalone Agent IP Address
• 5-46 Encoding the ODI Master Repository Password
• 5-47 Double-clicking the LP_INI_AM Load Plan
• 5-48 Adding Parallel Step to the List of Steps
• 5-49 Executing Load Plan Steps in Parallel
• 6-1 Installation Progress: Configuring the Argus Mart Application
• 6-2 System Management Link on Argus Safety Console
• 6-3 Argus Mart Link in Argus Safety Console
• 6-4 List of Common Profile Switches for Argus Mart
• 6-5 Non-Default Enterprise: List of Common Profile Switches
• 7-1 Steps to Upgrade Argus Mart 1.0
• 7-2 Argus Mart Application Upgrade Tool
• 7-3 Oracle Database Connect Screen
• 7-4 Upgrade Parameters Screen
• 7-5 Tablespace Management Screen
• 7-6 Add Data File Screen
• 7-7 Updated Tablespace Management Screen
• 7-8 Tablespace Management Screen (with Next Button Enabled)
• 7-9 Continue Database Upgrade Screen
• 7-10 Database Upgrade Completion Screen
• 7-11 Upgrade Script Error Screen
• 7-12 List of Parameters
• 7-13 Event List Upgrade Script: Completion Screen
• 8-1 Installation Progress: Extracting, Transforming, and Loading Data
• 8-2 Oracle Data Integrator Login Window
• 8-3 Load Plans and Scenarios
• 8-4 Load Plan for Initial ETL
• 8-5 Executing the Initial ETL
• 8-6 Start Load Plan Window
• 8-7 Load Plan Started Confirmation Message
• 8-8 Status of the Load Plan
• 8-9 Stopping the Initial ETL
• 8-10 Selecting the Physical Agent
• 8-11 Stopped Initial ETL Session
• 8-12 Restarting the Initial ETL
• 8-13 Restart Load Plan Dialog Box
• 8-14 Loan Plan restarted Confirmation Message
• 8-15 Restarted Load Plan
• 8-16 Completed Load Plan
• 8-17 Select Statement 1 to Verify Successful Execution
• 8-18 Select Statement 2 to Verify Successful Execution
• 8-19 Navigating to the LP_INC_AM Load Plan
• 8-20 Viewing Steps of the Load Plan
• 8-21 Viewing the Status of the ETL Process
• 8-22 Viewing Completed Steps in the ETL Process
• 8-23 Viewing the Failed ETL Process
• 8-24 Viewing the Failed Step for the ETL Process
• 8-25 Viewing the Error Message
• 8-26 Viewing the Error Message using the Execution Section
• 8-27 Viewing Error Message using SQL Developer
• 8-28 Viewing the Restarted ETL Process Status
• 8-29 Viewing the Steps of the Restarted ETL
• 8-30 Oracle Data Integrator Sign In Window
• 8-31 Oracle Data Integrator Console Screen
• 8-32 Scenarios/Load Plans
• 8-33 Executing the Initial ETL
• 8-34 Execute Load Plan Window
• 8-35 Load Plan Started Confirmation Message
• 8-36 Status of the Load Plan
• 8-37 Stopping the Initial ETL
• 8-38 Stop Load Plan Execution Dialog Box
• 8-39 Load Plan Stopped Confirmation Message
• 8-40 Stopped Initial ETL Session
• 8-41 Restarting the Initial ETL
• 8-42 Restart Load Plan Execution Dialog Box
• 8-43 Loan Plan restarted Confirmation Message
• 8-44 Navigating to the Load Plans
• 8-45 Viewing the Steps of the Load Plan
• 8-46 Initial ETL in Progress
• 8-47 Viewing Completed Steps in the ETL Process
• 8-48 Viewing the Failed ETL Process
• 8-49 Viewing the Failed Step for the ETL Process
• 8-50 Viewing the Error Message
• 8-51 Viewing the Stopped Session
• 8-52 Viewing the Error Details
• 8-53 Viewing Error Message using SQL Developer
• 8-54 Viewing the Restarted ETL Process Status
• 8-55 Viewing the Steps of the Restarted ETL
• 9-1 Uninstalling Argus Mart
• 9-2 Inventory Screen
• 9-3 Selecting Argus Mart for Uninstallation
• 9-4 Confirmation to Un-install Argus Mart
• 9-5 Deleting Oracle Argus Mart through Start Menu
• 11-1 Study is eligible for Unblinding Checkbox in Argus Safety
• 12-1 Scheduling ETL
• 12-2 Scheduling the Load Plan Dialog Box
• 12-3 Oracle Data Integrator Login Window
• 12-4 Load Plans and Scenarios
• 12-5 Executing the Incremental ETL
• 12-6 Start Load Plan Window
• 12-7 Load Plan Started Confirmation Message
• 12-8 Status of the Load Plan
• 12-9 Stopping the Incremental ETL
• 12-10 Selecting the Physical Agent
• 12-11 Stopped Incremental ETL Session
• 12-12 Restarting the Incremental ETL
• 12-13 Restart Load Plan Dialog Box
• 12-14 Loan Plan restarted Confirmation Message
• 12-15 Restarted Load Plan
• 12-16 Completed Load Plan
• 12-17 Staging Phase: Incremental ETL Resumes from Failed or Stopped Point
• 12-18 Mart Phase: Incremental ETL Resumes from the First Step of Mart
• 12-19 Select Statement 1 to Verify Successful Execution
• 12-20 Select Statement 2 to Verify Successful Execution
• 13-1 Oracle Data Integrator Sign In Window
• 13-2 Oracle Data Integrator Console Screen
• 13-3 Scenarios/Load Plans
• 13-4 Executing the Incremental ETL
• 13-5 Execute Load Plan Window
• 13-6 Load Plan Started Confirmation Message
• 13-7 Status of the Load Plan
• 13-8 Stopping the Incremental ETL
• 13-9 Stop Load Plan Execution Dialog Box
• 13-10 Load Plan Stopped Confirmation Message
• 13-11 Stopped Incremental ETL Session
• 13-12 Restarting the Incremental ETL
• 13-13 Restart Load Plan Execution Dialog Box
• 13-14 Loan Plan restarted Confirmation Message
• 14-1 Confirmation of Resetting the Mart Environment
• 14-2 Entering TNS Name to Connect to Database
• 14-3 Connecting to the Database
• 14-4 Writing Enterprise Creation Logs
• 15-1 Dictionary Reload Error Message
• 15-2 Dictionary Reload Error Message: SQL Developer
• 15-3 Pre-Requisite Check Failed Error
• 15-4 FR Consistency Error
• 15-5 MedDRA Mismatch Error