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: 2108
Registered: October 2003
Location: Hyderabad, India
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: opening error in oracle apps
Next Topic: Pricelist, Qualifier and Modifier
Goto Forum:

Current Time: Wed Aug 23 20:22:53 CDT 2017

Total time taken to generate the page: 0.04895 seconds