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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Absence Balance as of a specific date

Summary:

We have a Yearly repeating Annual Leave plan where our cycle is Jan to December.

Through Accrual Matrix fast formula, we are trying to apply for a forfeit in the first quarter of the year(onetime code. Only applicable for this year). This is working as well.

But, we need to calculate the exact plan balance as of a specific date for example, we need to calculate the exact plan balance as of 31st March 2023.

The below code that i am using is giving me year end balance. I am looking for exact balance as of 1st April 2023. If plan balance is 30 and there is leave applied from March 20 to 10 April, the plan balance as of 31 March should show me 19 days

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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