Query Absence Pending Transactions
Content
Hello experts.
I'm trying without success to create a report that gives me the history of transactions.
Category - Status - to whom - initiated at - Approver (Assigned to) - finshed at - error
absence - PENDING - USER_A - 2021/1/01 - USER B - X - NO ERROR
Also would be nice to have the history of the completed ones.
Using the following tables without success:
Fusion.Hrc_Txn_Header Txnh,
Fusion.Hrc_Txn_Data Txnd,
fa_fusion_soainfra.wftask wft, - it loses data after 3 months doue to archive and purge
fusion.hrc_txn_error txne - bringing nothing