Recently, I faced a scenario for a customer where after go-live, where there was an issue found with absence plan configuration. The absence plan was incorrectly set up. The Balance Frequency Source wasn’t setup to “Repeating Period”, so the accrual was calculated incorrectly. In order to fix this, a new absence plan was created and…
Starting 23C, a new HDL object has been added to close any pending actions for benefits. The certification type is validated against a lookup called – BEN_ENRT_CTFN_TYP Below is a sample file to close any pending certification actions against “POC”:
Attributes like student status, tobacco consumption which impact worker benefits can be loaded using PersonHabits.dat. Sample File:
Many a times, even after loading Person EFF information successfully, using HCM Data loader, the information is not available in UI. In such cases, please make sure that following fields are passed correctly: InformationType – Name of extra information type e.g. ‘XYZ Medical History’ EFF_CATEGORY_CODE – EFF Category Context. For example, for person EIT, the…
Below query can be used to extract the document record from content server.
Below is a sample file to create Pending Worker record using HDL: ReadyToConvert Flag on Work relationship is used to convert the Pending worker record to Employee record. If this flag is set to Y, it will appear in NewPerson Dashboard with Automatic conversion marked as Yes. Run Convert Pending Workers Automatically Process will pick the…
The rules can be verified from UI, once the HDL load is successful:
PersonDeliveryMethod child business object of Worker can be used to upload delivery preferences for a worker. Below is sample HDL file:
HDL provides an option to upload Potential life events for a person in benefits. Please note that ‘Open Enrolment’ life event can’t be loaded using the potential life events file. Provide the data in below format and save it as PotentialLifeEvents.dat
Oracle HCM allows an Organization to be classified as multiple Orgs. However, sometime there is a need to inactivate one org classification while keeping the primary classification as Active. Below is a sample HDL file which can be used for this purpose:
There are multiple primary flags for a worker in assignment table. Namely – Primary Assignment Flag, Primary Work Terms flag and Primary flag. Below query can be used to check these flags:
By default, PersonName child object of Worker.dat loads GLOBAL name type. PersonName object can be used to load local name as well. Two most important attributes of PersonName object for local name upload are: Name Type – Legislation Code CharSetContext – Short code for language. Below is a sample HDL file to upload local names…
HCM Data Loader can be used to mass upload worker images. The actual image file should be put in a BlobFiles folder and should be referenced in actual Worker.dat file. Post this, Worker.dat will be zipped together with BlobFiles folder and uploaded into HCM using Import and Load.
Post P2T, there is always a requirement to mask the candidate email addresses in lower environments. Below SQL can be used to generate data masked email data in HDL format: You can update the email address as per your requirement.
Please note that under attribute country, you will need to pass the full country name. Passing country code like GB, will throw below error: The values GB aren’t valid for the attribute LegislationCode.
