Home » Applications » Oracle Fusion Apps & E-Business Suite » Request Set Details
Request Set Details [message #278185] Fri, 02 November 2007 05:37 Go to next message
Messages: 35
Registered: October 2007

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,

[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 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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

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

Previous Topic: Pricelist, Qualifier and Modifier
Next Topic: 'FRM-40202: Field must be entered' when scrolling past sickness absence in core
Goto Forum:

Current Time: Tue Mar 28 12:48:44 CDT 2017

Total time taken to generate the page: 0.08774 seconds