X

An Oracle blog about HCM Cloud

FBL vs HDL

Prasanna Borse
Center of Excellence at Oracle

This article compares FBL and HDL – two of the commonly used data loading tools in Fusion HCM to highlight key differences and similarities. It also provides some useful information on documentation and user tools. 

Parameter FBL (File Based Loader) HDL (HCM Data Loader)

General

  • Release4+
  • Flat file based data load utility
  • Data from any source
  • Supports ~21 business objects
  • Partial data set for incremental updates except work relationship and salary
  • Delete is not supported
  • Limited support for flex fields
  • Release10+
  • Recommended tool for data loading for all new customers.
  • Flat file based data load utility
  • Data from any source
  • Supports ~90 business objects
  • Partial data set for incremental updates except salary. (We can now send partial row set for work relationship!)
  • Delete is supported for certain business objects.
  • Supports all flexfields including Extensible Flexfields and the PeopleGroup Flexfield

 

Supported File transfer

Supports both SFTP and UCM although UCM is the recommend method for file transfer.

Supports only the UCM as method for file transfer

UCM file transfer URLs (Examples)

UCM (Soap - Recommended)-
https://hxyz-test.fs.us2.oraclecloud.com/idcws/GenericSoapPort?wsdl

UCM (ridc – does not support SSO) - https://hxyz-TEST.fs.us2.oraclecloud.com/cs/idcplg

UCM (Soap - Recommended)-
https://hxyz-test.fs.us2.oraclecloud.com/idcws/GenericSoapPort?wsdl

UCM (ridc – does not support SSO) - https://hxyz-TEST.fs.us2.oraclecloud.com/cs/idcplg

Auto invoke URL (Examples)

FBL URLs for Auto invoke. URL format may differ depending on the file transfer protocol (sftp or ucm).

SFTP: If you are using SFTP as file transfer protocol then FBL URL will be for loader composite.

https://hxyz-test.hcm.us2.oraclecloud.com/soa-infra/services/default/HcmCommonBatchLoaderCoreInboundLoaderComposite/inboundloaderprocess_client_ep

https://hcm-aufsn4x0POD.oracleoutsourcing.com/soa-infra/services/default/HcmCommonBatchLoaderCoreInboundLoaderComposite/inboundloaderprocess_client_ep

UCM: If you are using the UCM as file transfer protocol for FBL then use loader integration service URLs.
https://hcm-aufsn4x0POD.oracleoutsourcing.com/hcmCommonBatchLoader/LoaderIntegrationService?wsdl

https://hxyz-test.hcm.us2.oraclecloud.com/hcmCommonBatchLoader/LoaderIntegrationService?wsdl

HDL URLs for Auto invoke:

https://hxyz-test.hcm.us2.oraclecloud.com/hcmCommonDataLoader/HCMDataLoader?wsdl

https://hcm-aufsn4x0POD.oracleoutsourcing.com/hcmCommonDataLoader/HCMDataLoader?wsdl

Data Files

Components data delivered in separate data files.

Files are grouped into a named folder.

All data in a single data file. Data file has the name of the object.

File is included in the top level within a zip file.

Processing Instructions

No explicit instructions - interpretation of how to process data is embedded in the FBL processing engine

Can indicate whether the data should be MERGED or DELETED.

Interpretation of what MERGE means is embedded in the object processing code.

Column Headings

Column Headings are defined in the FBL Columns Spreadsheet

Column Headings are different to FBL (e.g. PERSON_NUMBER becomes PersonNumber), and are described in the Business Object template files.

Date format

Date format is YYYY-MM-DD

Date format is YYYY/MM/DD

Keys

FBL uses GUIDs (source system references) to identify primary, parent and foreign keys. Accordingly there is just 1 column for each key reference.

HDL can use any of 4 different types of key to identify primary, parent and foreign keys. It uses annotations in the column heading metadata line to indicate the type of key being passed if not an explicit attribute. Supported keys are

  1. Oracle Fusion GUID
  2. Oracle Fusion Surrogate ID
  3. Source Keys
  4. User Key

Attachments and Images

Not supported

Attachments for specific business objects and Images are supported. These are provided in a special folder in the zip file and are referenced in the corresponding data files.

Flexfields

FBL has support for a limited set of flexfields. The column headers are provided with generic names e.g. Attribute1, Attribute2

  • DFF Support
    • PER_ASG_DF
    • PER_CITIZENSHIPS_DFF
    • PER_ETHNICITIES_DFF
    • PER_GRADES_DF
    • PER_JOBS_DFF
    • PER_LOCATIONS_DF
    • PER_ORGANIZATION_UNIT_DFF
    • PER_PERSONS_DFF

Supports all flexfields including Extensible Flexfields and the PeopleGroup Flexfield. The column headers use the Flexfield segment names rather than generic column names

Object Coverage

FBL supports around 21 objects

HDL supports around 90 objects. (Note - Business Unit was supported in FBL but not supported via HDL)

User Guide

User Guide 1595283.1

User Guide 1664133.1

Business Object Documentation 2020600.1

 

 

Overall Integration Guide

Rel10 Integration Guide

Rel10 Integration Guide

Desktop tools for automation

FBLdi - 1915774.1

Automation white paper - 1955064.1

 

HDLdi - 2056538.1 , there is another white paper on MOS to automate HDL without HDLdi 1664133.1

Offline data validators

Basic
Advanced – MySQL based

Validator - 2022617.1

Diagnostics

HR2HR Batch Error Analysis - 1600353.1
Batch Loader Diagnostics -1961599.1

Some Useful BIP\SQL reports – MOS community

HCM Data Loader Data-Set Status Diagnostics - 1664133.1

Coexistence tool-kits

Delivered toolkits must be used only as a reference point, customers must implement\customize their extracts to fit their business need

Peoplesoft Coexistence using FBL - 1667423.1 (You may raise SR for Peoplesoft (not fusion) for your PS and Tools release to get up to date info on PS patch for coexistence)

EBS Toolkit for Coexistence using FBL- 1556687.1

Delivered toolkits must be used only as a reference point, customers must implement\customize their extracts to fit their business need. 

Peoplesoft Toolkit  for Coexistence using HDL – 2111641.1

EBS Toolkit for Coexistence using HDL - 1942763.1

 

Hope you find it helpful. 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.