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

Need to Pull Final Approver on BI Report.

Received Response
edited Jul 6, 2023 1:42AM in Reporting and Analytics for SCM 1 comment


We have a request to pull the Final Approver on a BI Report.

The report has been built using SQL and is pulling from the fa_fusion_soainfra.wftask to get the next person to approve.  

When the user looks online at the requisition they can see the full approval tree to final approver.

Is there a way to create a SQL Data Model in BI Reporting to pull this same information?

Content (required):

The fa_fusion_soainfra.wftask will show the next person to approve, but not the full approval tree. Can a query to created to pull the full approval tree?

Howdy, Stranger!

Log In

To view full details, sign in.


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