Transactions Tables are not storing Data for few Transactions
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:
The above tables are not showing any Approver Names for Time Change Request Approval transactions.
SQL Query User:
SELECT DISTINCT Wft.Identificationkey,
AND txnh.object = 'HWM_TM_REC_CHANGE_REQS'
And TO_CHAR(Txnh.Transaction_Id) = Wft.Identificationkey(+)