Friday, 21 September 2018

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

No comments:

Post a Comment