You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Absence type Validation formula

edited Jul 9, 2019 7:18PM in Workforce Management 6 comments

Summary

Absence type Validation formula

Content

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!