About This Recipe
This recipe verifies employee licenses and certificates in HireRight and imports the verified employee data into Oracle HCM Cloud.
To use the recipe, you must install the recipe and configure the connections and other resources within it. The recipe provides the following key capabilities:
- Extracts employee licenses and certificates in bulk from Oracle HCM Cloud using HCM Extracts.
- Transforms extracted details into HireRight REST calls to create the initial roster.
- Extracts delta details daily and transforms the extracted details into HireRight REST calls to manage the roster.
- Implements daily recertification of HireRight service.
- Implements one of the following:
- Transforms inbound HireRight alerts into HCM REST API calls to update verification and monitoring status related to certifications and licenses.
- Transforms inbound HireRight alerts into HCM Data Loader DAT file format and loads into Oracle HCM Cloud.
System and Access Requirements
-
Oracle Integration. Version 24.06 or higher
-
An account in Oracle Integration with the Service Invoker role
-
An account in Oracle Integration with the Developer role
-
Valid license for Oracle HCM Cloud version 24B or higher
-
HireRight license and certifications verifications monitoring service agreement
-
A secure FTP server (sFTP server) or File Server
-
An FTP client to access the external sFTP server
Recipe Schema
This section provides an architectural overview of the integration flows in the recipe.
Oracle HCM Initial Outbound Integration to HireRight
Description of the illustration initial-outbound-int-hireright.png
This integration is used to create the initial HireRight roster of all employees within the Oracle HCM Cloud that need to be monitored. This integration should be run once.
A dedicated one-time HCM Extract should be run to generate a full file of all employees for inclusion on the HireRight roster. This file should be manually loaded on to an sFTP server which Oracle Integration is able to reach. The integration should be run after the first-time HCM extract file upload. The integration will retrieve the HCM Extract file from the sFTP server and for each employee record make a create person HireRight REST call. If errors are generated due to incomplete or incorrect data, an error file will be generated which is then written back to the sFTP server for manual review. A notification is sent confirming the final status of the integration.
Oracle HCM Daily Outbound Integration to HireRight
Description of the illustration daily-outbound-int-hireright.png
This integration requires a daily HCM Extract to be run which generates a file containing only deltas from the previous run. This allows for changes entered in the HCM application to be sent to HireRight. Changes could include additions to the roster, deletions from the roster, status changes of existing employees, correction and updates to existing employees license and certificate information held by HireRight. This integration relies on the Oracle HCM Cloud Adapter to retrieve the generated HCM Extract file from UCM . This file is then processed by Oracle Integration into subsequent HireRight REST calls.
If errors are generated due to incomplete or incorrect data, an error file is created which is written to the sFTP server for manual review. A notification is also sent confirming the final status of the integration.
Oracle HCM Recertification Integration to HireRight
Description of the illustration recertification-int-hireright.png
To facilitate monitoring compliance with federal and state law, HireRight automatically suspends monitoring program whenever a re-certification is required, meaning roster members are monitored, but any possible results are held until re-certification is received. This integration should be scheduled to run every day at the same time to ensure that re-certification with HireRight occurs. The integration makes a call to the HireRight certification endpoint and enacts re-certification. Any errors or issues result in a notification email to an Administrator who can take action to investigate further.
Oracle HCM Inbound Integration from HireRight (HCM REST)
Description of the illustration inbound-int-hireright-hcmrest.png
HireRight generates alerts containing updates to license and certifications that are being monitored. These alerts are generated from various issuing authorities which are ultimately the primary source for licenses and certifications statuses. An individual alert is sent to Oracle Integration where it is transformed into an HCM REST API call and the corresponding individual Talent Profile Record of the employee is updated. As an optional step, a filter can be applied in which certain statuses are separated for manual review. You can also configure a lookup table to translate Issuing Authority statuses into seeded HCM Certification status. Both the filter and the lookup table are configurable. This exception file is in a DAT file format and can subsequently, be manually loaded into Oracle HCM Cloud via the HCM Data Loader.
Oracle HCM Inbound Integration from HireRight (HCM Data Loader)
Description of the illustration inbound-int-hireright-hcmdataloader.png
When HireRight monitoring reveals new data related to the employees being managed, HireRight will push the data to Oracle Integration, which will cause this integration to be initiated. The integration transforms the data received from HireRight and makes additional API calls to identify the specific employee record and license or certificate being monitored. Oracle Integration then generates a DAT file and initiates an HDL Data Load and Import process to update the data into Oracle HCM Cloud. As an optional step, a filter can be applied in which certain statuses are separated for manual review. You can also configure a lookup table to translate Issuing Authority statuses into seeded HCM Certification status. Both the filter and the lookup table are configurable.
Assumptions
- Based on your requirements, you may enhance the recipe to validate or selectively filter employees which should not be created in HireRight.
- The integration flows of the recipe include the minimal data mapping required to synchronize the data with HireRight.You can have additional mappings based on your specific requirements.
- The integration flows of the recipe include sample error handling and notifications. A robust error handling based on your own environment can be additionally implemented.
- You must configure only one of the Oracle HCM Inbound integrations from HireRight, either the one using HCM DataLoader or the one using HCM REST APIs. Using both will result in errors and may impact business operations.