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?
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
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
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
Very helpful information.
Thank you very much for sharing, @Shyam Patel!
@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
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
