Resolving Legal Employer Hire Date Change Issue for a Line Manager with Direct Reportees

The issue arises when attempting to change the legal employer hire date of a line manager from 1st February 2021 to 1st January 2021 in Oracle HCM. The system throws an error:

"You can’t select this date because some assignments in the work relationship are used in a manager relationship. Remove the manager relationship to continue. (PER-1531839)"

This occurs because the employee is a line manager with direct reportees, and their assignments are linked in the system.

Solution/Workaround:

1. Reassign Direct Reportees:

   • Identify all direct reportees under the line manager.
   • Reassign these reportees to a different line manager, ensuring the reassignment happens on the same date they were originally assigned.

2. Change the Legal Employer Hire Date:

   • Once all direct reportees have been reassigned, proceed with modifying the hire date of the line manager.

3. SQL Query to Identify Manager and Direct Reportees:
   The following SQL query helps retrieve the manager and their direct reportees:

   SELECT papf_Reportee.person_number,
          TO_CHAR(pasf.EFFECTIVE_START_DATE, 'yyyy/dd/mm') start_dt_spr
   FROM per_all_people_f papf,
        per_All_assignments_m paam,
        PER_ASSIGNMENT_SUPERVISORS_F pasf,
        per_all_people_F papf_reportee
   WHERE papf.person_id = paam.person_id
     AND paam.assignment_id = pasf.MANAGER_ASSIGNMENT_ID
     AND papf.person_number = '90035914' -- Supervisor Number
     AND SYSDATE BETWEEN TRUNC(papf.effective_start_Date) AND TRUNC(papf.effective_End_Date)
     AND SYSDATE BETWEEN TRUNC(paam.effective_start_Date) AND TRUNC(paam.effective_End_Date)
     AND papf_Reportee.person_id = pasf.PERSON_ID
     AND SYSDATE BETWEEN TRUNC(papf_Reportee.effective_start_Date) AND TRUNC(papf_Reportee.effective_End_Date)

    

   By following this approach, the legal employer hire date can be successfully changed while maintaining system integrity.

    

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.