Skip Headers
Oracle® Identity Manager Connector Guide for Oracle eBusiness Employee Reconciliation
Release 9.0.1

Part Number B31126-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Deploying the Connector

Deploying the connector involves the following steps:

Step 1: Verifying Deployment Requirements

The following table lists the deployment requirements for the connector.

Item Requirement
Oracle Identity Manager Oracle Identity Manager release 8.5.3 or later
Target systems Oracle Apps HRMS 11.5.10
Target systems hosts Oracle9i Database 9.2.x
External code JDBC class library (classes12.jar)

Step 2: Configuring the Target System

For this connector, you do not need to perform any configuration steps on the target system.

Step 3: Copying the Connector Files and External Code

The connector files to be copied and the directories to which you must copy them are given in the following table.

Note:

The directory paths given in the first column of this table correspond to the location of the connector files in the following ZIP file on the installation media:
Enterprise Applications\Oracle e-Business\Oracle e-Business Employee Reconciliation Rev 2.1.1.zip

Refer to "Files and Directories That Comprise the Connector" for more information about these files.

Files in the Installation Media Directory Destination Directory
xml\oracleHRResAdp.xml
xellerate_home\xlclient\
lib\ScheduleTask\xlReconOraHREmp.jar
xellerate_home\xellerate\ScheduleTask
docs\B31126_01.pdf
docs\html
xellerate_home\xellerate\docs

Copy the JDBC class library (classes12.jar) from the oracle_home\ora92\jdbc\lib\classes12.jar directory to the xellerate_home\xellerate\ThirdParty directory. Where oracle_home is the directory in which Oracle9i Database is installed. For example, C:\Oracle.

Step 4: Importing the Connector XML File

To import the connector XML file:

  1. Open the Oracle Identity Manager Administrative and User Console.

  2. Click the Deployment Management link on the left navigation bar.

  3. Click the Import link under Deployment Management. A dialog box for locating files is displayed.

  4. Locate and open the OracleHRResAdp.xml file, which is in the xellerate_home\xlclient\ directory. Details of this XML file are shown on the File Preview page.

  5. Click Add File. The Substitution page is displayed.

  6. Click Next. The Confirmation page is displayed.

  7. Click Next. The Provide IT Resource Instance Data page for the Oracle HR IT resource is displayed.

  8. Specify values for the parameters of the Oracle HR IT resource. Use the table given in the "Defining IT Resources" section for information about the values to be specified.

  9. Click Next. The Provide IT Resource Instance Data page for a new instance of the Oracle HR IT resource type is displayed.

  10. Click Skip to specify that you do not want to define another IT resource. The Confirmation page is displayed.

    See Also:

    If you want to define another IT resource, then refer to Oracle Identity Manager Tools Reference Guide for instructions.
  11. Click View Selections.

    The contents of the XML file are displayed on the Import page. You may see a cross-shaped icon along with some nodes. You must remove these nodes. To do this, right-click each such node and then select Remove.

  12. Click Import. The connector file is imported into Oracle Identity Manager.

After you import the connector XML file, proceed to the "Step 5: Configuring Reconciliation" section.

Defining IT Resources

You must specify values for the following Oracle HR IT resource parameter:

Parameter Name Parameter Description
Admin User ID to connect to the Oracle eBusiness Employee Reconciliation database

The default value is Apps.

AdminCredentials Password of the administrator
Host Host name or IP address of the Oracle eBusiness Employee Reconciliation database
IsDebug Debug feature

The value can be YES or NO. The default value is NO.

OracleHREmp.Organization Name Default value for the Oracle Identity Manager Organization name

This value is used to create the Xellerate User in trusted mode. The default value is Xellerate Users.

Port TCP/IP port at which the Oracle eBusiness Employee Reconciliation server is listening

The default value is 1521.

SID SID for the Oracle eBusiness Employee Reconciliation database
TimeStamp Timestamp for the last reconciliation

After you specify values for the IT resource parameter, go to Step 9 of the procedure to import connector XML files.

Note:

You must use the existing standard APPS User for connecting to the Oracle eBusiness Employee Reconciliation database because only this user has the rights required to update the database.

Step 5: Configuring Reconciliation

Configuring reconciliation involves creating scheduled tasks for lookup fields and employee reconciliations. To create these scheduled tasks:

  1. Open the Oracle Identity Manager Design Console.

  2. Expand the Xellerate Administration folder.

  3. Select Task Scheduler.

  4. Click Find. The details of the predefined scheduled tasks are displayed on two different tabs.

  5. Enter a number in the Max Retries field. This number represents the number of times Oracle Identity Manager should attempt to complete the task before assigning the ERROR status to the task.

  6. Ensure that the Disabled and Stop Execution check boxes are cleared.

  7. In the Start region, double-click the Start Time field. From the date-time editor that is displayed, select the date and time at which you want the task to run.

  8. In the Interval region, set the following schedule parameters:

    • To set the task to run on a recurring basis, select the Daily, Weekly, Recurring Intervals, Monthly, or Yearly option.

      If you select the Recurring Intervals option, then you must also specify the time interval at which you want the task to run on a recurring basis.

    • To set the task to run only once, select the Once option.

  9. Provide values for the attributes of the scheduled task. Refer to the appropriate table in the "Specifying Values for the Scheduled Task Attributes"section for information about the values to be specified.

    See Also:

    Oracle Identity Manager Design Console Guide for information about adding and removing task attributes
  10. Click Save. The scheduled task is created. The INACTIVE status is displayed in the Status field, because the task is not currently running. The task is run at the date and time that you set in Step 7.

  11. Repeat Steps 5 through 10 to create the second scheduled task.

After you create the scheduled tasks, proceed to Chapter 3.

Specifying Values for the Scheduled Task Attributes

This section provides information about the values to be specified for the following scheduled tasks:

Lookup Fields Reconciliation Scheduled Task

You must specify values for the following attributes of the lookup fields reconciliation scheduled task.

Note:

Attribute values are predefined in the connector XML file that you import. Specify values only for those attributes that you want to change.
Attribute Name Description Default/Sample Value
Server Name of the IT resource instance that the connector uses to reconcile data Oracle HR
LookupField Name Name of the lookup field to be reconciled OracleHR.Employees

After you specify values for these task attributes, go to Step 10 of the procedure to create scheduled tasks.

Employee Reconciliation Scheduled Task

You must specify values for the following attributes of the employee reconciliation scheduled task.

Note:

Attribute values are predefined in the connector XML file that you import. Specify values only for those attributes that you want to change.
Attribute Name Description Default/Sample Value
Target System Recon - Resource Object name Name of the resource object Oracle HR Employee
Server IT resource instance that the connector uses to reconcile data Oracle HR
IsTrusted Specifies whether or not reconciliation must be performed in trusted mode YES or NO

After you specify values for these task attributes, go to Step 10 of the procedure to create scheduled tasks.