How would I be able to find the active concurrent requests from Oracle Database, Remember I need SQL, I dont want to do it through Oracle Apps
Everywhere I looked keeps history, I dont want history how do i find the current scheduled requests
please run the following sql
select * from fnd_concurrent_request where status_code = 'R'
It will display running concurrent request.
select * from fnd_concurrent_request where status_code ='P'
and phast_code = 'I'
it will display scheduled concurrent requests.
If you want script please reply me i will sent detail scripts.
Click Here to Expand Forum to Full Width