Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to Find Long Concurrent request in given time (R12,Linux,)
icon9.gif  Query to Find Long Concurrent request in given time [message #543253] Mon, 13 February 2012 14:50 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi

I need a query which gives me long running concurrent request over a period of time

OR

is it possible to find it for last 7 days

thanks in advance

Cheers

[Updated on: Mon, 13 February 2012 14:56]

Report message to a moderator

Re: Query to Find Long Concurrent request in given time [message #543407 is a reply to message #543253] Tue, 14 February 2012 11:11 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try on fnd_concurrent_requests.
You may be interested on the phase, status and submission date.

By
Vamsi
Re: Query to Find Long Concurrent request in given time [message #543410 is a reply to message #543407] Tue, 14 February 2012 11:39 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi
thanks
but i want to know who submitted it and whats the request ID and whats the start date and end date

CHeers
Re: Query to Find Long Concurrent request in given time [message #543422 is a reply to message #543410] Tue, 14 February 2012 12:10 Go to previous message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Did you get a chance to describe the table fnd_concurrent_requests?
(Or) Checked etrm?
http://etrm.oracle.com/pls/etrm/etrm_pnav.show_object?c_name=FND_CONCURRENT_REQUESTS&c_owner=APPLSYS&c_type=TABLE

By
Vamsi
Previous Topic: COGS Revenue Matching Report's "Yes" version's deferred COGS not tied with "No"
Next Topic: how to approach above task
Goto Forum:
  


Current Time: Fri Jul 25 04:22:02 CDT 2014

Total time taken to generate the page: 0.25716 seconds