BIP – Extract list of counties for GB
Below SQL can be used to extract list counties configured for GB in HCM:
SELECT *
FROM fusion.hz_geographies hg
WHERE hg.geography_type = 'COUNTY'
AND country_code= 'GB'
ORDER BY geography_nameSimilar Posts
HDL – Query to generate worker email in HDL format
Sample HDL File:
Reports (BIP) – Query to get correct time zone
When an activity in learning is created with a start time and end time, the time is stored in UTC format in the data base. When any reporting is done on this data, the output is incorrect as time is shown in UTC format which is different from user time format. This is applicable for…
BIP – Approval Task Name in Transaction Console vs Task name in BPM
In HCM, you can define approval rules for different HCM tasks from Tools -> Transaction Console -> Approval Rules For example, you want to define an approval rule for Promote action. You can search Promo% in Find box and it will give you all matching approval rules: You can then click on ‘Configure Rules’ to…
HDL – Load Goal Library Data
Goal Library is loaded as Content items using ContentItem.dat. The various attributes and their mapping can be found using GoalLibraryAttributes.xlsx which can be found on metalink using below note id: Query To Get Goal Library Goals (Doc ID 2228128.1) How to Load Library Goals (Doc ID 2201757.1) Please note that ItemText2 (Priority Code) and ItemText12…
HDL – Update Goal Weight
Goal Weightage can be updated using GoalMeasurement metadata in Goal business object. First, we need to extract the uploaded measurements. Use the below query to extract the details: Save the data in Goal.dat HDL file. Update the target value as required. Save the .dat file and upload. Sample HDL: