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

Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORY

Received Response
19
Views
4
Comments
edited Jun 8, 2021 11:13AM in Reporting and Analytics for ERP 4 comments

Content

Hi,

We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORY, where in we are getting the data stored individually without any primary/foreign key. We got one ROOT_TASK_ID from WFTASKHISTORY, but it is not unique in WFCOMMENTS table.

Is there any another table which can provide the missing link between the two tables?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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