Oracle Cloud Blog

Today we are going to see Sample Absence Validation Fast Formula /* FORMULA TYPE: Global Absence Entry Validation */ DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date) DEFAULT FOR IV_END_DATE IS '4712/12/31 00:00:00' (date) DEFAULT FOR IV_TOTALDURATION IS 0 DEFAULT FOR ANC_ABS_TYP_NAME IS ' ' INPUTS ARE IV_END_DATE (date), IV_START_DATE (date), IV_TOTALDURATION l_eff_dt = get_context(EFFECTIVE_DATE,'0001/01/01 00:00:00'(date)) l_system_year = to_number(to_char(l_eff_dt,'yyyy')) l_absence_start_year = to_number(to_char(IV_START_DATE,'yyyy')) l_absence_end_year = to_number(to_char(IV_END_DATE,'yyyy')) /* START - Next Calendar Year Leaves needs to be applied separately */ if (ANC_ABS_TYP_NAME = 'Casual Leave') then ( if (l_absence_start_year = l_system_year and l_absence_end_year = l_system_year) then (valid = 'Y') else ( valid = 'N' error_message = 'Next Calendar Year Leaves needs to be applie

Below is the Fusion OTL Sample SQL , Shift Premium used in the SQL is the Custom Attribute . Use Custom Attributes based on your requirements .   SQL Text:   select papf . person_number Employee_Number , ppnf . full_name Employee_Name ,( select distinct ppnf_mgr . full_name from per_assignment_supervisors_f pasf , per_person_names_f ppnf_mgr where 1 = 1 and pasf . assignment_id = paam . assignment_id and pasf . manager_type = 'LINE_MANAGER' and pasf . primary_flag = 'Y' and ppnf_mgr . person_id = pasf . manager_id and ppnf_mgr . name_type = 'GLOBAL' and sysdate between pasf . effective_start_date and pasf . effective_end_date and sysdate between ppnf_mgr . effective_start_date and ppnf_mgr . effective_end_date ) supervisor_name ,( select dept . name f