Oracle Application's Blog: Employee load in oracle fusion

Employee load in oracle fusion

In this post, We will be discuss about Employee load in oracle fusion. Using HDL, we can mass employee load in oracle fusion. HDL is the tool given by Oracle fusion application to upload employees in oracle fusion from the External System. With the Help of HDL, we can upload the Employees Workstrucurte data like Org, Job, Positions & Locations Information and Employee Transactional 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. These all informations we do upload for employees in oracle fusion. Here below is the detail about Employee load in oracle fusion.

To Upload Employee Information’s, we need to go to the HDL dashboard to download the Worker file to know that which are the information’s are supported by Oracle Cloud HDL to upload in Oracle Cloud.

Step by Step Employee load 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

Employee load in oracle fusion

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

Employee load in oracle fusion

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.

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

Employee load in oracle fusion

Working Example to Employee load in oracle fusion

Step1:- As We already discussed in part 1 , 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

Employee load in oracle fusion

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/

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.

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.

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.

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.

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.

Step 6:-

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.

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.

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.

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.

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.