We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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