Human Capital Management (HCM) Cloud provides a comprehensive set of
tools, templates, and pre-packaged integration to cover various
scenarios using modern and efficient technologies. One of the patterns
is the batch integration to load and extract data to and from the HCM
cloud. HCM provides the following bulk integration interfaces and tools:
HCM Data Loader (HDL)
is a powerful tool for bulk-loading data from any source to Oracle
Fusion HCM. It supports important business objects belonging to key
Oracle Fusion HCM products, including Oracle Fusion Global Human
Resources, Compensation, Absence Management, Performance Management,
Profile Management, Global Payroll, Talent and Workforce Management. For
detailed information on HDL, please refer to this.
Extract is an outbound integration tool that lets you select HCM data
elements, extracting them from the HCM database and archiving these data
elements as XML. This archived raw XML data can be converted into a
desired format and delivered to supported channels recipients.
Fusion HCM provides the above tools with comprehensive user interfaces
for initiating data uploads, monitoring upload progress, and reviewing
errors, with real-time information provided for both the import and load
stages of upload processing. Fusion HCM provides tools, but it requires
additional orchestration such as generating FBL or HDL file, uploading
these files to WebCenter Content and initiating FBL or HDL web services.
This post describes how to design and automate these steps leveraging
Oracle Service Oriented Architecture (SOA) Cloud Service deployed on
Oracle’s cloud Platform As a Service (PaaS) infrastructure. For more
information on SOA Cloud Service, please refer to this.
SOA is the industry’s most complete and unified application integration
and SOA solution. It transforms complex application integration into
agile and re-usable service-based components to speed time to market,
respond faster to business requirements, and lower costs.. SOA
facilitates the development of enterprise applications as modular
business web services that can be easily integrated and reused, creating
a truly flexible, adaptable IT infrastructure. For more information on
getting started with Oracle SOA, please refer this. For developing SOA applications using SOA Suite, please refer to this.
These bulk integration interfaces and patterns are not applicable to Oracle Taleo.
HCM Inbound Flow (HDL)
WebCenter Content (WCC) acts as the staging repository for files to be
loaded and processed by HDL. WCC is part of the Fusion HCM
The loading process for FBL and HDL consists of the following steps:
- Upload the data file to WCC/UCM using WCC GenericSoapPort web service
- Invoke the “LoaderIntegrationService” or the “HCMDataLoader” to initiate the loading process.
the above steps assume the existence of an HDL file and do not provide a
mechanism to generate an HDL file of the respective objects. In this
post we will use the sample use case where we get the data file from
customer, using it to transform the data and generate an HDL file, and
then initiate the loading process.
The following diagram illustrates the typical orchestration of the end-to-end HDL process using SOA cloud service: Read the complete article here.
SOA & BPM Partner Community
regular information on Oracle SOA Suite become a member in the SOA
& BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.
Blog Twitter LinkedIn Facebook Wiki