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

Monitor Process details using SQL - can't find Process 'Name'

Received Response
46
Views
2
Comments
edited Feb 26, 2020 8:28AM in Reporting and Analytics for ERP 2 comments

Summary

Reports & Analytics - Process Requests

Content

Hi

Have scripted the process requests to include all parameter details into an audit report but am unable to a link to the process name. For example, the Metadata Name holds a value of 'APXIAWRE' but I can't find the join to it's Name of 'Initiate Invoice Approval Workflow'.

I found the at fusion.ess_request_history.NAME holds some values but not all and couldn't find a reference to it in fusion.ess_request_property.

Have attached a screenprint of the fields in question along with my amateur script and would appreciate a steer to the answer, please.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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