Get Started with Redwood for Oracle Cloud HCM Begin Now
How to fetch value set value using fast formula
Summary:
Content (please ensure you mask any confidential information):
Hi Experts,
We have a requirement to fetch the value set details in a FF using GET_VALUE_SET function. I have defined a value set as below to fetch the absence balance by passing 2 parameters.
FROM Clause: ANC_PER_ACCRUAL_ENTRIES
Value Column Name: END_BAL
ID Column Name: PER_ACCRUAL_ENTRY_ID
WHERE Clause: person_id = :{PARAMETER.P_PERSON_ID} and ACCRUAL_PERIOD = to_date(:{PARAMETER.P_END_DATE}, 'YYYY-MM-DD')
Can anyone please help me to get the GET_VALUE_SET function syntax to pass 2 parameters (number and date data type)?
0