What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_s

Summary

What is the Relationship between fusion.hrc_txn_header, fusion.HRC_TXN_CONSOLE_ENTRY AND fa_fusion_soainfra.WFTASK?

Content

Can someone explain the relationship between the belwo 3 tables.

fusion.hrc_txn_header,

fusion.HRC_TXN_CONSOLE_ENTRY AND

fa_fusion_soainfra.WFTASK

We understand that fusion.hrc_txn_header and fusion.HRC_TXN_CONSOLE_ENTRY can be linked by TRANSACTION_ID.

And we can find the corresponding entry in both the tables.

But few cases, we could not find the respective entry for the same transaction in fa_fusion_soainfra.WFTASK table? (mapped by WFATASK.Identificationkey =  To_Char(hrc_txn_header .TRANSACTION_ID).