Human Capital Management - EBS (MOSC)

MOSC Banner

HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP does not update EFFECTIVE_END_DATE.PER_ALL_ASSIGNMENTS_F

edited Sep 5, 2017 11:37AM in Human Capital Management - EBS (MOSC) 4 commentsAnswered ✓

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;

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