Oracle Business Intelligence Applications

Home› Oracle Analytics› Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Received Response
31
Views
1
Comments
Nipon
Nipon ✭
in Oracle Business Intelligence Applications

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)

Tagged:

Answers

  • Rajesh L-Oracle
    Rajesh L-Oracle mod

    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,