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

ChannelDSYS

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

Mallikarjuna Kuppauru-Oracle

Hi @ChannelDSYS

Questions is more on Application end, Below is the correct forum to post the fusion questions.

Fusions covered in a parallel forum (the question can't be moved there):

https://community.oracle.com/customerconnect

Regards,

Arjun