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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula

edited Mar 5, 2020 12:57PM in Workforce Management 2 comments

Summary

GET_VALUE_SET Formula

Content

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('

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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