About This Recipe
This recipe verifies employee licenses, certificates, and registrations in EverCheck 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, certificates, and registrations data in bulk from Oracle HCM Cloud using HCM Extracts.
- Transforms the extracted data into EverCheck file format.
- Transfers the transformed file to an EverCheck sFTP server.
- Retrieves the file containing processed and monitored employee licenses, certificates and registrations data from Evercheck sFTP server.
- Transforms the retrieved file containing processed employee data into HCM Data Loader dat file format.
- Imports the employee licenses, certificates, and registration verification status into Oracle HCM Cloud using HCM Data Loader.
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
-
Oracle HCM Cloud, Version 24B or higher
-
EverCheck License, Certifications, and Registrations Verifications Monitoring service agreement
Recipe Schema
This section provides an architectural overview of the integration flows in the recipe
Oracle HCM Outbound Integration to EverCheck
Description of the illustration outbound-integration-hcm-evercheck.png
In Oracle HCM Cloud, HCM Extract generates a file on a predefined schedule containing all of the employees required to be monitored. This file is retrieved by a scheduled integration running on Oracle Integration. The file is transformed from XML to CSV as part of the execution of the integration flow, and the resulting file is placed on to an sFTP EverCheck server. This file will be used to generate the current active monitoring roster for EverCheck’s license monitoring service.
Oracle HCM Inbound Integration from EverCheck
Description of the illustration inbound-integration-hcm-evercheck.png
On a scheduled basis, EverCheck generates a file containing updates to licenses, certifications, and registrations which it is monitoring. These updates are generated from the various issuing authorities which are ultimately the primary source for licenses, certifications, and registrations. This file is retrieved by a scheduled integration running on Oracle Integration. The file is transformed into a DAT file format. 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. Subsequently, the DAT is loaded into Oracle HCM Cloud via the HCM Data Loader.
Assumptions
- Based on your requirements, you may enhance the recipe to validate or selectively filter employees which should not be created in EverCheck.
- The integration flows of the recipe include the minimal data mapping required to synchronize the data with EverCheck.You can have additional mappings based on your specific requirements. The final section of this document details the mapping between the various file types of these integrations. For details of the mapping between the various file types of the integrations, see Bulk File Data Models.
- 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.
- This recipe does not include a SystemUser integration between Oracle HCM Cloud and EverCheck. The setup of EverCheck system and manager users will need to be done directly in EverCheck via the existing UI or a separate integration will have to be created.