HDL SCRIPT TO UPDATE MANGERS OR SUPERVISORS IN ORACLE CLOUD

HDL SCRIPT TO UPDATE MANGERS OR SUPERVISORS IN ORACLE CLOUD

In this post, we will discuss about the HDL script to update the Manager or Supervisor for Employees in Oracle Cloud. If we must Bulk Update the manager or supervisor information’s from some External application, then we can use this below HDL script to update the supervisor information’s. In this below HDL script, We are using three HDL metadata to update supervisor information’s. We need to use all these three Metadata for each employee to update manager information in oracle cloud. Here below I will try to explain and share the complete hdl script to update managers or supervisors in oracle cloud.

HDL Scripts to Update the Supervisor Information’s in Oracle Cloud

These three metadata we are using to update supervisor Information’s for each employee record. We need to prepare the data in this form.

METADATA|WorkTerms|WorkerType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|ActionCode|AssignmentNumber|LegalEmployerName|DateStart|PersonNumber

MERGE|WorkTerms|E||Y|1|2019/02/07|MANAGER_CHANGE| A22244|XX LE NAME |2018/09/12|99876

METADATA|Assignment|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|AssignmentNumber|WorkTermsNumber|DateStart|PersonNumber

MERGE|Assignment|2019/02/07||1|Y|MANAGER_CHANGE| A22244| A22244 |2018/09/12|99876

METADATA|AssignmentSupervisor| PersonNumber |EffectiveStartDate|EffectiveEndDate|ManagerType|ManagerPersonNumber|PrimaryFlag

 MERGE|AssignmentSupervisor|99876|2019/02/07|4712/12/31|LINE_MANAGER|972968|Y

Step2:- Once the Scripts will be ready then we need to put these HDL script in notepad and save as Worker.dat file as below.

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

Once the zip file have been prepared. Then We need to go Data Exchange

How to Rehire the Employee through HDL in Oracle cloud

Then Data Exchange ==> HCM Data Loader ==> Import and Load Data 

HDL SCRIPT TO UPDATE MANGERS OR SUPERVISORS IN ORACLE CLOUD