HCM Extract not giving output as expected.

Summary

HCM Extract not giving output as expected.

Content

Hi All,

For employee code: 22688, transfer was done in the system on 5th Sep-19.
In the output data of 6th Sep-19 we are getting incorrect data, we are getting Manager code '24003' insted of '20600'.

Please find the below Fast Formula we are using in this Extract to get the Manager code for the current employee's and the terminated employee's

DEFAULT FOR PER_ASG_MGR_PERSON_NUMBER is ' '
DEFAULT FOR PER_ASG_REL_ACTUAL_TERMINATION_DATE is '4712/12/31 00:00:00' (DATE)

l_term_date = PER_ASG_REL_ACTUAL_TERMINATION_DATE