Transactions Tables are not storing Data for few Transactions

Summary:

Hi Team,

I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any data related to those process names called Time Change Request Approval.

Below are the tables names having issue:

1. fa_fusion_soainfra.wftask

2. fa_fusion_soainfra.wftaskhistory

The above tables are not showing any Approver Names for Time Change Request Approval transactions.

SQL Query User:

SELECT DISTINCT Wft.Identificationkey,

txnh.object

FROM 

fa_fusion_soainfra.wftaskhistory WFT,

Fusion.Hrc_Txn_Header Txnh

WHERE

1=1

AND txnh.object = 'HWM_TM_REC_CHANGE_REQS'

And TO_CHAR(Txnh.Transaction_Id) = Wft.Identificationkey(+)