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.

Is there any way available to get absence count for a given Plan in a given duration

Hi Experts

I am trying to write a fast formula to get absence count for given Absence Plan(not type) in a given duration to address one of our requirement.

Appreciate if someone can help me on this.

Business Case:

In our environment, we have defined two Plans:

  • Annual Vacation (Accrual Type)
  • Unpaid Vacation(No entitlement)

We have attached both these plans to following absence type:

  • Vacation

Here Annual Vacation is priority 1 and Unpaid Vacation is priority 2.

Now following is the scenario:

  • Employee has 15 days Annual Vacation Balance as on 01-Apr-2023
  • Employee applies for Absence Type: Vacation "StartDate: 01-Apr-2023 till 15-May-2023" (45 days)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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