Concurrent Requests performance history (per day)
                                                 Last update (2013-01-18 10:11:12)
                                                                                                                   Date added (2008-05-04 18:11:07)

SELECT /*+ index(r FND_CONCURRENT_REQUESTS_N6) */ 
TRUNC (actual_completion_date) "DATE", TO_CHAR (actual_completion_date, 'DAY') "DAY", p.concurrent_program_name,
p.user_concurrent_program_name description, COUNT (*) COUNT, 
DECODE (TRUNC (AVG (actual_completion_date - actual_start_date)), 0, NULL, TRUNC (AVG (actual_completion_date - actual_start_date)) || 
' Days' || ' + ') || TO_CHAR (TO_DATE(TRUNC(MOD(AVG(actual_completion_date - actual_start_date ), 1 ) * 86400 ), 'SSSSS'), 'HH24:MI:SS') "AVG TIME", 
DECODE (TRUNC (MAX (actual_completion_date - actual_start_date)), 0, NULL, TRUNC (MAX (actual_completion_date - actual_start_date)) || ' Days' || ' + ')
|| TO_CHAR (TO_DATE (TRUNC (  MOD (MAX (  actual_completion_date - actual_start_date ), 1 ) * 86400), 'SSSSS'), 'HH24:MI:SS') "MAX TIME", 
DECODE (TRUNC (MIN (actual_completion_date - actual_start_date)), 0, NULL, TRUNC (MIN (actual_completion_date - actual_start_date)) || ' Days' || ' + ')
|| TO_CHAR (TO_DATE (TRUNC (  MOD (MIN (  actual_completion_date - actual_start_date), 1) * 86400), 'SSSSS'), 'HH24:MI:SS') "MIN TIME" 
FROM applsys.fnd_concurrent_request_class c, applsys.fnd_application f, apps.fnd_concurrent_programs_vl p, applsys.fnd_concurrent_requests r
WHERE r.program_application_id = p.application_id
AND r.concurrent_program_id = p.concurrent_program_id
AND r.phase_code = 'C'                          
--AND r.status_code = 'C'
AND actual_completion_date BETWEEN TRUNC (SYSDATE) - 60 AND TRUNC(SYSDATE) + 1 --Last 60 days
--AND trunc(actual_completion_date) = trunc(SYSDATE)
AND p.application_id = f.application_id
AND r.program_application_id = f.application_id
AND r.request_class_application_id = c.application_id(+)
AND r.concurrent_request_class_id = c.request_class_id(+)
AND p.concurrent_program_name = 'XXOC_GL_ISOZ_PARENT_CC_BUDGET' 
GROUP BY c.request_class_name,
         p.concurrent_program_name,
         p.user_concurrent_program_name,
         TRUNC (actual_completion_date),
         TO_CHAR (actual_completion_date, 'DAY')
ORDER BY TRUNC (actual_completion_date) DESC, description;
Reviews
Filters
Search