HDL for Employees Organizations and Locations : HCM Interface to Import Employees Organization/ Department and Locations in Oracle cloud

HDL to Load Employees Organizations : HCM Interface to Import Employees Organization/ Department in Oracle cloud

When we create the employees in Oracle application , Then we need to specify the Employees Assignments in the system. These assignments store information's about Employees Job , Positions , Supervisor and Organization or Department to which that employee belongs. If we are doing employee conversions then we need to import all the Employees Organization or department first before importing the Final Employees. So Oracle has given us the Interface to upload or Import Employees Departments or Organizations to Import from External system or application to the Oracle cloud application.

 

Oracle has provided the HDL tool to load Employees Department or Organizations fro External system. We just need to Prepare the File in the format of the HDL file and then HDL tool helps to import the Data from that file to Oracle cloud and then create the department or organizations for that.

 

HDL full form is HCM Data loader which is given in Oracle Cloud to import or upload all Employees related stuff in the Oracle Application.

 

 

Example of HDL or HCM Interface to Import Employees Organization/ Department in Oracle cloud

Step1:- First We need to Prepare the data for Employee Organizations or Departments  and Locations in the HDL File format.

 

Step2:- We will create two HDL files. One for Employees Organizations and second for Employees Locations.

 

Step3:- First We need to Import the Locations because Locations Name we need to use in the Second HDL file for Employees Organizations or Departments.

 

Step4:-  Here below is the format of the Location HDL file.

 

 

METADATA|Location|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ShipToSiteFlag|BillToSiteFlag|OfficeSiteFlag|ReceivingSiteFlag|ShipToLocationCode|ShipToLocationSetCode|InventoryOrganizationName|LocationCode|LocationName|AddressLine1|AddressLine2|AddressLine3|Country|PostalCode|TownOrCity|MainphoneSubscriberNumber|OtherphoneSubscriberNumber|Description|Region1|Region2|Region3|SourceSystemOwner|SourceSystemId
MERGE|Location|COMMON|A|1901/01/01|4712/12/31|Y|Y|Y|Y|||#NULL|00002|New Delih||Janakpuri|New Delhi India|IN|234432|Delhi|||Delhi||||XXEXT|Delhi

 

 

 

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

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

 

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

 

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

 

 

 

 

Step5:- Now we will Prepare the HDL Data file for Employees Organizations or Departments.

 

 

METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationId(SourceSystemId)|LocationSetCode|SourceSystemOwner|SourceSystemId
MERGE|Organization|1901/01/01|4712/12/31|ABC CORP|DEPARTMENT|Delhi|COMMON|XXEXT|ABC CORP

 

 

 

 

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

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

 

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

 

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

 

 

 

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

 

 

 

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

 

 

 

Step5:- Select the Import and Load Data.

 

 

 

 

 

 

 

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

First start with 'Bank' and then "BankBranch'

 

 

 

 

Step7:- Import the Location and Organization zip files one by one.

 

First start with 'Location' and then "Organization'.

 

First wait for the Location HDL program to be completed successfully.