Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to get element entry value in specific date in fast formula? — 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

How to get element entry value in specific date in fast formula?

Accepted answer
11
Views
6
Comments
in Payroll and Global Payroll Interface (GPI) 6 comments

Hi,

We have requirements which need to get element entry value DB in specific date in formula of Oracle Payroll type, I tried to change context to be as bellow

DEFAULT FOR MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE               IS 0

l_eff_date = to_date ('10-07-2021','DD-MM-YYYY')

CHANGE_CONTEXTS (DATE_EARNED = l_eff_date)

  (

   L_VALUE = MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE

  )

  and tried also below

CHANGE_CONTEXTS (EFFECTIVE_DATE = l_eff_date)

  (

   L_VALUE = MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE

  )

but it is taking period all the time please advise.

Regards

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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