How to use FND Archive tables to get all HCM Transaction details of Workflow

Summary

Need to report, both active , recent completed and histroical Workflow transaction details.

Content

Hi

 

I am currently using this tables to get Active and recently completed workflow transaction details.

        fa_fusion_soainfra.wftask wt,
         hrc_txn_header txh,
         hrc_txn_data txd,

But looks like this tables get purged and data is archived into bpm archive tables for all auditing and historical purposes.

FND_BPM_TASK_VL

FND_BPM_TASK_HISTORY

FND_BPM_TASK_ASSIGNEE

FND_BPM_TASK_COMMENT

FND_BPM_TASK_ATTACHMENT

 

 

 

How can i use above tables to get transaction details of all historical/Archived workflows ?

Is it even possible to do BI report on this tables, how should the joins work.