Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

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

• Software Updates
  • Software Updates in Release 11.1.1.5.0
• Documentation-Specific Updates
  • Documentation-Specific Updates in Release 11.1.1.5.0

About the Oracle E-Business Suite HRMS Connector

• Introduction to the Connectors
  • HRMS Trusted Connector
  • HRMS Target Connector
• Certified Components
• Usage Recommendation
• Certified Languages
• Connector Architecture
• Features of the EBS HRMS Connector
  • Configurable Reconciliation Queries and Stored Procedures
  • Full and Incremental Reconciliation
  • Batched Reconciliation
  • Limited (Filtered) Reconciliation
  • Connection Pooling
  • Support for SSL Communication Between the Target System and Oracle Identity Manager

Deploying the EBS HRMS Connector

• Preinstallation
  • Privileges Granted to the User Account
• Installation
  • Understanding the Installation
  • Running the Connector Installer
  • Configuring the IT Resource for the Target System
• Postinstallation
  • Configuring Secure Communication Between the Target System and Oracle Identity Manager
    • Configuring Data Encryption and Integrity in Oracle Database
    • Configuring SSL Communication in Oracle Database
  • Configuring Oracle Identity Manager
    • Creating and Activating a Sandbox
    • Creating a New UI Form
    • Associating the Form with the Application Instance
    • Publishing a Sandbox
    • Syncing the Catalog
    • Updating an Existing Application Instance with a New Form
  • Setting Up the Lookup Definition for Connection Pooling
  • Clearing Content Related to Connector Resource Bundles from the Server Cache
  • Managing Logging
    • Understanding Log Levels
    • Enabling logging
  • Determining Values for the JDBC URL and Connection Properties Parameters
    • Supported JDBC URL Formats
    • Only SSL Communication Is Configured
    • Both Data Encryption and Integrity and SSL Communication Are Configured
  • Localizing Field Labels in UI Forms
  • Removing the Default Validation Check for Provisioning Operations
• Upgrading the Connector
  • Preupgrade Steps
  • Upgrade Steps
  • Postupgrade Steps
• Postcloning Steps

Using the HRMS Target Connector

• Lookup Definitions Used During HRMS Target Connector Operations
  • Lookup Definitions Synchronized with the Target System for the HRMS Target Connector
  • Preconfigured Lookup Definitions for the HRMS Target Connector
    • Lookup.EBSHRMS.Configuration
    • Lookup.EBSHRMS.UM.Configuration
    • Lookup.EBSHRMS.UM.ProvAttrMap
    • Lookup.EBSHRMS.UM.ReconAttrMap
    • Lookup.EBSHRMS.Gender
    • Lookup.EBSHRMS.MaritalStatus
    • Lookup.EBSHRMS.PRIMARYFLAG
    • Lookup.EBSHRMS.Titles
• Reconciliation Scheduled Jobs for the HRMS Target Connector
  • Scheduled Job for Lookup Field Synchronization
  • Scheduled Job for Reconciliation of Deleted Person Records
  • Scheduled Job for Reconciliation of Person Records
  • Scheduled Job for Incremental Reconciliation
  • Scheduled Jobs for the HRMS Target Connector
• Configuring Reconciliation for the HRMS Target Connector
  • Reconciliation Queries for the EBS HRMS Connector
  • Reconciliation Rules for the HRMS Target Connector
    • Target Resource Reconciliation Rule for the HRMS Target Reconciliation
    • Viewing Reconciliation Rules for Target Resource Reconciliation
  • Reconciliation Action Rules for the HRMS Target Connector
    • Reconciliation Action Rules for Target Resource Reconciliation
    • Viewing Reconciliation Action Rules for Target Resource Reconciliation in the Design Console
  • Performing Full Reconciliation and Incremental Reconciliation Using the HRMS Target Connector
  • Performing Limited Reconciliation Using the HRMS Target Connector
  • Performing Batched Reconciliation Using the HRMS Target Connector
• Configuring Provisioning for the HRMS Target Connector
  • Provisioning Procedures
  • Provisioning Functions
  • Configuring the Connector for the Employee Number Field that is Not Autogenerated
  • Performing Provisioning Operations in Oracle Identity Manager
• Uninstalling the HRMS Target Connector

Using the HRMS Trusted Connector

• Preconfigured Lookup Definitions for the HRMS Trusted Connector
  • Lookup.EBSHRMS.Configuration.Trusted
  • Lookup.EBSHRMS.Person.Configuration.Trusted
  • Lookup.EBSHRMS.ReconAttrMap.Trusted.Defaults
  • Lookup.EBSHRMS.ReconAttrMap.Trusted
• Reconciliation Scheduled Jobs for the HRMS Trusted Connector
  • Scheduled Job for Reconciliation of Person Records
  • Scheduled Job for Reconciliation of Deleted Person Records
  • Scheduled Job for Incremental Reconciliation
  • Configuring Scheduled Jobs for the HRMS Trusted Connector
• Configuring Reconciliation for the HRMS Trusted Connector
  • Reconciliation Queries for the HRMS Trusted Connector
  • Reconciliation Rules for the HRMS Trusted Connector
    • Reconciliation Rule for Trusted Source Reconciliation for the HRMS Trusted Connector
    • Viewing Reconciliation Rules for Trusted Source Reconciliation
  • Reconciliation Action Rules for the HRMS Trusted Connector
    • Reconciliation Action Rules for Trusted Source Reconciliation
    • Viewing Reconciliation Action Rules for Trusted Source Reconciliation in the Design Console
  • Performing Full Reconciliation and Incremental Reconciliation Using the HRMS Trusted Connector
  • Performing Limited Reconciliation Using the HRMS Trusted Connector
  • Performing Batched Reconciliation Using the HRMS Trusted Connector
• Uninstalling the HRMS Trusted Connector

Extending the Functionality of the Connector

• Understanding Connector Schema Extension
• Adding New Attributes for Trusted Source Reconciliation
  • Summary of Steps to Add New Attributes for Trusted Source Reconciliation
  • Extending the Connector Schema for Trusted Source Reconciliation
  • Updating Artifacts for Trusted Source Reconciliation
    • Creating a User-Defined Field
    • Updating the Oracle EBS HRMS Trusted User Resource Object
    • Updating the Oracle EBS HRMS Trusted User Process Definition
    • Updating the Lookup Definition for Reconciliation Attribute Mapping
    • Creating a Reconciliation Profile for the Oracle EBS HRMS Trusted User Resource Object
  • Updating the Connector Bundle
• Adding New Attributes for Target Resource Reconciliation and Provisioning
  • Summary of Steps to Add New Attributes for Target Resource Reconciliation and Provisioning
  • Extending the Connector Schema for Target Resource Reconciliation and Provisioning
  • Updating Connector Artifacts
    • Creating a Process Form Field
    • Updating the Oracle EBS HRMS User Resource Object
    • Updating the Oracle EBS HRMS Target Process Definition
    • Updating the Lookup Definition for Reconciliation Attribute Mapping
    • Updating the Lookup Definition for Provisioning Attribute Mapping
    • Creating a Reconciliation Profile for the Oracle EBS HRMS Target Resource Object
    • Enabling Provisioning Operations on the New Attribute
  • Updating the search.properties File
  • Updating the Procedures.properties File
• Adding New Multivalued Attributes for Target Resource Reconciliation and Provisioning
• Configuring Transformation of Data During User Reconciliation
• Configuring Validation of Data During Reconciliation and Provisioning

Sample SQL Queries for the HRMS Target Connector

Sample SQL Queries for the HRMS Trusted Connector

Files and Directories in the EBS HRMS Connector Installation Package