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

Effective end date in PER_MANAGER_HRCHY_DN not updated

Summary:

When does effective_end_date in PER_MANAGER_HRCHY_DN gets populated? We are assuming that when an employee is no longer reporting to a manager then effective_end_date in this table will be updated with end date details. Is this correct?

I am running below query to get all the direct/indirect reportee currently under this manager as of SYSDATE but the below query is returning the details of previous team members who are no longer reporting to this manager.

SELECT person_idFROM PER_MANAGER_HRCHY_DN pmhd
where pmhd.manager_id = hrc_session_util.get_user_personid

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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