| Request Set Details [message #278185] |
Fri, 02 November 2007 05:37  |
bholaimmu
Messages: 35
Registered: October 2007
|
Member |
|
|
Hi,
How can we find how many REQUEST SETS have been run in the application in the last 24 hours and those REQUEST SETS details also.
With concurrent_program_id, we can connect to fnd_concurrent_programs but with request_set_id how can we connect to fnd_concurrent_programs to get the logfile and outfile details for the request set.
Thx a Lot,
Immu.
[Updated on: Fri, 02 November 2007 06:21] Report message to a moderator |
|
|
|
| Re: Request Set Details [message #278245 is a reply to message #278185] |
Fri, 02 November 2007 09:20  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
fnd_request_set_programs is the one, which links concurrent_program_id and request_set_id.
But what you are going to do with this? There is a chance that the specific programs can be submitted standalone.
For request set, you will be having a particular concurrent program id| Quote: |
select concurrent_program_id
from fnd_concurrent_programs_vl
where user_concurrent_program_name = 'Report Set';
|
I think argument2 is the request_set_id.
Now you can search the request_id's in fnd_concurrent_requests for the above concurrent_program_id and having the argument2 as the request_set_id.
Also the requests which are having the priority_request_id as the above request_id's
By
vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
