How to find parameter values of a concurrent request?
I'm extracting concurrent requests details run by a specific user on a given date. While I'm able to extract most details, I face some challenge in getting the parameter values.
For e.g. assume a concurrent program which takes a payroll name or employee name as a parameter. The fnd_concurrent_requests stores only the internal ids of these values in the argument_text or argument1, etc. fields.
A payroll named 'ABC' will be stored as 123 in argument1 and so on...
The problem is we have a lot of concurrent requests run by a particular user and we need all requests' details along with its parameter (display) values. This doesn't look as easy as it sounds?! Any suggestions would be great.