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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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!