Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula
Summary
GET_VALUE_SET FormulaContent
Hi,
I want to create a fast formula controls that if a worker has an absence type A, this worker shouldn't get any absence. To do so I created this fast formula:
l_person_id = GET_CONTEXT( PERSON_ID,0)
l_absence_type_id = GET_CONTEXT( ABSENCE_TYPE_ID,0)
l_person_id_char =to_char(l_person_id)
L_absence_type_id_char = to_Char(l_absence_type_id)
L_PARAM ='|=PERSON_ID='||l_person_id_char||'|=ASSIGNMENT_ID='||L_absence_type_id_char
L_RETURN_VALUE = GET_VALUE_SET('
0