HDL script to create Contingent Worker/Employee in Oracle Fusion
In this post , We are going to discuss about HDL script to create Contingent Worker in Oracle Fusion. We will share the detail HDL script to create the contingent Worker/employee in Oracle Fusion. Here below is the detail about HDL script to create Contingent Worker/Employee in Oracle Fusion.
Employees Name Meta Data in Worker HDL File :-
Details steps to Create Contingent Worker/Employee in Oracle Fusion Through HDL
Step1:- 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 Legislative Details , Person Assignment Details which helps to upload the others Employees information's.
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Step2:- Basic Contingent Worker/Employee Information’s
To Create the Basic Contingent Worker/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
|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
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.
WorkerType Should be 'C'
METADATA|WorkRelationship|PersonId(SourceSystemId)|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|SourceSystemOwner|SourceSystemId
MERGE|WorkRelationship|355667|360296|Legal Employer Name|2018/06/18|C|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.
ProposedUserPersonType Should be 'Contingent Worker'
METADATA|WorkTerms|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|ProposedUserPersonType|LegalEmployerName|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PrimaryWorkTermsFlag|SourceSystemOwner|SourceSystemId
MERGE|WorkTerms|355667|355667_UnitedStates|Contingent Worker|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.
WorkerType Should be 'C'
PersonTypeCode Should be 'Contingent Worker'
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|C|ACTIVE_PROCESS|355667_UnitedStates|355667_367086_W|C|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
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Here below this is the Complete worker file having , Employee Header and Employee Assignment HDL scripts to create the complete Employee Information's.
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
To Import this Worker.Zip file we need to follow these steps as below.
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Once Your Data has been prepared then you need to go to the Oracle Cloud application.
You need to have 'human capital management integration specialist' role to use the HDL tool in Oracle Fusion.
Go to Navigator ==> Data Exchange
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Step 6:- Now you are in the HDL screen. Select the Task option as highlighted below.
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Step7:-Select the Import and Load Data.
 |
| HDL script to create Contingent Worker/Employee in Oracle Fusion |
Step 6:- Select the Option Import Local File as highlighted below to Import the Worker File Created in Step3 for Creating Contingent Worker/Employee in Oracle Fusion.
0 comments:
Post a Comment