Assign your employees supervisors that are missing supervisors.
select fnd.user_name, fnd.description, ppf.full_name, job.name
from fnd_user fnd,
where fnd.employee_id(+) = ppf.person_id
and paf.person_id = ppf.person_id
and job.job_id = paf.job_id
and paf.supervisor_id is null
and sysdate between ppf.effective_start_date and ppf.effective_end_date
and sysdate between paf.effective_start_date and paf.effective_end_date
what is the mean of : Position 107955 under superior 107898 not assigned
is 107955 the position ? then what the means of superior 107898?
how to apply in this query ?
You have to go into the HRMS module, query up the full name of the employees missing a supervisor, determine who their supervisor should be and populate the supervisor on their assignment form and save. Do it for all employees returned by the query.
Dear Mdtaylor and Sanjay,
Thanks for the answer.
i'll try this day.
i hope it's solving my problems.