Oracle HCM
Thursday, 9 October 2025
Sample HDL for Payroll Balance Name Translation
›
METADATA|PayrollBalanceDefinitionTranslation|BalanceCode|Language|BalanceName|ReportingName|LegislativeDataGroupName MERGE|PayrollBalanceDef...
Wednesday, 13 August 2025
Get sysdate in fast formula
›
L_SYSDATE = '4712/12/31 00:00:00' (date) L_SYSDATE = GET_CURRENT_DATE()
Thursday, 12 June 2025
HDL Lines
›
SELECT TEXT FROM fusion.hrc_dl_file_lines WHERE data_set_bus_obj_id IN (SELECT data_set_bus_obj_id FROM fusion.hrc_dl_data_set_bus_objs WHER...
HDL errors
›
Select fl.text, ml.MSG_TEXT from fusion.hrc_dl_file_lines fl , fusion.hrc_dl_data_set_bus_objs dsbo , fusion.hrc_dl_file_rows f...
Friday, 23 May 2025
Query to pull skills from Job Requisition in Oracle HCM
›
SELECT irc.requisition_number ,hpb.profile_code ,hpt.description profile_desc ,hpt.summary, hpi.ITEM_TEXT240_1 Job_Re...
Thursday, 3 April 2025
Oracle HCM Extract Schedule Query
›
SELECT pfv.base_flow_name Base_flow_name , pfi.instance_name, (SELECT To_char(Min(fti1.creation_date),'DD-MON-YYYY...
Sunday, 14 July 2024
Element entries query
›
SELECT 'BURSTING_KEY' BUR_KEY, person_number, plan_id, assignment_id, person_id, start_date, end_date, ...
›
Home
View web version