Configure the Oracle HCM Initial Outbound Integration to HireRight

You must configure the Oracle HCM Initial Outbound Integration to HireRight (ORCL_HCM_LCNSVLDTN_HRRGHT_INITIAL_ROSTER) integration flow to successfully extract the existing employee details from Oracle HCM Cloud along with relevant licenses and certifications required for monitoring. Oracle Integration will then generate a file which can be used to create corresponding employees and certifications in HireRight.

You can extract the following employee information:

  • Basic details of the employee such as Person Number, First Name, Last Name, Person Email Address, Phone Number, and Home Address.
  • Any licenses and certifications associated to the job assigned to the employee.
  • Any licenses and certifications associated to the position assigned to the employee.

The following high-level steps are required to configure the Oracle HCM Initial Outbound Integration to HireRight integration flow:

  1. Configure the Oracle HCM Cloud Instance Extract
  2. Submit an Extract
  3. Update Integration Properties
  4. Update Schedule Parameters

Configure the Oracle HCM Cloud Instance Extract

Upload the pre-built extract to the Oracle HCM Cloud instance, update it (if required) and configure it.

  1. Log in to the Oracle HCM Cloud instance.
  2. Navigate to Manage HCM Extract Definitions.

    From the Fusion Navigation menu, and then from My Client Groups, select the Data Exchange application. Under HCM Extracts, select Extract Definitions or Setup and Maintenance, and then select Manage HCM Extract Definitions.

  3. On the Extract Definitions page, click Import.
  4. Enter the extract name and upload the extract file.
  5. Click OK, then click OK again.
  6. Next click Edit to the newly created extracted.
  7. Select Extract Execution Tree and click Compile All Formula.
  8. Refresh the screen and make sure all the fast formula status show passed status.
  9. Click Export XML Schema to download the .xsd file.
  10. Click Save and Close.

Submit an Extract

You have to submit the HCM Extract in order to configure the Oracle HCM Initial Outbound Integration to HireRight integration flow in Oracle Integration. The integration will use this submitted extraction for fetching data while running.

  1. From the Fusion Navigation menu, and then from My Client Groups, select the Data Exchange application. Under HCM Extracts, select Submit Extract.
  2. Search for the extract with its name.
  3. Click the extract.
  4. Enter the extract instance name and select the effective date.
  5. Click Submit.

This will execute the one-time HCM Extract of all valid employees for monitoring

Update Integration Properties

You can update the integration properties with appropriate values based on your environment and business rules.

  1. In the Integrations section, click Actions Actions icon on the ORCL_HCM_LCNSVLDTN_HRRGHT_INITIAL_ROSTER integration flow, then select Update property values.
  2. In the Update property values panel, update the integration properties with appropriate values.
    • EmailTo: This integration property holds the email address of the individual or distribution group to which error notifications are to be sent.
    • RetryCount: This integration property holds the number of retries for an individual record to be written to HireRight before an error is declared and written to the exception log. The default value is 2.
  3. Click Submit.

    A message confirms that the integration properties have been updated.

Update Schedule Parameters

You can update the following parameters with appropriate values based on your environment and business rules.

  1. In the Integrations section, click the ORCL_HCM_LCNSVLDTN_HRRGHT_INITIAL_ROSTER integration flow to open it.
  2. On the integration canvas, click the Schedule action and select Edit.
  3. Update the following parameters with appropriate values.
    Field Information to Enter
    hr-API-key Enter the value for this field. See Configure HireRight.
    hr-company-login Enter the value for this field.
    hr-user-ref-id Enter the value for this field.
    hr-API-version Enter the value for this field
    hr_MonitoringId Enter the value for this field
    hr_Monitoringname Enter the value for this field
    schedule_param_ErrorFilePath Specify the path of the folder on your sFTP server where exception records are written for further processing and manual review.
    schedule_param_FileName Specify the name of the HCM Extract result file that was generated earlier.
    schedule_param_FilePath Specify the path of the folder on your sFTP server where the HCM Extract result file is located.
  4. Click Save.

Leave the rest of the values in the Schedule action as is since they're referenced throughout the recipe.