Human Capital Management - EBS (MOSC)

MOSC Banner

How to check if an employee is eligible for an eligibility profile using pl/sql

edited Jun 8, 2015 11:54PM in Human Capital Management - EBS (MOSC) 5 commentsAnswered ✓

Is there a pl/sql function where I can pass a person_id and a eligibility profile id and the function returns if the employee is eligible based on that eligibility profile.

I am using eligibility profile in my Performance Management Plan. Without republishing the plan, I would like to check if an employee will be part of the plan, if the plan is republished.

There is a script TM_Diagnostics.sql, But it does not consider eligibility profile if eligibility profile is used in the Performance Management Plan.

When the PMP is republished, it includes employees are are not currently part of the plan but are eligible. There must be some pl/sql code which checks the eligibility of the person.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center