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
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 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
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
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: Thu Dec 08 04:26:10 CST 2016

Total time taken to generate the page: 0.11102 seconds