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

Suggestions required on how to rollup the Primary Hierarchy in compensation plan based on Number of

edited Sep 5, 2020 12:17AM in Compensation 1 comment

Summary

We have a business requirement wherein if any manager has less than 6 direct reports , then the hierarchy should roll one level up

Content

We have a business requirement wherein if any manager has less than 6 direct reports , then the hierarchy should roll one level up and this validation should continue until the a review manager has atleast 6 direct reports.

The eligible direct reports signifies the employees that stand eligible as per the criteria in the compensation plan, for example, the eligibility is based on the list of jobcode, legal employer.

We tried using a fast formula invoking the valueset to get the count and a while loop (until count 6), but the performance has degraded badly.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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