OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job Offer — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!