How to create Employee from HDL in Oracle cloud HCM?

HDL is known as HCM Data Loader which is used to Create and Update HCM data.
The data Received from external sources can be created or updated through HDL data format.

For creating an employee in oracle, Following are the mandatory Data needed to be given in the HDL file

Worker: These details needed to create the base employee in oracle.

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonNumber|StartDate|DateOfBirth|ActionCode
MERGE|Worker||DEMO001|2005/09/08|DEMO-1001|2005/09/08|1990/05/08|HIRE
MERGE|Worker||DEMO002|2005/02/08|DEMO-1002|2005/02/08|1989/04/09|HIRE

Data Needed:

a.) Source System Owner: Navigation: Manage Common Lookups>Search for “HRC_SOURCE_SYSTEM_OWNER”
b.) Person Number: Employee Number as Defined

Person Name: This defines the name of the Employee

METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonId(SourceSystemId)|NameType|LegislationCode|Title|LastName|FirstName
MERGE|PersonName||DEMO001_NME|2005/09/08|DEMO001|GLOBAL|US|MR.|gupta|Sumit
MERGE|PersonName||DEMO002_NME|2005/02/08|DEMO002|GLOBAL|US|MRS.|sharma|Lata

Data Needed:

a.) Source System Owner: Navigation: Manage Common Lookups>Search for “HRC_SOURCE_SYSTEM_OWNER”

WorkRelationship

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag
MERGE|WorkRelationship||DEMO001_POS|DEMO001||2005/09/08|E|Y
MERGE|WorkRelationship||DEMO002_POS|DEMO002||2005/02/08|E|Y

Data Needed:

a.) Source System Owner: Navigation: Manage Common Lookups>Search for “HRC_SOURCE_SYSTEM_OWNER”

b.) Legal Employer Name:
Navigation
Search> Manage Legal Entity HCM Information

Table Information

Select xep.name LE_NAME
from
xle_entity_profiles xep ,
hr_operating_units hou
where 1=1
and hou.default_legal_context_id(+) = xep.LEGAL_ENTITY_ID

WorkTerms

METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|PrimaryWorkTermsFlag
MERGE|WorkTerms||DEMO001_TRM|DEMO001_POS|HIRE|2005/09/08|1|Y|ET-DEMO001|ET-DEMO001|Y
MERGE|WorkTerms||DEMO002_TRM|DEMO002_POS|HIRE|2005/02/08|1|Y|ET-DEMO002|ET-DEMO002|Y

Data Needed:

a.) Source System Owner: Navigation: Manage Common Lookups>Search for “HRC_SOURCE_SYSTEM_OWNER”

Assignment

METADATA|Assignment|SourceSystemOwner|SourceSystemId|ActionCode|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|WorkTermsAssignmentId(SourceSystemId)|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|PersonTypeCode|BusinessUnitShortCode|PrimaryAssignmentFlag
MERGE|Assignment||DEMO001_ASG|HIRE|2001/09/08|1|Y|DEMO001_TRM|HDL001|DEMO001|ACTIVE_PROCESS|Employee||Y
MERGE|Assignment||DEMO002_ASG|HIRE|2005/02/08|1|Y|DEMO002_TRM|DEMO002|DEMO002|ACTIVE_PROCESS|Employee||Y

Data Needed:

a.) BusinessUnitShortCode : From Front end:

Setup and Maintainence > Functional Area (select Organization structures)>Assign Business Unit Business Funtion>Financial Reporting>Default Legal Entity

This can be accessed by the query

select xep.name LE_NAME
,hou.name BU_Name
from
xle_entity_profiles xep,
hr_operating_units hou
where 1=1
and hou.default_legal_context_id(+) = xep.legal_entity_id

Combine the different sections in a text file and then name it Worker.dat. Zip the file and upload it to the Navigation: Navigator> My Client Groups>Data Exchange>HCM Data Loader>Import and load data>Import File.

Wait for the status of Error or success.