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

amro alfares

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.

Deepak Anand

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.