24B: BIP - What is the subject area or tables to get transaction approvers from Learning?

Question

Please provide the subject area or an SQL tables to retrieve transaction approvers from the Learning module (24B).

I have tried using this one, but it doesn't return any results.

select wft.*

from

Fusion.hrc_txn_header txnh

, Fusion.hrc_txn_data txnd

, FA_FUSION_SOAINFRA.wftask wft

, fusion.hrc_txn_error txne

, Fusion.per_all_people_f p

Where Txnh.Transaction_Id = Txnd.Transaction_Id

and txnh.transaction_id = txne.transaction_id(+)

And To_Char(Txnh.Transaction_Id) = Wft.Identificationkey(+)

And Txnh.subject_id = p.person_id(+)

And Txnh.Transaction_Id in (300000060123719)

Rajesh L-Oracle · Answer

Hi User_GQGBJ,

Thank you for visiting and posting in OBIA Product Community Page.

This forum is for OBIA product and looks like your question is for Fusion Applications HCM BIP.

Please note that this Question is for Fusion Apps HCM BIP team and it is managed in our sister community, which can be found at the below links:

Oracle Fusion Cloud Customer Connect (  https://community.oracle.com/customerconnect ).

Please make a note of the above URL and visit those Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

Thank you,