Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle HCM Cloud How to Find an HCM Transaction's Approval Group and its associated Group Members

22
Views
1
Comments

Hi.

I am trying to obtain/find the tables that are in place and that store the approver groups and approver members which are linked to each approver group, used for HCM like transactions which flow into BPM workflows. I have also gone into the HCM Task Configuration UI, but even in there I can not find how approvers get linked into individual transactional workflows.

I have found two tables up to this point inside of the ERP cloud DB, but these tables do not seem to not represent any data associated with HCM, but only with let's say AP, PO and Financials, thus the reason for my question.

Tables found:

fa_fusion_soainfra.wfapprovalgroups - BPM approval groups

fa_fusion_soainfra.wfapprovalgroupmembers - BPM approval group members

I also need to determine how to link the HCM transaction itself, i.e. salary change, etc… to its approval group name; at this time I can pinpoint these transactions using the WFTASK and WFTASKHISTORY tables.

Thanks in advance for your assistance.

Arthur

Comments