How to extract and update fusion approval groups via get API request or any other web services

Abdelrahman A. Hanafy

I am building a web application to be integrated with Oracle Fusion. One of the key data I need is the approval groups that are defined in the BPM worklist.
Is there a way to pull and post this data directly from the fusion?

Nathan CCC

Hi, have a look at using these tables/views

FA_FUSION_SOAINFRA.WFAPPROVALGROUPS

FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS

not sure if this data is exposed in an API or not

John Hung-Oracle

Hi Abdelrahman, I recommend that you post your question to one of the Integration forums to get the appropriate experts eyes on it. For example. Thank you
HCM Integrations

ERP Integrations and Extensions

Shyam Patel

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

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/74691#Comment_74691

Very helpful information.

Thank you very much for sharing, @Shyam Patel!

RVohra

@Shyam Patel, appreciate this sql in this forum. This forum was last updated in 2024. As per community guidelines, it will be best to avoid the comments in the old post.

Please feel free to share it in

Oracle Analytics and AI Sharing Center — Oracle