Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Absence type Validation formula
Summary
Absence type Validation formulaContent
Hi All,
When I am making Formula as listed below
CHANGE_CONTEXTS(START_DATE=l_start_date, END_DATE=l_end_date)
(
WHILE ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR.exists(i) LOOP
(
CHANGE_CONTEXTS(ABSENCE_ENTRY_ID=ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR[i])
(
if(l_absence_type_id = ANC_ABS_ENTRS_ABSENCE_TYPE_ID AND ANC_ABS_ENTRS_ABSENCE_STATUS_CD <> 'ORA_WITHDRAWN') then
(
L_Prev_Duration = L_Prev_Duration + ANC_ABS_ENTRS_DURATION
)
)
i=i+1
)
)
L_Total_Duration = L_Prev_Duration + L_Duration
l_log = ESS_LOG_WRITE(TO_CHAR(L_Total_Duration))
Tagged:
0