Customers using Oracle Human Resources Cloud face the challenge of continuous bulk loading of large amounts of data at regular intervals. Oracle Human Resources Cloud provides the tools like HCM Data Loader which address this business use case. Now you can automate data loading into Oracle Human Resources cloud using the Oracle UCM and Oracle HCM Data Loader plugins which leverage the HCM Data Loader for the Workload automation users.

Business Process automated:

 

 

 

Source: https://docs.oracle.com/en/cloud/saas/human-resources/20a/faihm/introduction-to-hcm-data-loader.html#FAIHM1372446

The above diagram shows the business process automated through these plugins:

This process is divided into 2 steps and hence the 2 plugins:

  1. A .zip file containing .dat files is placed on the Oracle WebCenter Content server. Here the Oracle WebCenter Content server acts as a staging infrastructure for files that are loaded and processed by the HCM Data Loader.
  2. HCM Data Loader imports the data first into its stage tables and then into application tables. Any errors that occur during either the import phase or load phase are reported in the job status and details in job log.

 

Technical description and workflow

Oracle UCM plugin

The Oracle UCM enables you to stage data files for processing to HCM Data Loader.

It provides easier integration with other business processes by using the Oracle Universal Content Management (UCM) integration.

The Oracle UCM Data Loader automates the process of bulk-loading of data. You can load the data files and monitor them from a single point of control.

The data is uploaded as zip files to Oracle UCM, which is processed by the HCM Data Loader.

This integration helps you save time, resources, and speed up data loading in a secure manner.

Prerequisite for the plugins to work:

– Oracle Human Resources Cloud service account with correct permissions to access File Import and Export task in the Oracle Human Resources Cloud web user interface.

– Credentials (username and password) for Oracle Human Resources Cloud web user interface.

 

Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle UCM” job type in the Cloud section:

 

Establishing connection to the Oracle Cloud:
In the connection tab provide URL, Username and Password.

 

 

A connection message is displayed when the connection is established.

 

 

Required File path which can be browsed using the Browse button

 

 

Submitting the job stream:

 

Track/ monitor the submitted job:
You can easily monitor the  submitted  job  in WA through navigating to “Monitor Workload” page.

 

 

Logs for the Oracle UCM file upload:

 

UCM File upload status from UI:

 

Oracle HCM Data Loader plugin

The Oracle HCM Data Loader integration enables you to import and load the data from data files uploaded to Oracle UCM by the Oracle UCM plugin to Oracle Human Resources Cloud.

The plugin internally invokes the importAndLoadData function from the HCMCommonDataLoader web service.

HCM Data Loader decompresses the .zip file and imports individual data lines to its stage tables. In the stage tables, related data lines are grouped to form business objects. Any errors that occur during the import phase are reported on the failed job log.

HCM Data Loader calls the relevant logical object interface method (delivered in product services) to load valid objects to the application tables. Any errors that occur during the load phase are reported on the failed job log.

Prerequisite for the plugins to work:

– Oracle Human Resources Cloud service account with Human Capital Management Integration Specialist job role or privileges to access HCM Data Loader.

– Credentials(username and password) for Oracle Human Resources Cloud web user interface.

 

Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle UCM” job type in the Cloud section:

 

 

Establishing connection to the Oracle Cloud:
In the connection tab provide URL, Username and Password.

A connection message is displayed when the connection is established.

 

Required Content ID which is generated by the Oracle UCM plugin

 

Submitting the job stream:

 

Track/ monitor the submitted job:
You can easily monitor the  submitted  job  in WA through navigating to “Monitor Workload” page.

 

Logs for the Oracle HCM Data Loader:

 

HCM Data Loader import and load status from UI:

 

Are you curious to try out both OracleUCM and OracleHCMDataloader plugins? Download the integrations from the Automation Hub and get started or drop a line at santhoshkumar.kumar@hcl.com.

Comment wrap
Further Reading
article-img
Automation | May 17, 2022
HCL Workload Automation Observability for Splunk
The Observability is the evolution of monitoring into a process that offers insight into digital business applications, speeds innovation and enhances customer experience, basically it is an emerging set of practices, platforms, and tools that goes beyond monitoring to provide insight into the internal state of systems by analyzing external outputs.
article-img
Automation | March 4, 2022
Accelerate IT and Business Automation with Streamlined Modelling, Advanced AI and Open Integration for Observability | HCL Workload Automation Version 10
HCL Software is pleased to announce a new release for Workload Automation, Version 10. With HCL Workload Automation Orchestrate complex workflows across multiple platforms and applications with best-in-class automation solution. Boost your business with the most advanced workload scheduling, managed file transfer, and real-time monitoring capabilities for continuous automation. Keep control on your automation processes from a single point of access and monitoring!
article-img
Automation | January 6, 2022
Case Study: Regulatory Compliance Workflow through HCL Workload Automation:
In this Blog, we would go through a Regulatory Compliance UseCase where a Customer wanting to perform a Transaction at a Gaming Kiosk undergoes a series of Background Checks and Validations to know if he is eligible to proceed with the Transaction, the checks while happening in the background through HCL Workload Automation in real time within a few seconds would seamlessly allow the Customer to proceed with the Transaction. Incase the Customer is blacklisted then he is blocked from performing the Transaction, likewise incase there is suspicion of Money Laundering, the Customer is blocked from progressing with the Transaction.
Close
Filters result by
Sort:
|