HDL data loader in fusion

HDL data loader in fusion

In this post , we will be discuss about the HDL data loader in fusion. HDL data loader is the tool provided by oracle fusion to upload the employee data from External source into the oracle fusion application. HDL means HCM Data loader. In the names itself it more relates to the Employee or HRMS. With the of HDL data loader , we do create the Employee integration between third party application and with oracle fusion. HDL data loader is one of the best tool to mass upload employee in oracle fusion. HDL data loader supports hundreds of employees objects which we can import in oracle fusion like Employee Data , Employee Work structure data , Employee Banking Data , Employee User creation ,so these types of objects we can upload or create in Oracle fusion using the HDL data Loader. HDL data loafer offers the different Dashboard in oracle fusion to support the data loading process. Here below i will explain in more detail about HDL data loader in fusion and how we can use the HDL in fusion.

What is HDL 

As i said , HDL full form is HCM data loader. It helps to import or export the Employee Related data in Oracle Fusion. Using HDL , we can import the Employee related data from external application into the oracle fusion and using HDL , we can also export the Employee Related data from Oracle Fusion to send it to other third part applications.

With the Help of HDL, we can upload the Employees Work-structure data like Org, Job, Positions & Locations Information and Employee Transaction Information’s like Employee Header and Assignment Part.

In Employees, we have many Information’s like Data of Birth, Effective Start Date, Email Address, Phone Number, Sex (Male or Female), Job, Positions, Organizations, Locations, Supervisor Information’s, Expense Account Information’s.

How to Use HDL Data Loader in Oracle Fusion

Step1:- If you want to Go to HDL dashboard in Oracle Cloud then you have to follow the below Navigation.

 

Go to Navigator ==> Then below Data Exchange

 

 

Then Data Exchange ==> HCM Data Loader ==> View Business Objects

 

 

 

 

Step2:-  As below , these are the Business Objects , supported by HDL. We can find all the Data Objects of HCM supported by HDL.       

 

 

Step3:- For Example as , below I have find the Business Object ' Worker' which helps to upload the Employees basis Header and the assignment Information's in the Oracle Cloud.  

If we want to know which are information's we can take care using this business object then we need to click on Worker Link as highlighted below. 

f we want to know which are information's we can take care using this business object then we need to click on Worker Link as highlighted below. 

 

Step4:- Once we will be clicked on Worker Link then here below we will get all the information's about Worker Business Objects.

Under Worker , We have multiple , Objects Like Person Address , Person E-mail , Person Drivers License & Person Image which helps to upload the others Employees information's. We need

 

 

 

Step5:- If we want to know , Which are the Information's we can take care in each object then we need to click on that Object and then click on the attributes tab highlighted below to see all the columns under that Business Object.

Mandatory shows the Required Column of the Business Object which we need to be take care.

 

Step6:- For Person Email Business Objects

 

Step by Step to Import Employees Using HDL data loader in fusion

Step1:- As We already discussed above , We will be use "Worker" business object to create the Employees in Oracle cloud. In Worker business objects , We have multiple MetaData to create different different information's about Employees in Oracle cloud.

 

Under Worker , We have multiple , Objects Like Person Address , Person E-mail , Person Drivers License & Person Image which helps to upload the others Employees information's. We need

  

 

 

Step2:- Basic Employee Information’s

To Create the Basic Employee Information’s like Employee Start Date and Date of Birth , Action Code and Effective Start date of the Employee Header we will use this Below Meta Data/

METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|SourceSystemOwner|SourceSystemId

MERGE|Worker|355667|2018/06/18|4712/12/31|360296|2018/06/18|1982/06/05|Hire|XXTEST|355667

 

Step3:-

Employees Name Meta Data in Worker HDL File :-

To Upload the Employees Naming Information Like First Name , Last Name , Middle Name.

METADATA|PersonName|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|PersonNumber|NameType|Title|FirstName|MiddleNames|LastName|LegislationCode|SourceSystemOwner|SourceSystemId

MERGE|PersonName|355667|2018/06/18|4712/12/31|360296|GLOBAL|MR.|Ravi||Kumar|IN|XXTEST|355667_GLOBAL

 

 

Step4:- Employees Legislative Data Meta Data in Worker HDL File :-

To Upload Employees Legislative Data We need to use this below Script in Oracle Cloud.

METADATA|PersonLegislativeData|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|PersonNumber|Sex|LegislationCode|SourceSystemOwner|SourceSystemId

MERGE|PersonLegislativeData|355667|2018/06/18|4712/12/31|360296|MALE|IN|XXTEST|355667_IN_PLD

 

Step5:-  Employees Email Information Meta Data in Worker HDL File :-

To Upload Employees Email Information for an Employee in Oracle Cloud we need to use this Below Script in our Worker file.

METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag

MERGE|PersonEmail|XXTEST|355667_W1|355667|360296|2018/06/18|4712/12/31|W1|ravi.kumar@gmail.com|Y

 

Step6:- Employees Address Information Meta Data in Worker HDL File :-

To Upload Employees, Address Information for an Employee in Oracle Cloud we need to use this Below Script in our Worker file.

METADATA|PersonAddress|EffectiveStartDate|EffectiveEndDate|AddressType|PersonId(SourceSystemId)|PersonNumber|AddressLine1|AddressLine2|AddressLine3|TownOrCity|Country|PostalCode|PrimaryFlag|SourceSystemOwner|SourceSystemId

MERGE|PersonAddress|2018/06/18|4712/12/31|HOME|355667|360296|Test Line1|Test Line2|||US|63122|Y|XXTEST|355667_456214

 

 

These above all scripts helps to Upload the Employee Header Related Information’s in Oracle cloud. This is just an basic Employee Header Information’s. We can also upload many Employee Header Related Information through HDL and for this we just need to refer the HDL Sample Worker file and the options we have in this file to upload External Employees Information’s.

In Oracle Application, Employee is Divided in two parts. Employees Header and the Employee Assignment part.

These above scripts will only create the Employee Header Part. Now to create the Employee Assignment, we need to use some other Meta data available in Worker file so that we can create the Work Relationship Information.

First to Create the Employee Assignment through HDL we first need to use the Work Relationship Meta data.

Here below in this Script we are going to create the Employee Work relationship with the Leal Entity of the Company.

Or we can say that, this employee belongs to which Legal Employer.

This LegalEmployerName should be the Legal Entity name created in the System.

METADATA|WorkRelationship|PersonId(SourceSystemId)|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|SourceSystemOwner|SourceSystemId

MERGE|WorkRelationship|355667|360296|Legal Employer Name|2018/06/18|E|Y|XXTEST|355667_UnitedStates

After Creating Work Terms we need to Create the Work Terms for the Employee so that we can create its assignment in the system.

As below this is the Work Term creation script in the system.

METADATA|WorkTerms|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|ProposedUserPersonType|LegalEmployerName|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PrimaryWorkTermsFlag|SourceSystemOwner|SourceSystemId

MERGE|WorkTerms|355667|355667_UnitedStates|Employee|Legal Employer Name|HIRE|2018/06/18|4712/12/31|1|Y|Y|XXTEST|355667_367086_W

Now the very Important Part for Employee Assignment is assigning all the Important Information Like Organization, Job, Location , Position , Business  Unit and Expense Account Information’s in the System.

METADATA|Assignment|PersonId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeCode|PeriodOfServiceId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|WorkerType|PersonTypeCode|AssignmentNumber|PrimaryAssignmentFlag|PrimaryFlag|LegalEmployerName|BusinessUnitShortCode|DepartmentName|JobCode|PositionCode|LocationCode|BillingTitle|SourceSystemOwner|SourceSystemId

MERGE|Assignment|355667|HIRE|2018/06/18|4712/12/31|1|Y|E|ACTIVE_PROCESS|355667_UnitedStates|355667_367086_W|E|Employee|360296|Y|Y|Legal Employer Name|BU NAME|Corporate|Job Name|Position Name|Location Name||XXTEST|605688_367086_A

To Upload Employees Supervisor Information’s in Employee Assignment in Oracle cloud, We need to use this below script.

We need to use this below, Meta Data type in Worker. At file to Upload Supervisor Super Visor Information’s in Oracle Cloud.

METADATA|AssignmentSupervisor|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|AssignmentNumber|ManagerType|ManagerPersonNumber|SourceSystemOwner|SourceSystemId

MERGE|AssignmentSupervisor|2018/06/18|4712/12/31|355667|360296|LINE_MANAGER|200863|XXTEST|355667_367086_SUP

Here below this is the Complete worker file having , Employee Header and Employee Assignment HDL scripts to create the complete Employee Information's. 

To Import this Worker.Zip file we need to follow these steps as below.

Once the zip file have been prepared. Then We need to go Data Exchange

Then Data Exchange ==> HCM Data Loader ==> Import and Load Data

Once Import the Worker File , Then Employee Should be Upload and Created in Fusion.