DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Wednesday, March 23, 2016

Query to check the Average ran time of a Concurrent Request from FND history backup table.

select DESCRIPTION, request_id, request_date, phase_code, status_code, requested_start_date, 
actual_start_date, actual_completion_date,ROUND(((nvl(actual_completion_date,sysdate) -actual_start_date) * 1440)/60,2)   "Runtime (in hours)"  ,
argument_text from apps.fnd_conc_req_history 
DESCRIPTION in ('&program_name')
and actual_start_date between to_date('21-04-2015 00:00:00','DD-MM-YYYY HH24:MI:SS')
and to_date('22-04-2015 23:59:59','DD-MM-YYYY HH24:MI:SS')
order by request_date desc

The above script will show the average running time of a particular request using backup table. If backup table for FND concurrent requests are available, Please edit it using your table name.

No comments: