You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL or tables for Resignation Workflow Approver history

Received Response


Resignation Workflow Approver history

Content (required):

Hi all,

I need to pull our the workflow details of Resignation workflow in BI. So please let me know from which tables to pull required data. I have checked that the data is populated in below tables when I initiated a resignation transaction.

hrc_txn_header, hrc_txn_data, fa_fusion_soainfra.wftask, fa_fusion_soainfra.wftaskhistory

But I can see a lot of data in hrc_txn_header for which there is no data in wftask/wftaskhistory table. I have read that data gets archived after a few days.

Please let me know if above tables are the right place to look for the data and which other tables should I check for all the old resignation transaction/approvals data also.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!