Need HCM Cloud Approver Group Name and Subsequent Approver Group Members table names ...

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

Gianni Ceresa

Ok, then the Cloud Customer Connect forum should be the place to ask for it. (It's a parallel forum, same platform but independent from this one, therefore your question can't be moved, you will need to post it again in there.)

Sumanth V -Oracle

@User_N2N8H - From the description we see that the query is on Fusion Application and not OAS. Please confirm. Thanks.

ChannelDSYS

Unsure, i.e. why can then I find approval groups [ used in BPM ] for the SCM and FIN transactions, and not again the HCM ones. That is the real question here. Within the HCM task configuration, when you click "Approval Groups", you only see those that I have mentioned.

Any ideas ? Other questions in this forum regarding the same exact question, never had responses formulated.

Thx.

Arthur

Gianni Ceresa

Hi @User_N2N8H ,

What product are you using? Ideally the full name of the product (the tool you are working with, not the tool you try to extract the data from).

This is what Sumanth was trying to find out, because if your question is purely about Fusion data, then you are in the wrong forum (we can point you to the right one). That also explain why a number of these questions don't find an answer: not the right place.

If you are using Fusion Data Intelligence or OTBI, then we can move your question to the right category.

Thanks

ChannelDSYS

HCM Cloud. [ in the title also ] using BI and tables.

Thx.

Arthur

Gianni Ceresa

Ok, so you are inside your Fusion application and just doing things in there?

In that case you should go to https://community.oracle.com/customerconnect and look at the many categories about HCM and post in the one that seems to be closer to what you are working with (there should be one about reporting for HCM, but I can't access it, therefore no idea what is inside).

Or what do you mean by "using BI and tables"? (you can also post a screenshot of what you are working with and we can try to figure out of it's an Oracle Analytics product or still Fusion).

ChannelDSYS

Yes, this is the HCM cloud component of overall ERP cloud itself.

Thx.

Arthur