HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP does not update EFFECTIVE_END_DATE.PER_ALL_ASSIGNMENTS_F
Hi, in relation to my previous question, we're doing a mass update of Final Process Dates using the API HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP.
However, one thing we noticed is that once we've ran the API, PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE is not being updated with the new Final Process Date.
Take the sample below:
Query 1: Ex-Employee X has the below data in PER_ALL_PEOPLE_F:
SELECT PAAF.PERSON_ID, PAAF.EFFECTIVE_START_DATE, PAAF.EFFECTIVE_END_DATE, PAAF.NATIONAL_IDENTIFIER, PTT.USER_PERSON_TYPEFROM PER_ALL_PEOPLE_F PAAF , PER_PERSON_TYPES PTT WHERE PAAF.PERSON_TYPE_ID = PTT.PERSON_TYPE_IDAND PAAF.EMPLOYEE_NUMBER = '3378777'ORDER BY PAAF.EFFECTIVE_END_DATE;