Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• Related Documents
• Conventions

1 Setting Up Services

• About Services
• About the Distributed Processing Server
• Setting Up the Distributed Processing Server
• Defining Service Locations
• Defining Services
  • Service Types
    • Service Types that Do Not Use the DP Server
    • Service Types that Use the DP Server
  • Service Prioritization
  • Service Instances

2 Setting Up Adapters to External Systems

• About Adapters
• Adapter Structure
• Creating Your Own Adapters
• Setting Up Security for Adapters
  • Assigning User Groups to Adapter Domains and Adapter Areas
    • Assigning User Groups
    • Viewing and Modifying User Group Assignments
  • Creating Roles with the Required Operations for Adapters
• Clearing Oracle Applications Cache

3 Setting Profile Values

• How to Log In to Oracle Applications Profile Forms
• Setting Native Client Encoding
• Using Character Semantics for Work Area Table Installation
• Gathering Work Area Schema Statistics
• Creating a New Tablespace for Work Area Schema Objects
• Setting the Default Value for: Force Output Validation Status to Development
• Setting the Maximum Number of Nested Domains
• Adding the Direct SQL Option to SAS Libraries
• Allowing User Preferences for SAS Clients
• Setting Password Requirements
  • Setting Password Case Sensitivity (Required for Business Intelligence Publisher)
  • Setting Password Length Requirement
  • Setting "Hard to Guess" Requirement
  • Enabling "Forgot Your Password?" Functionality
  • Setting a Limit on Log-In Attempts
  • Setting a Time Limit on Password Reuse after Resetting Password
• Oracle LSH: BIP Endpoint
• Attachment File Upload Restriction Default

4 Adding and Modifying Lookup Values

• About Lookups
• Modifiable Lookups
  • File Types
  • Font Name
  • OTD Default Papersize
  • Report Type
  • SAS IDE Client
  • Service Type
  • Summary Output Validation Status
  • System Validation Steps
  • Tablespace Names
  • Technology Types
• Logging In
• Querying and Viewing Lookups
• Adding, Modifying, or Discontinuing a Lookup Value

5 Registering Locations and Connections

• About Remote Locations and Connections
• Defining Remote Locations
• Defining Connections
• Searching for Remote Locations and Connections

6 Enabling Internal Metadata Table Auditing

• About Internal Table Auditing
• Audited Tables

7 Setting Up Printers

• Setting Up Printers Globally
• Setting Default Printers

8 Setting Up the Classification System

• About Classification
• Creating and Maintaining Hierarchies
  • Creating Hierarchies
  • Adding Levels to Hierarchies
    • Reorder Hierarchy Levels
    • Remove Hierarchy Levels
  • Activating the Hierarchy and Making it Usable or Unusable
  • Adding Terms to Levels
  • Modifying Hierarchies and Terms
• Assigning Levels to Object Subtypes

9 Setting Up the Security System

• About Security in the Oracle Life Sciences Data Hub
• About Security in Oracle Health Sciences Data Management Workbench
• Setting Up User Accounts
  • About Users
  • Creating User Accounts
  • Maintaining User Accounts
  • Assigning Application Roles
    • Oracle Life Sciences Data Hub Application Roles
    • Oracle Health Sciences Data Management Workbench Application Roles
• Setting Up Specialized Administrators
• Setting Up Object Security
  • Creating and Maintaining Object Subtypes
    • Creating Object Subtypes
    • Modifying Object Subtypes
  • Creating and Maintaining Object Security Roles
    • Creating Object Security Roles
    • Modifying Object Security Roles
  • Assigning Subtype Operations to Roles and Modifying Assignments
    • Assigning Roles to Operations
    • Modifying Operation Assignments to Roles
    • Notes on Particular Object Types
  • Creating and Maintaining User Groups
    • Creating User Groups
    • Adding Supported Roles to User Groups
    • Assigning a Group Administrator to the User Group
    • Duplicating User Groups
    • Modifying User Groups
• Granting Security Access to APIs

10 Creating Database Accounts

• About Database Accounts
  • Database Accounts for Use in Definition
  • Database Accounts for Message-Based Submissions
• Creating Database Accounts
• Managing Database Account Privileges for Generic Visualization Business Areas
• Setting Up TMS Security for Users
• Resetting the Password
• Removing a Database Account

11 Setting Up Oracle Business Intelligence Visualizations

• Setting Up a Single-Computer Configuration
• Setting Up a Multiple-Computer Configuration
  • Service Locations and Services Required in a Multiple Computer Installation
  • Single and Multiple Repository Files
• Set Up Database Connectivity
• Assign Repository Filename(s) to each Oracle BI Presentation Server Instance (10g Only)
  • Add an Entry to the NQSConfig File for Each Repository File
  • Set up the Analytics Web DSN to Use the Repository File
• Copy and Edit Revised Execution Command Scripts
• Set the Default Authenticator to Optional (11g Only)
• Starting the WebLogic Server (11g Only)
• Set Up Oracle Business Intelligence Administration Tool
• Security Configuration
  • Data Security
  • Creating an OBIEE Remote Location and Connection for RPD Password Security
    • Create an OBIEE Remote Location
    • Create an OBIEE Remote Location Connection
  • Using Separate URLs to Control Access

12 Setting Up Security for Oracle Business Intelligence Publisher

• Overview
• Creating and Assigning Oracle Applications Responsibilities
  • Creating User-Specific Responsibilities in E-Business Suite
  • Assigning Application Roles in Oracle LSH
• Configuring Security in Oracle BI Publisher
  • Setting Up the Security Model and Creating the Local Superuser Account in Oracle BI Publisher
  • Creating Data Sources and Assigning them User-specific Roles
  • Creating the SYSTEM Folder
• Storing the BI Publisher Local Superuser Credentials in Oracle Life Sciences Data Hub
  • Creating the Oracle BI Publisher Remote Location in Oracle LSH
  • Creating the Oracle BI Publisher Remote Connection in Oracle LSH
  • The LSH: BIP Endpoint Profile

13 Setting Up Security for Informatica

• Setting Up User Accounts
  • Informatica Administrator Account
  • Accounts for Each Oracle LSH Definer
• Creating an Informatica Remote Location and Connection
  • Creating the Informatica Remote Location in Oracle LSH
  • Creating the Informatica Remote Connection in Oracle LSH

14 Customizing Object Validation Requirements

• About Customizing Object Validation
• Modifying the Custom Validation Package

15 Synchronizing an Apps Password Change

16 Monitoring Jobs

• About Execution in the Oracle Life Sciences Data Hub
• Querying for Jobs
• Job Information
  • General Job Information
  • Job Execution Details
    • Submission Properties
    • Outputs
    • Subjobs
    • Submission Parameters
    • System Parameters
    • Source Data Currency
    • Log File
• Job Statuses
• Execution Statuses

17 Exporting and Importing Objects

• About Exporting and Importing Objects
• Objects Included and Excluded
  • Objects Included
  • Objects Excluded
• Source Independence
• Exporting Objects
  • Full and Partial Export
    • Populating the Driver Table
  • Roles and Privileges Required for Exporting
  • Creating the Directory and Running the Export Script
  • Export Log File Content
• Importing Objects
  • Upgrading an Existing Domain
  • Roles and Privileges Required for Importing Domains
  • Creating the Directory and Running the Import Script
  • Import Log File Content
  • Applying Security to an Imported Domain
• Installing Objects
  • Running the Installation Script
• Preserving Customizations

18 Stopping and Starting Services and Queues

• Starting, Stopping, and Checking the Distributed Processing Service
  • Starting the Distributed Processing Server Service
  • Checking the Distributed Processing Server Service
  • Stopping the Distributed Processing Server Service
• Stopping and Starting the Oracle Warehouse Builder Service
  • Stopping the OWB Service
  • Starting the OWB Service
• Stopping, Starting, and Enabling the Job Queue
  • Starting the Job Queue
  • Stopping the Job Queue
  • Enabling the Job Queue
• Starting and Stopping Message-Triggered Submission Queues
  • Starting a Message-Triggered Submission Queue
  • Stopping a Message-Triggered Submission Queue

19 Troubleshooting

• Job Execution Problems
  • Job Remains at Submitted or Executing
  • Oracle Warehouse Builder Processes Do Not Start
  • Job Runs But Does Not Upload Outputs
  • Job Log File Does Not Contain Info after a Long or Failed Execution
  • Job Fails to Obtain Service
  • Report Set Jobs Do Not Produce Any Output when using SAS 9.2
• Database Core Dumps during Object Creation
• Query Exceeds 200 Rows
• Table Auditing (Journaling) Not Working
• Enabling a Trace on a Job

A Object Ownership

• Domains
• Application Areas
• Work Areas

Glossary

Index