HDL Script to change the Employee person type in oracle fusion

HDL Script to change the Employee person type in oracle fusion

Hi friends, we are going to discuss about the HDL Script to change the Employee person type in oracle fusion. We will share the detail HDL script and the steps too to change the employee person type. In oracle fusion, we often encounter the requirement to change the person types for employees/worker. If we have to update or change the employee person type in mass then we need to use this below hdl script for that. One most common requirement is , initially we hire the employees for temporary employment, for this we do create the employee person type as an contingent employees. After that , this employee got permanent then we need to change the employee/worker person type to 'contingent' to 'employee'. Please find below the complete detail about HDL Script to change the Employee person type in oracle fusion.

HDL Script to change the Employee person type in oracle fusion

2 Important HDL metadata to change the Employee person type in oracle fusion

METADATA|WorkTerms|AssignmentId|AssignmentNumber|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId|SystemPersonType|PersonTypeCode|ActionCode|ReasonCode

METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PersonNumber|SystemPersonType|PersonTypeCode|ActionCode|ReasonCode

Steps to prepare the HDL Script to change the Employee person type in oracle fusion

Here below , we will share the detail steps to change the employee/worker person type in oracle fusion using hdl tool.

Step 1:  We need to execute this below query for employee whose person type we want to change.

SELECT * FROM fusion.per_all_assignments_m

WHERE person_id IN (SELECT person_id FROM fusion.per_all_people_f WHERE person_number = '23443223'); 

This above sql query will give the 2 rows.

First row will have the column value PRIMARY_ASSIGNMENT_FLAG (Y)  <------------------------------THIS IS THE PRIMARY ASSIGNMENT

Second row will have the column value PRIMARY_WORK_TERMS_FLAG (Y)  <----THIS IS THE PRIMARY WORK TERMS ASSIGNMENT

Step 2:- Find out the system person type code for a contingent worker & Employee.

select system_person_type, user_person_type from per_person_types_vl where user_person_type='Contingent Worker'

select system_person_type, user_person_type from per_person_types_vl where user_person_type='Employee'

Step 3:- 

This could be run as one statement:

select system_Person_type,user_person_type from per_person_types_vl

where system_person_type in (select system_person_type from per_person_types_vl where user_person_type='<Worker type as shown in UI>') 

Step 4:- 

Final HDL script , to change the Employee person type in oracle fusion

METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PersonNumber|SystemPersonType|PersonTypeCode|ActionCode|ReasonCode

MERGE|Assignment|C320|300000009670805|2018/11/29|4712/12/31|1|Y|320|CWK|Volunteer|ADD_CWK|PLACE

METADATA|WorkTerms|AssignmentId|AssignmentNumber|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId|SystemPersonType|PersonTypeCode|ActionCode|ReasonCode

MERGE|WorkTerms|300000009670805|CT320|320|2018/11/29|4712/12/31|1|Y|300000009670804|CWK|Volunteer|ADD_CWK|PLACE 

Step 5:- 

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

HDL Script to change the Employee person type in oracle fusion

 

 

Step6:- 

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 change the Employee person type in oracle fusion

 

 

 

 

Step 7:- Now you are in the HDL screen. Select the Task option as highlighted below.

HDL Script to change the Employee person type in oracle fusion

Step8:-Select the Import and Load Data.

HDL Script to change the Employee person type in oracle fusion

Step 9:- Select the Option Import Local File

HDL Script to change the Employee person type in oracle fusion

Steps to find the reason code to use in HDL script

Setup and Maintenance

Expand task panel drawer

click on search

search for task: Manage Actions

Search for Action Name:Add Contingent Worker

Highlight the row "ADD_CWK" / Add Contingent Worker

Underneath you will see the associated "Action Reason Code"

For example, on my system:

HDL Script to change the Employee person type in oracle fusion

HDL Script to change the Employee person type in oracle fusion