HCM Data Loader

 Configure HCM Data Loader Parameters

Setup and Maintenance > Configure HCM Data Loader > Open task

SELECT * FROM hrc_dl_parameters

Role for HCM Data Loader

Human Resource Integration Specialist

List of all Business Objects supported by HDL

Under View Business Objects in Data Exchange

Types of Keys supported by HDL

1. GUID
1. Oracle Fusion Global Unique ID
2. Hexadecimal
3. Can NOT use while creating new records
2. Source Keys
1. Combination of two fields
1. Source System Owner
1. HRC_SOURCE_SYSTEM_OWNER lookup under Setup and Maintenance > Common Lookups
2. Source System ID 
1. Alphanumeric value
2. Can be used while creating new records
3. Surrogate Keys
1. Can NOT use while creating new records
2. System generated Unique Numeric value for that record
4. User Keys
1. Can be used while creating new records
2. Part of the Business Object that they belong to
3. e.g. JobCode|SetCode

Table which stores Source, Surrogate and GUIDs

HRC_INTEGRATION_KEY_MAP

Update Source Keys once set

Yes, using SourceKey.dat

Purge HDL Staging Tables

Schedule purge process

My Client Group > Data Exchange > Delete Stage table data > Actions > Schedule deletion

HDL Error Report

HCM Data Loader Error Analysis Report

Extract HDL file in DAT format for errored records

Set 'Enable File Generation failed file lines' option to Yes in Configure HCM Data Loader. 20B onwards.

Load Fast Formula using HDL

Create Fast Formula (FF) with Effective Start Date on or before start date of other objects which refer your formula.

FastFormula.zip

    > FastFormula.dat

            > METADATA|FastFormula|SourceSystemOwner|SourceSystemID|EffectiveStartDate|FormulaCode|FormulaTypeCode|FormulaName|FormulaText|LegislativeDatGroupID(SourceSystemID)

            > MERGE|FastFormula|VISION|MGR_RANGE_SCHD_HRS|Range of Scheduled Hours|Manager Range of Scheduled Hours|ManagerRangeScheduledHours.txt|

    > ClobFiles

            > ManagerRangeScheduledHours.txt

Replace Effective End Date of the row after it is created

Add attribute ReplaceLastEffectiveEndDate

Not all object support this feature

Use of Set command in HDL

Override default behavior of HCM Data Loader

Use below statement in DAT file before first METADATA line in the file.

SET FILE_DELIMITER ,

By default below processes run automatically after we load Worker.dat file

1. Refresh Manager Hierarchy
2. Update Person Search Keywords

To Stop use 

SET INVOKE_POST_PROCESS Y|N

To stop particular process

SET DISABLE_POST_PROCESS_TASKS

To stop deleting future changes when MERGE is used for Update operation on the loaded data

SET PURGE_FUTURE_CHANGES N

Minimum Objects for Employee to get successfully loaded

1. Worker
2. Person Name
3. Person Legis
4. Work Relationship
5. Work Terms
6. Assignments

Load NULL values

Pass #NULL value to attribute. If not provided system may default value based on seeded logic.

Define Source System Owner

Navigator > Setup and Maintenance > Search Task 'Manage Common Lookups' > Search for Lookup 'HRC_SOURCE_SYSTEM_OWNER'

Payroll Flow to run HDL processes for Automation purposes

Load Data from File - For loading HDL using HDL FF

    > Navigate to Payroll > Checklist > Submit Payroll Flow > Load Data from File

Initiate Data Loader - Standalone HDL Load to run it based on Content ID

Send Notification when HDL process fails

No. Need to build BI Report

Update User Keys of Business Objects after loaded

Yes. Some user keys can be updated. Use Source Keys to update User Keys.

Extract to get all Source Keys Information for all business Objects

'Integration Object User Key Map Extract' extract can be used.

HDL Errors

1. Import and Export window
2. Tables
1. HRC_DL_MESSAGE_LINES
2. HRC_DL_PHYSICAL_LINES
   
3. HRC_DL_DATA_SETS
4. HRC_DL_FILE_ROWS
5. HRC_DL_FILE_LINES
3. Run Diagnostics Test