Oracle EBS HCM: APIS1) hr_ex_employee_api.actual_termination_emp - This API terminates an employee.
Two records has created in per_all_people_f one with current_employee_flag as 'Y' and with 'Null'
Ans:US Super HRMS Manager (or comparable responsibility) > Enter and Maintain (Form)> Others(button) >End Employment.
This will show if you properly updated the termination dates including final process, last standard process and actual. It will also show you the leaving reason.
If you want to look it up in the table, the table is per_periods_of_service. It's just an update to insert the data.
Once you update the final process date, the assignment record (per_all_assignments_f) will insert at least 1 row (a terminated record) and modify 1 row (to update the effective end date of the existing record).
It will insert a 'terminated' assignment record if your dates do not match.
The way to check this in the app is: US Super HRMS Manager (or comparable responsibility) > Enter and Maintain (Form)>Assignments (button).