Loading Jobs in Oracle Fusion Using HDL

HDL:HCM Data Loader is a utility for loading business objects in bulk from any source to Oracle Fusion HCM.

We use HCM Data Loader to:

1. Perform one-time migration of legacy data to HCM.

2. Maintain your Oracle Fusion HCM data for occasional or ongoing updates. 

PreRequisites:

1. The HCM data loader configuration should be set to Full mode

Navigate to Setup and Maintainence --> search for Configure HCM Data Loader task.

Click on the task

Go to HCM Data Loader Scope – Select Full from the dropdown

Note: Once the HCM Data Loader Scope is changed to FULL, both FBL and Spreadsheet loader become Invalid

**ROLE needed to access this task: “Human Capital Management Integration Specialist”

Steps involved in Data loading:

1. Data from any source is made into the dat file as per the template

2. Dat file is loaded into the content server

3. Through HCM Data loader data is imported to the staging table

4. All the imported errors are sent back to the user

5. From the Staging table the data is loaded to the Application Table in FUSION

6. All the loading errors are sent back to the user

Preparing Dat Files:

1. All the data to be loaded is prepared in Worker.dat file .

2. This file can be generated from the application.

Login to Fusion Applications

Navigate to My Workforceà Data Exchange

Click on the Tasks Iconà Click on Initiate Data Load 

Search with Module As GLOBAL HR-Core Setup and Business Object as JOB .Select the row and click on Generate Template

**Note: If a specific Business object is not selected before clicking Generate Template, then templates will be created for all the Business objects in the Selected Module.

 

Click on Submit. It with submit a ESS job in the background and generates the Template.

 Download the generated template

Save the Job.dat File.

Getting Started:

It is recommended that, when loading a new Job, only the following mandatory components be supplied in .dat file, with the full date-effective history you require for each job:

METADATA Line Structure for job:

METADATA|Job|SourceSystemOwner|SourceSystemId|JobId|EffectiveStartDate|EffectiveEndDate|SetId|SetCode|Name|JobCode|ActionReasonCode|JobFamilyId|JobFamilyName|ActiveStatus|ApprovalAuthority

DATA Line structure:

MERGE|Job|HRC_SQLLOADER|300||1951/01/01|4712/12/31||COMMON|CH_1|CH_1||||A|4

NOTE: The data should be saved in .dat extension file and zip the file.The .dat file name should be according to the naming convention it should be job.dat in our case.

Sample Job.dat File for Job load:

 

Save the .dat file . Right Click on the DAT File and zip it.   

Navigate to My Workforce --> Data Exchange— right click on the tasks icon and select Import and Load Data 

  

It will ask to submit “Import and Load HCM Data File” ESS job. Click on Submit

Keep refreshing until the both the import and load process complete successfully.

Navigate to setup and Maintenance --> Search for Task Manage Job

Search for the job to check the job.