HCM Cloud HDL Interface : How to create Job and Positions through Interface in Oracle Cloud

HCM Cloud HDL Interface : How to create Job and Positions through Interface in Oracle Cloud

In Oracle Cloud , If we want to Upload Mass Jobs and Positions for Employees then we need to use the HDL (HCM data Loader). HDL helps to Import the Jobs and Positions from External System to the Oracle cloud application. We can also say this as a HCM cloud Interface.

We need to prepare the job and position Data in the HDL file formats to upload in the HCM cloud Interface. HDL program helps to import all Employee related Data from External system.

Steps to Create or Import Job and Positions through Interface in Oracle Cloud 

Step1:- We need to Create two HDL files to Import Job and Positions.

One file for Job and Second file for Position.

Step2:- To create the Job and Positons , first  we need to create the HCM Organizations or Departments and the Locations to be used in the Job and Positions File.

We can create the Organizations or Departments and the Locations manually and Through HDL too. 

Please refer this below post to create the Organizations and Location through HDL

https://rpforacle.blogspot.com/2019/01/hdl-for-employees-organizations-and-HCM-Interface-to-Import-Employees-Organizations-in-oracle-cloud.html

Step3:- As below this is the HDL file format for JOB

METADATA|Job|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|SetCode|JobCode|Name|ActiveStatus|JobFamilyCode|BenchmarkJobFlag|BenchmarkJobCode|ApprovalAuthority
MERGE|Job|XXEXT|EngineerIT|1901/01/01|4712/12/31|COMMON|73817|EngineerIT|A|India|N|#NULL|#NULL
MERGE|Job|XXEXT|ManagerIT|1901/01/01|4712/12/31|COMMON|138675|ManagerIT|A|India|N|#NULL|#NULL

In this Job File, First Line is always static and your Job Data Starts from Second Line.

From Second Line first Two Columns are static and then after that your Jobs data starts.

Then you need to save this File in the Name 'Job.dat'

Once You save this File then you need to put this File under the zipped Folder 'Job' and then put this Location.dat file under the 'Job' Zipped Folder

Step4:- As below this is the HDL file format for POSITION

METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|BusinessUnitName|PositionCode|Name|ActiveStatus|HiringStatus|DepartmentName|JobId(SourceSystemId)|JobSetCode|LocationId(SourceSystemId)|LocationSetCode|PositionType|WorkingHours|Frequency|StartTime|EndTime|ProbationPeriod|ProbationPeriodUnitCd|OverlapAllowedFlag
MERGE|Position|XXEXT|Engineer IT|1901/01/01|4712/12/31|Vision Instance|8966074|Engineer IT|A|APPROVED|ABC CORP|EngineerIT|COMMON|NEW Delhi|COMMON|#NULL|40|Weekly|08:00|16:00|#NULL|#NULL|Y
MERGE|Position|XXEXT|Manager IT|1901/01/01|4712/12/31|Vision Instance|8966084|Manager IT|A|APPROVED|ABC CORP|ManagerIT|COMMON|NEW Delhi|COMMON|#NULL|40|Weekly|08:00|16:00|#NULL|#NULL|Y

In this Position File, First Line is always static and your Position Data Starts from Second Line.

From Second Line first Two Columns are static and then after that your Positions data starts.

Then you need to save this File in the Name 'Position.dat'

Once You save this File then you need to put this File under the zipped Folder 'Position' and then put this Position.dat file under the 'Position' Zipped Folder

Step5:- 

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

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

Step7:-Select the Import and Load Data.

Step 6:- Select the Option Import Local File as highlighted below to Import the Job and Positions zip files one by one.

First start with 'Jobs' and then "Positions'