Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Elliot Hall-Walker
    Query for Approval Delegation
    Topic posted August 21, 2019 by Elliot Hall-Walker, tagged BI Publisher, Fusion Financial reporting, OBIEE Answers, OTBI, Reports 
    61 Views, 2 Comments
    Title:
    Query for Approval Delegation
    Content:

    Hello,

    I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this information is in the Oracle tables?

    Note: I am not looking for role delegation (PER_DELEGATED_ROLES), I am looking for the approvals only

    Thanks in advance,

    Elliot 

    Version:
    Fusion

    Comment

     

    • Ruchir Nema

      Hi Elliot,

      Each approval even with a delegation would be raising an event and the information will be stored in the workflow tables or its history table. Below are the details.

      Table are different for different entities. If they are setup using BPM then it would be stored in the below tables

      fa_fusion_soainfra.wftaskhistory ,
      fa_fusion_soainfra.wfcomments

      The above table holds data for your approval delegation for GL and PO.

      for AP Approval Delegations - ap_inv_aprvl_hist_all would be the table that will provide you the information. .

      I am attaching sample queries for you that can help you build these BIP reports. Please have a look at them.

      Regards,

      RN