Oracle Fusion/Cloud Data loading Techniques

The different available ways of developing inbound integrations to Oracle Fusion HCM?

1. Payroll Batch Loader
2. HCM Data Loader
3. HCM File-Based Loader
4. HCM Spreadsheet Data Loader

• What is Payroll Batch Loader?

• What is HCM data Loader?

• What is HCM File based loader?

• What is HCM Spreadsheet Data Loader?

   The payroll batch loader is used initial migration or mass payroll data entry with predefined batch loader, predefined processes, and web services. The best use if you different time and labor and absence system you can use payroll batch loader to pull the time card data to HCM fusion payroll.

In Payroll system specifically for North American payroll if you are going live in between of the calendar year and converting from another system to Oracle Fusion HCM fusion, its much required and critical task to convert initial earning, deduction, tax balance for each employee before you start to process the payroll. You can use Payroll batch loader

   The most used method HCM Data Loader to load data in bulk from any source to Oracle Fusion HCM.  The HCM Data Loader for data migration can be used for one-time bulk loads, or ongoing data maintenance. HCM Data Loader supports incremental or partial data loading. The method suitable for loading:

-    Complex, hierarchical data

-    Large volumes of data, such as complete system extracts

-    Object history

The benefits of HCM data loader, it supports for the following.

-    HCM data loader provides user keys for integration-enabled objects.

-    Source key

-    User key

-    Oracle Fusion surrogate ID

-    Oracle Fusion GUID (Globally Unique Identifier)

-    Objects from many HCM products: - HCM Data Loader provides a template file for each supported business object hierarchy, which you can use as the basis for your own data files. You generate template files in the Data Exchange work area in the cloud.

-    Configured descriptive and extensible flex field data, translation data, tree hierarchies, person images, and document of record attachments.

The best part of the HCM Data Loader is, it provides a comprehensive user interface for starting data upload, monitoring progress, and reviewing errors. Using web services is the best option to automate data loading.

      The Oracle Fusion HCM File-Based Loader helps to load data in bulk, including business object history, from any data source to Oracle Fusion HCM. File-Based Loader uses the Oracle Fusion HCM load batch data process to load your source data to the Oracle Fusion application tables. The File-Based Loader is best for an initial data upload and ongoing maintenance of the data in Oracle Fusion application.  The maintenance typical activity of file based loader are:

•    To upload changed data periodically if you're continuing to maintain the source data example Additional Pay in Payroll.

•    To perform periodic batch-loading of objects such as new bulk configuration objects like a list of institution address which changes periodically.

The file based loader supports following areas of Oracle Fusion HCM cloud

•    Oracle Fusion Coexistence for HCM

•    Oracle Fusion Enterprise Structures Configurator (ESC)

•    Oracle Fusion HCM Spreadsheet Data Loader

   The loading process is simple, Import data in Object-specific batch, prepare data for loading stage tables and Load the data from stage to fusion application tables.

In release 11, 28 business objects are supported by file based loader.

   HCM spreadsheet based loader is MS-Excel utility provide by Oracle and referred as Oracle ADF Desktop Integration. You need to install this utility to use file based loader. Most commonly used for Absence, compensation, person, assignment and talent business object. The Oracle fusion provides many spreadsheet loaders for specific business object load.

   Commonly you need to first create the spreadsheet on the page where you manage the object, second, Load the objects directly to the application tables, finally, correct any errors in the spreadsheet.