Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to extract the information of fusion approval groups via report or web-service

375
Views
2
Comments
amro alfares
amro alfares Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

Summary

read approval groups information and extract to be used outside SaaS

Content

We have managed to develop approval groups in SaaS like the attached document, And since we are developing a PaaS extension We need to check the do-ability of reading such information and extract it in PaaS, reading the approval groups in some sort of a BI report or if there is any web-service available to allow me to read the Approval group from outside the fusion.
I attached a document on how to define the approval group on SaaS.
 
Your support is highly appreciated.
Tagged:

Comments

  • Deepak Anand
    Deepak Anand Rank 1 - Community Starter

    You can create simple BI report using below tables.

    select a.approvalgroupname, b.member
    from FA_FUSION_SOAINFRA.WFAPPROVALGROUPS a, FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS b
    where a.approvalgroupid=b.approvalgroupid

    You can then call ERP Integration webservice to extract data into your PaaS solution.

  • Shyam Patel
    Shyam Patel Rank 3 - Community Apprentice

    SQL Query to get the Approval Workflow Details

    SELECT
    fwg.approvalgroupid AS "Group ID",
    fwg.approvalgroupname AS "Group Name",
    fwgm.member AS "Member Name (User or Group)",
    fwgm.type AS "Member Type (USER or GROUP)",
    fwgm.sequence AS "Sequence (for serial routing)"
    FROM
    fa_fusion_soainfra.wfapprovalgroups fwg
    INNER JOIN fa_fusion_soainfra.wfapprovalgroupmembers fwgm
    ON fwg.approvalgroupid = fwgm.approvalgroupid
    WHERE 1 = 1
    ORDER BY
    fwg.approvalgroupid,
    fwgm.sequence