Integrate with Oracle e-Business Employee Reconciliation (HRMS)
You can establish a connection between Oracle e-Business Employee Reconciliation (HRMS) and Oracle Access Governance by entering connection details and configuring the connector. To achieve this, use the Orchestrated Systems functionality available in the Oracle Access Governance Console.
Preinstall
Before you install and configure a Oracle e-Business Employee Reconciliation (HRMS) orchestrated system, you should consider the following pre-requisites and tasks.
Certified Components
The system can be any one of the following:
- Oracle E-Business Suite 12.1.1 through 12.1.3
- Oracle E-Business Suite 12.2.x
Note:
If your system is running on Oracle Database release 19.x, then download and apply the Oracle Database patch 31142749 from My Oracle Support. Applying this patch ensures that provisioning operations work fine.Supported Operations
- Create person
- Add address
- Update address
- Delete address
- Add assignment
- Update assignment
- Delete assignment
Create a System User Account for Oracle e-Business Employee Reconciliation (HRMS) Orchestrated System Operations
Oracle Access Governance requires a user account to access the system during reconciliation operations. Depending on the system you are using, you can create the user in your system and assign specific permissions and roles to the user.
For Oracle e-Business Employee Reconciliation (HRMS):
- Download all the files present inside this
https://github.com/oracle/docker-images/tree/main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_HRMS/1.0
location and copy them to a temporary directory on either the system host computer or a computer on which the Oracle Database Client has been installed.Alternatively, you can run the following steps to get the scripts:wget https://github.com/oracle/docker-images/archive/refs/heads/main.zip
unzip main.zip
cp docker-images-main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_HRMS/1.0/* TEMP_DIR
Where
TEMP_DIR
is a temporary directory on either the system host computer or a computer on which the Oracle Database Client has been installed.
- On the computer where you copy the scripts directory, verify
that there is a TNS entry in the
tnsnames.ora
file for the system database. - Change to the directory containing the scripts directory and
depending on the host platform, run either the
Run_HRMS_DBScripts.sh
orRun_HRMS_DBScripts.bat
file. These files are present in thishttps://github.com/oracle/docker-images/tree/main/OracleIdentityGovernance/samples/scripts/Oracle_EBS_HRMS/1.0
location. - 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 database user.
-
Enter the name of the database
Enter the connection string or service name given in the
tnsnames.ora
file to connect to the 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 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 database account that you want to create.
-
Enter the New user password
Enter a password for the database account that you want to create.
This installs all wrappers packages under the APPS schema, creates the new database 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.
-
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.
-
Install
You can establish a connection between Oracle e-Business Employee Reconciliation (HRMS) and Oracle Access Governance by entering connection details and configuring your database environment. To achieve this, use the Orchestrated Systems functionality available in the Oracle Access Governance Console.
Navigate to the Orchestrated Systems Page
- From the Oracle Access Governance navigation menu icon
, select Service Administration → Orchestrated Systems.
- Click the Add an orchestrated system button to start the workflow.
Select system
On the Select system step of the workflow, you can specify which type of application you would like to onboard.
- Select Oracle E-Business Suite HRMS.
Enter details
On the Enter Details step of the workflow, enter the details for the orchestrated system:
- Enter a name for the application you want to connect to in the What do you want to call this system? field.
- Enter a description for the application in the How do you want to describe this system? field.
- Select the type of source to pull identities into Oracle Access Governance.
By default, This is the authoritative source for my Identities option is selected.
- Click Next.
Configure
On the Configure step of the workflow, enter the configuration details required to allow Oracle Access Governance to connect to the target system.
- In JDBC URL Template field, Specify the jdbc driver connection URL in the format jdbc:oracle:thin:@[host]:[port]:[DB]. For more info, refer to the JDBC driver documentation.
- In the User field, enter the database user with permission to access account table.
- Enter the password of the target database user in the Password field. Confirm the password in the Confirm password field.
- In Delete Person field, specify whether the employee record
must be completely deleted from the target system. When you delete an employee
record, the employee record is just set to terminated, but the record is not
completely deleted from the target system.
- If you set the value of this parameter to true, then the employee record is completely deleted from the target system.
- If you set the value of this parameter to false, then the employee record is not deleted from the target system, but its status is just set to terminated.
- In Include Future Hires field, specify whether the connector
must detect and reconcile records with future dated start date values.
- If you set the value of this parameter to
true
, then the connector reconciles all employee records with future dated Start Date values. - If you set the value of this parameter to
false
, then the connector does not reconcile employee records with future dated Start Date values.
Default value is
true
. - If you set the value of this parameter to
Finish Up
The final step of the workflow is Finish Up where you are prompted to download the agent for your Orchestrated System. Once you have downloaded the agent, you can install and configure the agent in your environment using the instructions in Install Oracle Access Governance Agent.
- Customize before enabling the system for data loads
- Activate and prepare the data load with the provided defaults
Integrate with Oracle e-Business Employee Reconciliation (HRMS)
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.