Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Fetching Element Entry Values in Fast Formulas as of Specific Date — Cloud Customer Connect
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

Fetching Element Entry Values in Fast Formulas as of Specific Date

Received Response
20
Views
1
Comments
edited Jul 6, 2021 12:45PM in Payroll and Global Payroll Interface (GPI) 1 comment

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 = &#39;2021/01/01&#39; (date)) (<br /> l_entry_val = X_AMOUNT_ASG_ENTRY_VAL<br /> )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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