GET_VALUE_SET in FF is not returning a expected value
Summary:
I'm working on "Global Absence Accrual Matrix" formula type where I'm trying to pull Caregiver PTO balance using value set-
- I have created a Character type value set to pull the Caregiver PTO balance
- Validated the value set using gvs function and its returning a expected value
SELECT pay_ff_functions.gvs('IN_008_GET_ABSENCE_BAL_VS_1', '|=P_PERSON_ID=''' ||'3000000'|| '''' )
value_1_887306
FROM dual
Output value- 108.74
3. When I'm using the same value set inside the FF its returning a 0 value. Any idea what could be the reason
****************************************************
l_Absence_bal = 'NA'
l_person_id = GET_CONTEXT(PERSON_ID,0)
Tagged:
0