We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Oracle HCM Cloud How to Find an HCM Transaction's Approval Group and its associated Group Members
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