Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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(+)
0