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
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
