OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job Offer
Summary:
Need Query Transaction Console Approver Name for Job Requisition & Job Offer
i have tried this query
select htce.object_name, htce.task_id task_id_hdr, htce.console_txn_status, htce.status_category, htce.task_approvers,dt.ATTRIBUTE8 recruiter, dt.ATTRIBUTE2 hiring_manager, hdr.*
from
HRC_TXN_CONSOLE_ENTRY HTCE,
HRC_TXN_HEADER HDR,
HRC_TXN_DATA dt
--FA_FUSION_SOAINFRA.WFTASK wtask
where 1=1
and HTCE.PROCESS_CATEGORY like '%Approve Job Requisition%'
and HDR.transaction_id = htce.transaction_id
and HDR.transaction_id = dt.transaction_id
--and to_char(wtask.identificationkey) = to_char(HDR.transaction_id)
i have read somewhere in the community and found that you can get the approver name from FA_FUSION_SOAINFRA.WFTASK and join the identificationkey to transaction_id, but i've got no result.