ISQL Global Logo
Location Contact Us Certification Placements Corporate Courses About Us

    Oracle 11i Clinical Training & Placements in Chennai "ISQL Global"

    1 Setting Up User Accounts Creating an Administrator User Account
    • Setting Up Required Accounts and Directories
    • Setting Up a Reports Server Log Directory
    • Creating an Operating System Account
    • Creating a PSUB Log Directory
    • Ensuring PSUB Execution Permission (UNIX Only)
    • Modifying the RXCPROD Account's Profile
    • Running the Add User Script
    • About the Add User Script
    • Running the Add User Script in UNIX
    • Running the Add User Script in Windows
    • Required Parameters
    • Optional Parameters
    • Maintaining Oracle User and Group User Accounts
    • Adding a User to a Group User Account
    • Granting Data Access to User and Group User Accounts Granting Data Access to Programs and Projects
    • Granting Data Access to a Study
    • SuperUser and Study Access Interaction
    • Revoking User Access
    • Granting Data Access to RDC Users
    • Granting Automatic Access in RDC to Studies Granted in Oracle Clinical
    • Configuring Study and Site Security Privileges
    • Changing the Default Access to DCIs
    • iv Granting Additional Database Roles to User Accounts Additional Database Roles for RDC Users
    • Additional Database Roles for Oracle Clinical Users
    • Setting Up Data Extract Users
    • Creating an Operating System Account on the SAS Server
    • Adding User to the OCLSASCR User Group
    • Creating a Queries Table for a Data Extract User
    • Setting Up Power Users
    • UNIX
    • Windows
    • Setting Up Passwords
    • Changing the Password for a Schema or Role
    • Changing the Password for a User
    • Enforcing Password Security
    • Auditing Passwords
    • Operating System Passwords
    • Creating Profiles for Users
    2 Oracle Clinical Menu-Based Security Predefined Database Roles
    • Creating and Modifying Database Roles
    • Viewing Menu-Role Associations
    • Modifying Menu-Role Associations
    • Creating Custom Database Roles
    • Associating Roles with Menus
    • Adding a Custom Role to OPA_MENU_ROLES
    • Granting a Custom Role Access to a Custom Module
    • Adding Menu Items to Oracle Clinical
    3 Configuring Discrepancy Management Mapping Database Roles to User Roles
    • Specifying User Roles for the Oracle Clinical Discrepancy Database
    • Assigning Function Privileges and Layouts
    • Customizing Layout Definitions
    • Customizing Profiles
    • Toggling Between View Modes in the Profile Administration Window
    • Specifying Default Profile Criteria
    • Locking Profile Criteria
    • Adding SQL Statements
    • Filtering Profile Views by Review Status
    • Updating Status Codes
    • Filtering Profile Views by Discrepancy Field
    • Customizing Flexfields
    • DISC_FLEX1 and DISC_FLEX2
    • DISC_FLEX1_VALUES and DISC_FLEX2_VALUES
    • Example
    • Defining Reason Codes for
    • v Reason Codes and Descriptions for Manual Discrepancies
    • Reason Codes and Descriptions for Univariate Discrepancies
    • Reason Codes and Descriptions for Multivariate Discrepancies
    • Defining the Possible Review Statuses for Discrepancies
    • Default Entries for the DISCREPANCY REV STATUS CODE Codelist
    • Rules for the DISCREPANCY REV STATUS CODE Codelist
    • Defining Resolution Reasons for Discrepancies
    • Setting Values in the OCL_STATE Local Reference Codelist
    • Configuring Role-Specific Discrepancy Management for RDC
    • Configuring Discrepancy Display by User Role
    • Configuring the Actions Allowed on Discrepancies
    • Preventing Update to OTHER Discrepancies
    • Adding Reference Codelists for Custom Roles
    • Configuring Study and Site Security for Discrepancy Management
    • Updating a Discrepancy
    • Navigating to Data Entry vi Default Behavior
    • Functions Used to Modify CRF Column Headers
    • Functions
    • Customizing Online Help
    • Modifying Calls to Online Help Topic Files
    • Copying Xhelp Topic Files
    • Creating Custom Help Files
    • Viewing Xhelp Without Oracle Clinical
    6 Configuring Data Extract Configuring Default Installation Data Extract Settings
    • Setting Values in Data Extract-Related Reference Codelists
    • Creating Table spaces for Data Extract Tables and Indexes
    • Creating Table spaces
    • Entering Tablespace Names in Reference Codelists
    • Creating Data Extract Access Accounts Using Local Table spaces
    • Customizing Data Extract Views
    • Generating Data Extract Views
    • Running gen_views on UNIX Platforms
    • Running gen_views on Windows
    • Enabling the View Builder and Converting Views
    • Converting Views
    • Enabling the View Builder in a Study
    • Controlling Access to Data Extract Views
    7 Reference Codelists Overview of Reference Codelists
    • Working in the Maintain or Query Reference Codelists Windows
    • Adding a Value to a Reference Codelist
    • Modifying a Value in a Reference Codelist
    • Running the Reference Codelists Report
    • Local Reference Codelists
    • BATCH QUEUE NAME Local Codelist
    • DB_LINKS Local Codelist
    • DCF COMMENT TEXT Local Codelist
    • DCF DEFAULT FOOTERS Local Codelist
    • DCF DEFAULT HEADERS Local Codelist
    • DCF REPORT LABELS Local Codelist
    • DISC COLS Local Codelist
    • DISC_FLEX1 and DISC_FLEX2 Local Codelists
    • DISC_FLEX1_VALUES and DISC_FLEX2_VALUES Local Codelists
    • FLD RXCMCMCD RDCI DELETE Local Codelist
    • FLD RXCMCMCD RDCI KEY Local Codelist
    • FLD RXCMCMCD RDCM KEY Local Codelist
    • FLD RXCMCMCD RESPONSE Local Codelist
    • IND DISC COLS Local Codelist
    • MAN DISC COLS Local Codelist
    • vii MANHD DISC COLS Local Codelist
    • MC CDS SORT ORDER Local Codelist
    • MC COLUMNS Local Codelist
    • MULTI DISC COLS Local Codelist
    • NLS_CONFIG Local Codelist
    • OCL_DE_CONFIG Local Codelist
    • OCL_DE_PREFS Local Codelist
    • OCL_JOB_PREF Local Codelist
    • OCL MC PREFS Local Codelist
    • OCL_MENU_ACCESS Local Codelist
    • OCL_STATE Local Codelist
    • PRINT QUEUE NAME Local Codelist
    • PUBLIC_DB_LINKS Local Codelist
    • RDC CONFIGURATION Role Local Codelists
    • REPORT_SERVER Local Codelist
    • SAS_QUEUE Local Codelist
    • SQL FUNCTIONS Local Codelist
    • TMS_DSI Local Codelist
    • TMS_OPTIONS Local Codelist
    • UNI DISC COLS Local Codelist
    • WEB_DOCUMENT_CONFIG Local Codelist
    • WEB_DOCUMENT_GROUPS Local Codelist
    • Installation Reference Codelists
    • APPLICATION AREA CODE Installation Codelist
    • APPLICATION SYSTEM NAME Installation Codelist
    • APPROVE VERIFY RETAIN CODE Installation Codelist
    • APPROVE VERIFY REVERSE CODE Installation Codelist
    • BLIND TYPE CODE Installation Codelist
    • CLINICAL PHASE Installation Codelist
    • COUNTRIES Installation Codelist
    • CRF PAGE NUMBERING SCHEME Installation Codelist
    • CRF PAGE STATUS CODES Installation Codelist
    • CRF PAGE STATUS QUERY Installation Codelist
    • DATA CHANGE REASON TYPE CODE Installation Codelist
    • DATA CHANGE REASON2 TYPE CODE Installation Codelist
    • DCF LOCK CONDITIONS Installation Codelist
    • DCF OPTIONAL STATUS CODES Installation Codelist
    • DCF STATUS CODES Installation Codelist
    • DCIF CHECKBOX SIZE Installation Codelist
    • DCIF FONT TYPESIZE Installation Codelist
    • DCIF PAGE DEFINITION Installation Codelist
    • DCM DCI QG TYPE CODE Installation Codelist
    • DISCREPANCY ACTIONS ROLE Installation Codelist
    • DISCREPANCY MESSAGES Installation Codelist
    • DISCREPANCY NO OTHER UPDATE Installation Codelist
    • DISCREPANCY RESOLU TYPE CODE Installation Codelist
    • DISCREPANCY REV STATUS CODE Installation Codelist
    • viii DISCREPANCY STATUS ROLE Installation Codelists
    • DISCRETE VAL GRP TYPE CODE Installation Codelist
    • DISC_STDST_VALUES Installation Codelist
    • DOSE FORM TYPE CODE Installation Codelist
    • DOSE FREQUENCY TYPE CODE Installation Codelist
    • DX_CONFIG Installation Codelist
    • DX_EXTENDED_ATTRIBUTES Installation Codelist
    • DX_INDEX_TABLESPACE Installation Codelist
    • DX_KEY_NAME Installation Codelist
    • DX_ROLES Installation Codelist
    • DX_VIEW_TABLESPACE Installation Codelist
    • EXP DESIGN TYPE CODE Installation Codelist
    • EXTERNAL_TRANS_TYPE Installation Codelist
    • LAB RANGE SUBSET CODE Installation Codelist
    • MANUAL SOURCE TYPE CODE Installation Codelist
    • MAPPING_TYPE Installation Codelist
    • MEDICAL EVAL TYPE CODE Installation Codelist
    • OBJECTIVE TYPE CODE Installation Codelist
    • OCL_DOMAINS Installation Codelist
    • OCL_ INSTALLATION Installation Codelist
    • OCL_OPTIONS_TYPE_CODE Installation Codelist
    • OPA_MENU_ROLES Installation Codelist
    • PATIENT STATUS CODE Installation Codelist
    • PLAN STUDY INT TYPE CODE Installation Codelist
    • PROCEDURE TYPE CODE Installation Codelist
    • QUESTION CATEGORY TYPE CODE Installation Codelist
    • RDCI CHANGE REASON TYPE CODE Installation Codelist
    • RDCI CHANGE REASON2 TYPE CODE Installation Codelist
    • REGION TYPE CODE Installation Codelist
    • RETIREMENT REASON TYPE CODE Installation Codelist
    • ROUTE OF ADMIN TYPE CODE Installation Codelist
    • SAS_FORMATS Installation Codelist
    • SINGLE DCI TYPES Installation Codelist
    • SOURCE LOCATION CODE Installation Codelist
    • STANDARDS AFFIL TYPE CODE Installation Codelist
    • STUDY STATUS TYPE CODE Installation Codelist
    • TMS_CONFIGURATION Installation Codelist
    • TMS_LANGUAGES Installation Codelist
    • TMS_QUERY_TYPE Installation Codelist
    • TMS_SOURCE_MAT_VIEWS Installation Codelist
    • TMS_TAL_POOL_CONFIGURATION Installation Codelist
    • TMS_X_SEARCH Installation Codelist
    • TREAT CHG REASON TYPE CODE Installation Codelist
    • UNITS_OF_MEASURE_TYPE_CODE Installation Codelist
    • User GROUP ROLES Installation Codelist
    • User GROUPS Installation Codelist
    • VALIDATION FAILURE TYPE CODE Installation Codelist
    • ix Design Installation Reference Codelists
    • System Reference Codelists
    • Part II Oracle Clinical Administration Tasks
    8 Managing Batch Jobs User Account Requirements for Batch Jobs
    • How PSUB Handles a Request
    • Asynchronous PSUB Requests
    • Blocking and Nonblocking Jobs
    • Checking a Nonblocking Batch Job
    • Starting and Stopping PSUB
    • Starting and Stopping PSUB Manually in UNIX
    • Starting and Stopping PSUB Automatically in UNIX
    • Starting and Stopping PSUB Manually in Windows
    • Starting PSUB Automatically in Windows
    • Managing the PSUB Process
    • Changing PSUB Job Number Sequencing
    • Viewing the Status of a Submitted Batch Job
    • Removing the PSUB Service
    • Viewing Log and Output Files on the Screen
    • Using Job Sets to Control Execution Order
    • Tracking PSUB Processes
    • Batch Job Reference Codelists
    9 Partitioning and Indexing Introduction
    • Timing Considerations and Deferral of Index or Partition Upgrade
    • About Partitioning
    • Planning for Partitioning Upgrade
    • Pre-upgrade Steps
    • Partitioning the Responses Table
    • Step 1 Back Up the Database
    • Step 2 Export the Responses Table
    • Step 3 Prepare the Database
    • Step 4 Import Responses Data
    • Step 5 Compute Statistics on the Responses Table
    • Step 6 Create Indexes on Partitioned Responses Table
    • Step 7 Compile Invalid Objects and Restore Database Trigger
    • Step 8 Back Up the Database
    • Step 9 Regenerate Procedures and Data Extract Views
    • Step 10 Back Up the Database
    • Partition Maintenance
    • Upgrading Indexes
    • Index Upgrade Process
    • Resizing the Storage Clause for Indexes
    • x Response Index Upgrade
    • ResponsesT (Test Database) Index Upgrade
    • RECEIVED_DCI and RECEIVED_DCM Index Upgrades
    • Query Tuning Guidelines
    10 Utilities Computing the Validation Status of All Responses
    • Running cnvstatus on UNIX 10-1 Running cnvstatus on Windows10-2 Generating Validation Procedures 10-2 Running gen_procs on UNIX Systems 10-3 Running gen_procs on Windows Systems 10-3 Deleting Inactive Procedures
    11 Setting Up File Viewing Overview of the Process to Set Up File Viewing
    • Changing the Default Protocol for File Viewing
    • Editing formswebcfg to Specify the File Viewing Protocol
    • Setting the Oracle Entries in the System Registry for SFTP or FTP
    • Setting Up the Directory Mappings for https and http
    • Setting Up Image Viewing for DCI and DCM Form Layouts html Preview
    • 12 Enabling Image Viewing Setting Up a Central Image Repository
    • Setting Up a Network User to Run the Oracle Process Manager Service
    • Setting Up Image Viewing During Data Entry
    • Copying Image Files to All Installations
    13 Conducting Studies in a Distributed Environment Distributed Study Environments and Replication
    • Locations in a Distributed Study Environment Installation
    • What Types of Oracle Clinical Objects Can You Replicate?
    • What Methods of Replication Does Oracle Clinical Support?
    • Prerequisites to Setting Up Replication
    • Oracle Accounts for Replication
    • Tables that Store Replication Information
    • Seed Numbers for Databases Involved in Replication
    • Setting Up Replication
    • Configuring the SOURCE LOCATION CODE Installation Codelist for Replication
    • Configuring the OCL_INSTALLATION Installation Reference Codelist for Replication
    • Configuring the OCL_STATE Local Reference Codelist for Replication
    • Creating and Setting Up the Database Links for Standard Replication
    • Creating the Study Design Replication Packages
    • Using the rxasrallsql Script
    • Creating the Views and Synonyms Required to Replicate Study Design
    • Creating the Package for Replicating Investigators and Sites
    • xi Setting Up Symmetric Replication
    • Setting Up Symmetric Replication
    • Enabling Symmetric Replication
    • Reconciling Data
    • Trouble shooting Symmetric Replication
    14 Using Replication Example of an Oracle Clinical Distributed Study
    • Operating from the Study-Owning Location
    • Changing Ownership and Replicating Patient Positions
    • Maintaining Investigators and Sites
    • Constraints at the Study-Owning Location
    • Replicating Data at a Study-Owning Location
    • Operating from a Sharing Location
    • Study Design at a Sharing Location
    • Study Definition at a Sharing Location
    • Study Conduct at a Study-Sharing Location
    • Data Replication at a Study-Sharing Location
    • Replication of Labs and Lab Ranges at a Sharing Location
    • Error if Flexible Study Setting Mismatch Between Locations
    • Enabling a Study for Replication
    • Using Standard Replication
    • Review of Setting Up Standard Replication
    • Replicating a Global Library
    • Replicating Study Designs
    • Replicating a Study Definition
    • Replicating Data
    • Replicating Lab Information
    • Replication and Frequency
    • Using Disconnected Replication
    • Overview of Disconnected Replication
    • Review of Setting Up Disconnected Replication
    • Extracting Source Data to an Export File
    • Defining the Extract Data Parameters
    • Loading Data from the Export File into a Target Location
    • Changing Study Ownership
    • Replicated Tables
    III Appendixes A Environment Variables and Registry Settings Summary of the Oracle Clinical Setup
    • Editing opa_ settingsbat
    • Setting Up UNIX Environments
    • Changing Configuration Settings on UNIX Database Servers
    • Changing Environment Variables on Windows
    • xii Settings that Affect Back-End Job Execution
    • Windows Registry Settings
    • OPA Front End
    • Online Help
    • Oracle Clinical Front End
    • RDC Front End
    • RDC Plugin
    • OCN Front End
    • Reports Server
    • Registry Keys
    • Variables
    • B SAS_VIEW Directory Tree C Trouble shooting Managing High Sequence Numbers
    • Assessing Sequence Sizes
    • Reseeding Sequences
    • Error Messages
    • Message: Not Using Named Package
    • Message: OR
    • Message: OR
    • 020
    • Message: Unable to Change Mode
    • System Malfunction: GPF Occurs During Data Entry
    • Situation: $ulimit unlimited
    • PSUB Jobs
    • Check the Failure Text in the Submitted Batch Jobs Window
    • Check the PSUB Log Files
    • If Batch Jobs Hang and the Batch Queue Is Full
    • Determining if PSUB Is Running for a Database
    • 0 Trouble shooting PSUB Based on the Batch Job's Execution Status
    • Handling PSUB Failures that Return "Fatal two-task communication protocol" Error
    • Handling PSUB Failure that Returns "Illegal use of PSLAUNCH…" Error
    • Tracking Previous PSUB Process Connections
    • If PSUB Fails to Start
    • Database Trace
    • D Routine Server Administration Recreating Symbolic Links—UNIX Only
    • Relinking Server Code—UNIX Only
    • Relocating Oracle Clinical
    • Updating Oracle Clinical Seed Data
    • Collecting Statistics for Optimization

All rights reserved ©1999 - 2019, ISQL Global

Terms of Service | Privacy Policy