Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Documentation Updates
• Conventions

What's New in Oracle Identity Manager Connector for Oracle E-Business Employee Reconciliation?

• Software Updates
• Documentation-Specific Updates

1 About the Connector

• 1.1 Certified Components
• 1.2 Certified Languages
• 1.3 Connector Architecture
• 1.4 Features of the Connector
  • 1.4.1 Dedicated Support for Trusted Source Reconciliation
  • 1.4.2 Predefined Reconciliation Queries
  • 1.4.3 Custom Reconciliation Queries
  • 1.4.4 Reconciliation of Effective-Dated Events
  • 1.4.5 Support for Multiple Person Types
  • 1.4.6 Full and Incremental Reconciliation
  • 1.4.7 Limited (Filtered) Reconciliation
  • 1.4.8 Batched Reconciliation
  • 1.4.9 Connection Pooling
  • 1.4.10 Support for SSL Communication Between the Target System and Oracle Identity Manager
• 1.5 Connector Objects Used During Reconciliation
  • 1.5.1 Reconciliation Queries
    • 1.5.1.1 Reconciliation of New and Modified Person Records
    • 1.5.1.2 Reconciliation of Persons Whose Department Has Changed
    • 1.5.1.3 Reconciliation of Future Hires
    • 1.5.1.4 Reconciliation of Terminated Persons
    • 1.5.1.5 Reconciliation of Deleted Person Records
    • 1.5.1.6 Reconciliation of All Person Records
  • 1.5.2 Target System Fields Used in Reconciliation
  • 1.5.3 Reconciliation Rules for Trusted Source Reconciliation
  • 1.5.4 Lookup Definitions Used During Reconciliation
    • 1.5.4.1 Lookup.EBS.HRMS.Recon Lookup Definition
    • 1.5.4.2 Lookup.EBS.HRMS.PersonTypes Lookup Definition
    • 1.5.4.3 Lookup.EBS.HRMS.DeleteRecon Lookup Definition
    • 1.5.4.4 Lookup.EBS.HRMS.QueryFilters Lookup Definition
    • 1.5.4.5 Lookup.EBS.ER.Configurations Lookup Definition
• 1.6 Roadmap for Deploying and Using the Connector

2 Deploying the Connector

• 2.1 Preinstallation
  • 2.1.1 Preinstallation on Oracle Identity Manager
    • 2.1.1.1 Files and Directories On the Installation Media
    • 2.1.1.2 Determining the Release Number of the Connector
    • 2.1.1.3 Creating a Backup of the Existing Common.jar File
  • 2.1.2 Preinstallation on the Target System
    • 2.1.2.1 Creating a Target System User Account for Connector Operations
• 2.2 Installation
  • 2.2.1 Running the Connector Installer
  • 2.2.2 Copying Files to the Oracle Identity Manager Host Computer
• 2.3 Postinstallation
  • 2.3.1 Clearing Content Related to Connector Resource Bundles from the Server Cache
  • 2.3.2 Enabling Logging
    • 2.3.2.1 Enabling Logging on Oracle Identity Manager Release 9.1.0.x
    • 2.3.2.2 Enabling Logging on Oracle Identity Manager Release 11.1.x
  • 2.3.3 Setting Up Connection Pooling
  • 2.3.4 Configuring Secure Communication Between the Target System and Oracle Identity Manager
    • 2.3.4.1 Configuring Data Encryption and Integrity in Oracle Database
    • 2.3.4.2 Configuring SSL Communication in Oracle Database
  • 2.3.5 Determining Values for the JDBC URL and Connection Properties Parameters
    • 2.3.5.1 Supported JDBC URL Formats
    • 2.3.5.2 Only Data Encryption and Integrity Is Configured
    • 2.3.5.3 Only SSL Communication Is Configured
    • 2.3.5.4 Both Data Encryption and Integrity and SSL Communication Are Configured
  • 2.3.6 Configuring the IT Resource
  • 2.3.7 Displaying UDFs in Oracle Identity Manager 11.1.2 or Later

3 Using the Connector

• 3.1 Performing First-Time (Full) Reconciliation
• 3.2 Configuring Reconciliation
  • 3.2.1 Batched Reconciliation
  • 3.2.2 Reconciliation Query
  • 3.2.3 Reconciliation Time Stamp
  • 3.2.4 Setting the Business Group ID and Date Range for Reconciliation
  • 3.2.5 Setting the Format for Values Fetched From Date-Type Target System Columns
  • 3.2.6 Configuring Limited Reconciliation
  • 3.2.7 Configuring the Reconciliation Scheduled Tasks
    • 3.2.7.1 Attributes of the Scheduled Tasks
• 3.3 Uninstalling the Connector

4 Extending the Functionality of the Connector

• 4.1 Adding New Attributes for Reconciliation
• 4.2 Modifying the Names of Predefined Attributes Mapped for Reconciliation
• 4.3 Deleting Predefined Attributes Mapped for Reconciliation
• 4.4 Modifying Field Lengths on the OIM User Form
• 4.5 Configuring Reconciliation Queries
• 4.6 Configuring Validation of Data During Reconciliation
• 4.7 Configuring Transformation of Data During Reconciliation
• 4.8 Configuring the Connector for Multiple Installations of the Target System
• 4.9 Configuring the Connector for Multiple Trusted Source Reconciliation

5 Troubleshooting

6 Known Issues

Index