ISQLGlobal Global Logo
Contact UsCertificationPlacementsCoursesCorporateHome

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 - 2022, ISQL Global.

Terms of Service | Privacy Policy