Sunday, 17 April 2016





Find The Maximum run time of a concurrent request in a 

particular day using FND History 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 
where 
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


Note : Change the Actual start date and to_date based on your requirement

No comments:

Post a Comment