2 Creating an Application By Using the Oracle E-Business Suite HRMS Connectors

Learn about onboarding applications using the connector and the prerequisites for doing so.

• Process Flow for Creating an Application By Using the Connector

• Prerequisites for Creating an Application By Using Connector

• Creating an Application By Using the Connector

2.1 Process Flow for Creating an Application By Using the Connector

From Oracle Identity Governance release 12.2.1.3.0 onward, connector deployment is handled using the application onboarding capability of Identity Self Service.

Figure 2-1 is a flowchart depicting high-level steps for creating an application in Oracle Identity Governance by using the connector installation package.

Figure 2-1 Overall Flow of the Process for Creating an Application By Using the Connector

Description of "Figure 2-1 Overall Flow of the Process for Creating an Application By Using the Connector"

2.2 Prerequisites for Creating an Application By Using Connector

Learn about the tasks that you must complete before you create the application.

• Downloading the Connector Installation Package

• Creating a Target System User Account for Connector Operations

2.2.1 Downloading the Connector Installation Package

You can obtain the installation package for your connector on the Oracle Technology Network (OTN) website.

To download the connector installation package:

1. Navigate to the OTN website at http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/connectors-101674.html.
2. Click OTN License Agreement and read the license agreement.
3. Select the Accept License Agreement option.
   You must accept the license agreement before you can download the installation package.
4. Download and save the installation package to any directory on the computer hosting Oracle Identity Governance.
5. Extract the contents of the installation package to any directory on the computer hosting Oracle Identity Governance. This creates a directory named CONNECTOR_NAME-RELEASE_NUMBER.
6. Copy the CONNECTOR_NAME-RELEASE_NUMBER directory to the OIG_HOME/server/ConnectorDefaultDirectory directory.

2.2.2 Creating a Target System User Account for Connector Operations

Oracle Identity Governance requires a target system user account to access the target system during reconciliation and provisioning operations. Depending on the target system you are using, you can create the user in your target system and assign specific permissions and roles to the user.

You provide the credentials of this user account as part of Basic Configuration Parameters for the EBS HRMS Connector or Basic Configuration Parameters for the EBS ER Connector while creating an application.

Note:

Target system documentation for detailed information about creating the user

To create a target system user account for connector operations:

1. From the installation media, copy the scripts directory to a temporary directory on either the target system host computer or a computer on which the Oracle Database Client has been installed. If you are installing in the same host computer where the connector directory is present, then skip this step and proceed to the next.
2. On the computer where you copy the scripts directory, verify that there is a TNS entry in the tnsnames.ora file for the target system database.
3. Change to the directory containing the scripts directory and depending on the host platform, run either the Run_HRMS_DBScripts.sh or Run_HRMS_DBScripts.bat file. These files are present in the scripts directory of the installation media.
4. When you run the script, you are prompted for the following information:

   • Enter the ORACLE_HOME

     Set a value for the ORACLE_HOME environment variable. This prompt is displayed only if the ORACLE_HOME environment variable has not been set on the computer on which you are running the script.

   • Enter the System User Name

     Enter the login (user name) of a DBA account with the privileges to create and configure a new target system user.

   • Enter the name of the database

     Enter the connection string or service name given in the tnsnames.ora file to connect to the target system database.

   • Would you like to create new user for connector operations [y/n]

     Enter y or n to specify whether you want to create a new user for connector operations.

     This connects you the SQL*Plus client.

   • Are you running this script with EBS target 12.1.x [y/n]

     Enter y if you are using Oracle E-Business Suite release 12.1.1 through 12.1.3. When you do so, version compatible scripts will run on your target system.

     Enter n if you are using Oracle E-Business Suite 12.2.x and later versions.

   • Enter password

     Enter the password for the Oracle database login. If you entered n at the earlier prompt to create a new user for connector operations, then the Type and Package are created, and then the connection to the database is disconnected. If you entered y, then the Type and Package are created, and then the connection to the database remains.

   • Enter password

     Enter the password of the dba user.

   • Enter New database Username to be created

     Enter a user name for the target system account that you want to create.

   • Enter the New user password

     Enter a password for the target system account that you want to create.

     This installs all wrappers packages under the APPS schema, creates the new target system account, and then grants all the required privileges on the tables and packages.

   • Connecting with newly created database user

     Enter the connection string or service name that you provided earlier.

     The user account for connector operations is created. The privileges granted to this user account are listed in Privileges Granted to the User Account.

   • Enter the hostname for network acl [Input will be ignored If DB version is earlier than 11g]

     Enter the name of the computer hosting network acl in the following format:

     *.DOMAIN_NAME.com

     This prompt is received only if you entered y at one of the earlier prompts to create a new user for connector operations.

2.3 Creating an Application By Using the Connector

You can onboard an application into Oracle Identity Governance from the connector package by creating a target application. To do so, you must log in to Identity Self Service and then choose the Applications box on the Manage tab.

The following is the high-level procedure to create an application by using the connector:

Note:

For detailed information on each of the steps in this procedure, see Creating Applications of Oracle Fusion Middleware Performing Self Service Tasks with Oracle Identity Governance.

1. Create an application in Identity Self Service. The high-level steps are as follows:
   1. Log in to Identity Self Service either by using the System Administration account or an account with the ApplicationInstanceAdministrator admin role.
   2. Ensure that the Connector Package option is selected when creating an application.
   3. Update the basic configuration parameters to include connectivity-related information.
   4. If required, update the advanced setting parameters to update configuration entries related to connector operations.
   5. Review the default user account attribute mappings. If required, add new attributes or you can edit or delete existing attributes.
   6. Review the provisioning, reconciliation, organization, and catalog settings for your application and customize them if required. For example, you can customize the default correlation rules for your application if required.
   7. Review the details of the application and click Finish to submit the application details.
      The application is created in Oracle Identity Governance.
   8. When you are prompted whether you want to create a default request form, click Yes or No.
      If you click Yes, then the default form is automatically created and is attached with the newly created application. The default form is created with the same name as the application. The default form cannot be modified later. Therefore, if you want to customize it, click No to manually create a new form and attach it with your application.
2. Verify reconciliation and provisioning operations on the newly created application.

See Also:

• Configuring the Oracle EBS HRMS Connector for a Target Application and Configuring the Oracle EBS Employee Reconciliation Connector for an Authoritative Application for details on basic configuration and advanced settings parameters, default user account attribute mappings, default correlation rules, and reconciliation jobs that are predefined for this connector

• Configuring Oracle Identity Governance for details on creating a new form and associating it with your application, if you chose not to create the default form.