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

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)?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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