Unable to get the movement request completed notifications for any specific user

Summary:

Business requires the extract of the Movement request which was completed for any specific users.

We have checked the completed tasks in the below table but unable to find it. Please suggest.

select * from fa_fusion_soainfra.wftask
where 1=1 --TASKDEFINITIONNAME in ('MovementRequestApprovalTask')
and APPROVERS like '%SPECIFIC USER%'

Could you please check the below tables and confirm us, how long oracle will retain the completed notifications?

select * from fa_fusion_soainfra.wftask
select * from fa_fusion_soainfra.wftaskhistory

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):