FA_FUSION_SOAINFRA

SQL Query to Fetch BPM Approval Groups Information

by Shailender Thallam
June 27, 2020June 27, 2020

/******************************************************************* *PURPOSE: SQL Query to extract BPM Approval Groups Information * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT fwg.approvalgroupid ,fwg.approvalgroupname, fwgm.member, fwgm.type, fwgm.sequence FROM fa_fusion_soainfra.wfapprovalgroups fwg,… Read More »SQL Query to Fetch BPM Approval Groups Information

SQL Query to Fetch BPM Tasks Information

by Shailender Thallam
June 27, 2020June 27, 2020

We can use tables of FUSION_RUNTIME which stores information of BPM tasks for couple of months or until they are purged. Note: Oracle has granted… Read More »SQL Query to Fetch BPM Tasks Information