Requisition Approval Audit

I'm assuming you're running requisition self-service (RSS). If you're not, then you are totally out of luck.
If you are, though, there are a couple of options that come to mind:
- Using Crystal or Access or any SQL reporting tool, you can join from the WF tables to the RQ tables and back to the LOGAN tables to generate fairly powerful and comprehensive reports.
- You could also capture this information in the .flo, and do something useful with it...like send an email to an alias that puts the data into a database!

When you upgrade to LSF9 and if you have ProcessFlow Integrator, you have a whole lot more flexibility. In particular, you have the ablility to capture this type of info, and then--using SQL--update custom database tables, etc.

Thanks, but looks like "...we are out of luck.." we use the webreq feature, but not RSS. Trying to get us up on it, but something always pushes it back...LBI, LSF Smart Recon, MSCM, etc
One day!
Thanks for the info, I will keep it for future reference.

Are you using ProcessFlow to do the approvals?

Nope. That's another thing on our list. (It's a LONG list!)

The WFMETRICS file is woth a look.

No process flow...

Sorry, just got your last post. So you're using Approval Codes (RQ12, RQ13)?

One fairly simple modification would be to create a custom audit table and update it with metrics from an RQ12 user exit. I've done a similar type of modification for other modules which don't have sufficient audit trails. Not sure how the development/maintenance cost/effort compares to implementing ProcessFlow-based approval and then using WFMETRICS to get the info.

Yep, actually through Web Approvals piece of WebReq.
Yeah, process flow is the way to go. I didn't know about the wf source way to go. Will remember when we do. Planning on LSF9 migration in the next couple months with some basic flow stuff, then more into it. (I hope)