Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Unable to retrieve previous value of DBI
Summary:
We are trying to call the employee's salary at hire date in a fast formula but the current value is being pulled through despite changing the EFFECTIVE_DATE context.
Content (please ensure you mask any confidential information):
In our test, employee is hired on 27/12/2023 with a salary of £23,000 then on 01/01/2024 has a salary increase to £30,000. In January pay calculation we are trying to retrieve the £23,000 value from the XXXX_AMOUNT_ASG_ENTRY_VALUE DBI but the £30,000 value is pulled through.
Version (include the version you are using, if applicable):
23D
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0