HDL – Sample file to load Job Translation File
METADATA|JobTranslation|EffectiveStartDate|EffectiveEndDate|JobCode|Name|Language|SetCode
MERGE|JobTranslation|1901/01/01|4712/12/31|TEST_664|Japnese Test Officer|JA|COMMONSimilar Posts
Purge Worker/Person Records from Test Environment
Oracle provides a process Purge Person Data in Test Environments to remove Person/Contact/Worker records from a test environment of Oracle HCM. Please note that HDL for core worker object doesn’t support DELETE, so there is no other option to purge the Person/Contact/Worker information from Oracle HCM once a record is created. In this case, Purge…
BIP – Query to extract Actions.dat data
Many a time there is a requirement to update/change the existing actions and actions reasons usages. Doing this manually in UI will become a cumbersome process for multiple actions and may lead to human errors as well. For this, HCM Data Loader can used to update the changes using Actions.dat file. Use the below SQL…
HDL – DELETE Person External Identifier
Person External Identifier information can be deleted easily using HDL. Under Worker use ExternalIdentifier to delete this data. Run the below query to extract required data in HDL format: Sample HDL File:
HDL – Sample HDL to load Succession Plans
Sample HDL for succession plan bulk upload:
HDL – Update Assignment Attributes with User Keys
Below is an example of updating assignment category using only user keys: If you want to use surrogate IDs/ integration keys, then you can check the below post: