Oracle Application's Blog: Part3 HDL Tutorial in Oracle Cloud : How to Create Employees Through HDL( Employees Assignment)

Part3 HDL Tutorial in Oracle Cloud : How to Create Employees Through HDL( Employees Assignment)

This is the Third Part of Oracle Cloud HDL Tutorial , In the Last post Part 2 , I have shared the HDL scripts to create the Basic Employee Information's. If you want to create only Employee Header without Assignment then we can refer this last post part2. In this current post , I am sharing the HDL script to create the Employee Assignment information's through HDL. In the assignment , we can create Employee Job , Position , supervisor Information's , Organization and Other Expense Account Information's. Before starting this post , I would recommend to first go through this last post of HDL Tutorial Part 2 as below.

https://rpforacle.blogspot.com/2019/04/part2-hdl-tutorial-in-oracle-cloud-how-to-create-employees-through-hdl.html

In this 3 post , Part 3 of HDL tutorial , We will be discuss about , how we can create the Employee Assignment through HDL tool in Oracle cloud.

Details steps to Create Employees Through HDL( Employees Assignment)

Step1:-

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

Part3 HDL Tutorial in Oracle Cloud : How to Create Employees Through HDL( Employees Assignment)

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