How to load Global and Local Names using HDL?
How to load Global and Local Names using HDL?
- How to load Global and Local Names using HDL?
Total Visits: 80

In this article we will look into how to load the Person Names in local language and global languages.

This is a guest post by Satish Muthuswamy who is a Oracle HCM Cloud Technical consultant having 2+ years of experience in core HR and expertise in HCM Data Loader.

Let’s get into details.

Person names are captured only in global language (English) in our Fusion instance and it is required without which we will not be able to load the local language names. However, if client need to capture both local and global name languages then we can use a template to load bulk data in your environment. It is not required to create a Descriptive flex fields for storing these local names.

Pre-requisite for this local names is installation of the respective language packs.

If we set NameType as GLOBAL then system will take English. Alternatively, in NameType mention your local language short code Example:

NameTypeLanguageShortCode
Global(Default)English 
FranceFrenchFR
Saudi ArabiaArabicAR
ChinaChineseCH

Sample HDL for loading Global Names for a Person:

METADATA|PersonName|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|PersonNumber|FirstName|MiddleNames|LastName|Title|MilitaryRank
MERGE|PersonName|2020/01/01||IN|GLOBAL|123456|Sathish||Muthuswamy|Mr.|N

Sample HDL for loading Local Names for the same person in other languages (Only after loading the Global Name):

METADATA|PersonName|EffectiveStartDate|EffectiveEndDate|PersonNumber|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title|CharSetContext
MERGE|PersonName|2020/01/01||123456|AR|AR|ساتيش||موثو|Mr.|AR
MERGE|PersonName|2020/01/01||123456|CH|CH|沙沙語||木戶|Mr.|CH

These files needs to be saved as Worker.dat and uploaded to the HCM Data Loader.

Once the above loads are complete, if we login with a different language as default we should be able to see the local language names.

HDL Template for Global and Local Names

Hope this has helped you learn a new thing today.

Thank you Satish Muthuswamy for coming up with this interesting article.

If you have similar content and want to share with wider audience and get featured on Fusion HCM Knowledgebase, please reach out to me on LinkedIn or Telegram.