Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Fetching Element Entry Values in Fast Formulas as of Specific Date
Content
Hello,
We'd like to fetch the element entry value for the 'Amount' input value as of a particular date.
For example, an employee has an entry for the element 'X' with the Amount input value as 100 in 01-Jan-21. From 01-Feb-21 onwards, the element entry was updated and the Amount set as 200. In an another fast formula, we'd like to retrieve the element entry information for 'X' as of 01-Jan-21, i.e. 100.
Our assumption was that we could write the fast formula code as below, but unfortunately that appears to fetch only the latest value (In the example, 200)
l_entry_val = 0<br />
CHANGE_CONTEXTS(EFFECTIVE_DATE = '2021/01/01' (date)) (<br />
l_entry_val = X_AMOUNT_ASG_ENTRY_VAL<br />
)
0