Part2 HDL Tutorial in Oracle Cloud : How to Create Employees Through HDL
This is the second part of HDL Tutorial , In the First Part , We have discussed about HDL tool , and how we can use this tool in Oracle Cloud. In part 1 , We have discussed about different business objects available in HDL tool which can be use to Import different different Employee Information's in Oracle Cloud. We have already discussed , all the important Information's about HDL now in the Second Part 2 , We will be using the HDL tool to create the Employees in Oracle Cloud. Here below we will discuss in detail about how to Create Employees Through HDL
I would recommend to go first in the Part1 of this Post for much clear understanding of this topic.
https://rpforacle.blogspot.com/2019/04/hdl-tutorial-in-oracle-cloud-what-is-hdl-in-oracle-cloud.html
Details steps to Create Employees Through HDL
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
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
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.
Part2 HDL Tutorial in Oracle Cloud : How to Create Employees Through HDL
0 comments:
Post a Comment