OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Query to Find Long Concurrent request in given time

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to Find Long Concurrent request in given time (R12,Linux,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query to Find Long Concurrent request in given time [message #543253]

Mon, 13 February 2012 14:50

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try on fnd_concurrent_requests.
You may be interested on the phase, status and submission date.

By
Vamsi

Report message to a moderator

Re: Query to Find Long Concurrent request in given time [message #543410 is a reply to message #543407]

Tue, 14 February 2012 11:39

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

Report message to a moderator

Re: Query to Find Long Concurrent request in given time [message #543422 is a reply to message #543410]

Tue, 14 February 2012 12:10

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 14:07:41 CST 2024