Fusion HCM – Calling a Value Set in Fast Formula

Below is a Sample Formula shows How to Call a Value set in Fast Formula :


Inputs are hr_id (number),
           eff_st_date(text),
           eff_end_date(text),
           mode (text)

l_hr_per_id   = hr_id
l_eff_st_date = eff_st_date
l_eff_end_date = eff_end_date

X_OUTPUT    = ‘0001/01/01 00:00:00’  (DATE)
X_OUTPUT_NUMBER  = 0
X_OUTPUT_TEXT  = ‘ ‘

IF mode = ‘GROSS’ THEN
(  
    X_OUTPUT_TEXT  =  GET_VALUE_SET ( ‘AH_GET_GROSS_YTD_VALUE’ , ‘|=L_PERSON_ID=”’|| TO_CHAR(l_hr_per_id)||””||’|L_CMP_START_DATE=”’|| l_eff_st_date ||””||’|L_CMP_END_DATE=”’|| l_eff_end_date ||””)
)
ELSE
(
    X_OUTPUT_TEXT  =  ‘0’
   
)

RETURN X_OUTPUT_TEXT

  • September 21, 2018 | 19 views
  • Comments