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: 37
Todays Visits: 7

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.

Sricharan Monigari
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.
Sricharan Monigari
Sricharan Monigari

Leave a Reply