Thursday, May 8, 2008

View Concurrent Requests Submitted by Others

So many of the processes that we create are submitted via concurrent request in Oracle E-Business Suite. In order to see the result of the process is we can look at the output and log files. However, by default, those files are only visible to the individual user that submitted the request.

We do have the ability to see requests submitted by others. Using the "Find Requests" functionality, I can enter a name in the "Requestor" field to find requests submitted by others. However, all I can see is what program was submitted, when, and with what parameters. I cannot, however, see the output or log files associated with that request. So, how can I view the output and log files without logging in as the user that submitted the request or looking at the screen of the submitter?

The level of access to concurrent request outputs is controlled by the profile option Concurrent:Report Access Level. By default, the value of this profile option is set to "User", which means that the output and log files are only viewable by the submitter. However, the value of this profile option can be set to "Responsibility" as well. When this is the case, the concurrent request output and log files are visible via the responsibility from which the request was submitted.

For example, if Bob submits a concurrent request using the "Customer Support" responsibility, I can view the output and log files for Bob's concurrent request if I am using the "Customer Support" responsibility. Unfortunately, if I attempt to view output and/or log files for the same request using the "System Administrator" responsibility, I will not be allowed to view the output and log files, even though I have the "Customer Support" responsibility assigned to me. So, the limitation is that you must view the concurrent request output and log files from the same responsibility that the concurrent request was submitted from.

Another Oracle Blog?

Welcome to OracleNotions! This blog will discuss all things Oracle. Mostly, it will serve as a repository for easy-to-forget tidbits, discussion and examples of features and pretty much anything else Oracle-related.

My name is Mike. I am a Software Engineer, developing and supporting an Oracle E-Business Suite environment. I have been exposed to pretty much every technology utilized and supported under the EBS architecture in my 2+ years working with my current team.

One of my goals is to use this blog as a repository for things that I learn along the way. I have all kinds of notes and bookmarks to other sites about Oracle-related topics that I've looked up in the past, but it would be really nice to have all of that information in one place. Plus, I can give further elaboration, provide analysis, etc.

But this is not just for my own reference. I hope that the members of my team will also use this as a place to find knowledge that I've gained that will help them. Or to share knowledge with me that I don't have yet.

That being said, I will probably not be the only poster on this blog. I hope to get my teammates involved as well.

Feel free to post in the comments section. Let me know if you have questions, comments, or suggestions for posts. I will do what I can... but I do stil have a day job.