garden3.jpg

Concurrent programs run within last 24 hours


Lookup Oracle Financials Concurrent requests by date

– This displays concurrent programs run within last 24 hours excluding sysadmin.
– Bobby A.
– 17-Mar-07
– con_prg_last_24hours.sql

Concurrent programs run within for last 24 hours excluding sysadmin.

idbasolutions.com Apr 2008

set linesize 130
column PROGRAM format a37
column REQUESTOR format a15
column duration format a15

select REQUEST_ID,REQUESTOR,
to_char(ACTUAL_START_DATE,’hh24:mi dd-mon-yy’) started,
to_char(ACTUAL_COMPLETION_DATE,’hh24:mi dd-mon-yy’) completed,
to_char(((((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24*60*60)/60)/60),’99D99′) duration,
PROGRAM
from FND_CONC_REQ_SUMMARY_V,dual
where PHASE_CODE=’C’
and REQUESTOR <> ‘SYSADMIN’
and to_date(ACTUAL_COMPLETION_DATE) between to_date(sysdate-1) and to_date(SYSDATE)
order by 5 desc

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com