HDL in Oracle Fusion HCM Cloud

 

HDL- HCM Data Loader

It is a Bulk Data Loader to load HCM Cloud related to Objects.

What are the Business Objects we can load using HDL?

Location

Jobs

Positions

Grades

Worker-Complex one(hierarchy we need to follow)

What is the process?

HDL will contain templates

Identify the templates for the BO which u are going to load.

Prepare data for the template.

.date file(a pipe delimeter file) in zip format is ready then we will go for the import process.

Import process will move data to Stage Tables.

Load process will move the data to Base Tables(Application Tables)

Once data is there in base tables then you will be able to see it in UI.

 

Navigation:

Navigation bar, MyClient GroupsàData Exchange.

We can find HDL, HSDL & HCM Extracts.

 

What are the location base tables?

Per_locations

Per_locations_details_f

Per_locations_details_f_tl

 

Click on View Business Objects.

 

 

 

 

Search for locations

 

Location will store Place, address and other details of the organization.

File name should be as: Location.dat.

We should not change the file names.(Template Name)

Download the template.

Bkp is for structure

Location is the duplicate file.

Both are DAT file

Open Location with Notepad++

 

 

It is a HDL file

COMMENT: It consists of short text or long text. Compiler ignores the lines in Comment section.

METADATA means column structure.

Eg:

Insert into dept(deptno,dname,loc) values(20,’software’,’blr’);

In the same way

Metadata means columns for the location.

Merge means values for the location

Optional columns we can remove

Insert into dept(deptno,dname) values(20,’software’,);

Template provide the all the possible columns for the component Location.

Location Extra Ino is a component

LocationLegislative

LocationOtherAddress

Are all these mandatory?

We need to check.

Go to Myclient groups

Workforce structures

Locations

Create  a location

 

                       

Extra info optional

Legislative info optional

So, remove optional columns from the HDL file

Every column need to be separated with single pipe delimeter.

 

Click on Location in search section.

 

 

 

File Descriminator: Location

Click on Attributes

LocationId is a Surrogate Key

LocationCode and SetCode are User Key

 

 

Surrogate Id will be only available when updating the existing locations.

For creating a Location, Location Id(primary key) surrogate key is not required to pass.

Only when you are going o update existing Location, we can use Location Id.

Location Code- within the set the code to identify Location uniquely (User Key)

SetCode- COMMON

Within the SetCode Common the location code should be there uniquely.

ActiveStatus- is required for new records.

There is a Lookup available to check status.

To check Lookups, navigate to ‘’Setup and Maintenance’’ , go to Global search and search a Task called ‘’Manage Common Lookups’’

Search for the Lookup name

  

 

 

 

EffectiveStartDate= mandatory pass the value

EffectiveEndDate= optional leave it as null

 

Country=Mandatory

LocationName =Mandatory

SetId=Mandatory(we don’t have ID so alternativel we passed Setcode)

 

Once you are ready with dat zip file, go to HDL page and click on import

 

 

Select zip file, click on submit

We have two options Import only or Import and Load

 

File has placed in UCM content server and created an id automatically for it.

Check delete source file and click on submit.

Then click on Refresh

 

Metadata will be only one on the top

Merge will be multiple records

 

 

Once you do the correction, delete the existing zip file and convert dat file again to zip folder.

 

 

Every import has content id

 

Now, search the location which is created in front-end.

 

Let us try one negative case and two positive case

Change the dates for other records and try to import

For old record, effectiveenddate will be provided.

For new record, no effectiveend date

 

Negative case

COMMENT Data for Business Object: Location Version: V2 Created on: 03-08-2024

METADATA|Location|LocationCode|LocationName|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|Country

MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN

MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN

Positive Case:

COMMENT Data for Business Object: Location Version: V2 Created on: 03-08-2024

METADATA|Location|LocationCode|LocationName|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|Country

MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN

MERGE|Location|xx_blr07_HDL|BLR07|COMMON|A|2024/09/21||IN

MERGE|Location|xx_blr008_HDL|BLR0|COMMON|A|2024/09/21||IN

date

HDL Error Report

Excel output