Oracle Fusion HCM Analytics

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

HCM Cloud Workflow Approver Group and Approver Member Tables

Received Response
61
Views
4
Comments

Hi.

Would someone be able to tell me please which tables in the ERP DB represent HCM approver groups and HCM approver members, that are used within HCM/BPM transactional workflows, i.e. salary changes, bonus allocations, etc … [ under the Transaction Console menu item ]

I have found these approver and approver member tables → fa_fusion_soainfra.wfapprovalgroups and fa_fusion_soainfra.wfapprovalgroupmembers
but they seem to contain information which is only relevant to the financial and supply chain areas.

What I need to be able to do overall is determine based upon which transaction is in play, its corresponding set of approvers.

Thanks in advance.

Arthur

Answers