Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Oracle Application Integration Architecture Guides
• Related Documents
• Conventions

Part I Understanding the Delivered Integrations

1 About Study Subject and Visit Synch: Siebel Clinical – Oracle Clinical PIP

• 1.1 Key Benefits of the PIP
  • 1.1.1 General Business Process
• 1.2 Common Terms Used in this Guide
• 1.3 Business Process Flows
  • 1.3.1 Create or Update Study Sites
  • 1.3.2 Create or Update Study Subjects
  • 1.3.3 Update Visit or Activity Completion Date and Status
• 1.4 Solution Assumptions and Constraints
  • 1.4.1 Assumptions
  • 1.4.2 Constraints

2 Synchronizing Clinical Study Sites

• 2.1 Overview
• 2.2 Study Site Integration Flow
  • 2.2.1 Create Study Site Flow
  • 2.2.2 Update Study Site Flow
• 2.3 Siebel Clinical Interfaces
• 2.4 Oracle Clinical Interfaces
• 2.5 Industry AIA Components
• 2.6 Integration Services

3 Synchronizing Clinical Study Subject Information

• 3.1 Overview
• 3.2 Clinical Study Subject Information Flow
  • 3.2.1 Flow Diagram
  • 3.2.2 Create Study Subject
  • 3.2.3 Update Study Subject
• 3.3 Siebel Clinical Interfaces
• 3.4 Oracle Clinical Interfaces
• 3.5 Industry AIA Components
• 3.6 Integration Services

4 Automating the Update of Activity Completion Date and Status Based on Data Entered in Oracle Clinical or Oracle Clinical Remote Data Capture

• 4.1 Overview
• 4.2 Clinical Study Subject Activity Flow
  • 4.2.1 Flow Diagram
  • 4.2.2 Update Subject Visit or Activity Completion
• 4.3 Siebel Clinical Interfaces
• 4.4 Oracle Clinical Interfaces
• 4.5 Industry AIA Components
• 4.6 Integration Services

Part II Implementing the Delivered Integrations

5 Implementing the PIP

• 5.1 Prerequisites
  • 5.1.1 Prerequisites for Synchronizing Clinical Study Sites
    • 5.1.1.1 Downloading the Lists of States and Countries in Oracle Clinical
    • 5.1.1.2 Downloading the Lists of States and Countries in Siebel Clinical
    • 5.1.1.3 Increasing the Action Interval in Siebel
  • 5.1.2 Prerequisites for Synchronizing Clinical Study Subject
  • 5.1.3 Prerequisites for Automating the Update of Activity Completion Date and Status Based on Data Entered in Oracle Clinical or Oracle Clinical Remote Data Capture
• 5.2 Data Requirements
  • 5.2.1 Data Requirements for Synchronizing Clinical Study Sites
  • 5.2.2 Data Requirements for Synchronizing Clinical Study Subject Information
  • 5.2.3 Data Requirements for Automating the Update of Activity Completion Date and Status Based on Data Entered in Oracle Clinical or Oracle Clinical Remote Data Capture
• 5.3 Setting Up the Participating Applications
  • 5.3.1 Setting up Siebel Clinical
    • 5.3.1.1 Synchronizing Clinical Study Sites
    • 5.3.1.2 Synchronizing Clinical Study Subject Information
    • 5.3.1.3 Automating the Update of Activity Completion Criteria
  • 5.3.2 Setting up Oracle Clinical
    • 5.3.2.1 Synchronizing Clinical Study Sites
    • 5.3.2.2 Enabling the Integration
    • 5.3.2.3 Synchronizing Clinical Study Subject Information
    • 5.3.2.4 Automating the Update of Activity Completion Criteria
• 5.4 Identifying Cross-References
• 5.5 Working with Domain Value Maps
• 5.6 Configuring Email Notification
• 5.7 Extending the PIP
  • 5.7.1 Enabling Calling Out To Your Own Web Services
  • 5.7.2 Adding Custom Transformations
    • 5.7.2.1 Overview
    • 5.7.2.2 Customizing Enterprise Business Object Fields for Study Site Flow from Siebel Clinical to Oracle Clinical
    • 5.7.2.3 Customizing Enterprise Business Object Fields for Subject Activity Flow From Oracle Clinical to Siebel Clinical
• 5.8 Configuration Properties
• 5.9 Updating Server Information for Siebel Clinical and Oracle Clinical
  • 5.9.1 Changing Passwords Specified During Install
  • 5.9.2 Updating Server or Password Information for Oracle Clinical
• 5.10 Error Handling

6 Configuring Multiple Oracle Clinical Database Instances

• 6.1 Overview
• 6.2 Configuring Additional Oracle Clinical Instances

7 Using the Resubmission Utility

• 7.1 Overview
• 7.2 Executing the Resubmission Utility for Study Site Flow
• 7.3 Executing the Resubmission Utility for Subject Activity Flow

Index