Reports 2017-11-18T12:27:27+00:00

FND Concurrent Requests Summary

Description
Categories: Application, Enginatics
Concurrent programs sorted by the sum of their historic execution times

select
x.user_concurrent_program_name program,
x.description,
x.concurrent_program_name short_name,
x.executable_name,
xxen_util.meaning(x.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method,
x.execution_file_name,
&col_argument2
x.executions,
x.distinct_users,
xxen_util.time(x.min_seconds) min_time,
xxen_util.time(x.max_seconds) max_time,
xxen_util.time(x.avg_seconds) avg_time,
xxen_util.time(x.sum_seconds) sum_time,
x.min_seconds,
x.max_seconds,
x.avg_seconds,
x.sum_seconds
&time_percentage
from
(
select distinct
fcpt.user_concurrent_program_name,
fcr.description_ description,
fcp.concurrent_program_name,
fe.executable_name,
fe.execution_method_code,
fe.execution_file_name,
&col_argument
count(*) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name) executions,
count(distinct fcr.requested_by) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) distinct_users,
round(86400*min(nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument),2) min_seconds,
round(86400*max(nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument),2) max_seconds,
round(86400*avg(nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument),2) avg_seconds,
round(86400*sum(nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) over (partition by fcpt.user_concurrent_program_name,fcr.description_,fcp.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument),2) sum_seconds
from
(select regexp_replace(fcr.description,'\d+', '%') description_, fcr.* from fnd_concurrent_requests fcr) fcr,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_user fu,
fnd_executables fe
where
1=1 and
fcr.has_sub_request='N' and
fcr.actual_completion_date is not null and
fcr.requested_by=fu.user_id and
fcr.concurrent_program_id=fcpt.concurrent_program_id and
fcr.concurrent_program_id=fcp.concurrent_program_id and
fcr.program_application_id=fcpt.application_id and
fcpt.language=userenv('lang') and
fcp.executable_application_id=fe.application_id and
fcp.executable_id=fe.executable_id
) x
order by
x.sum_seconds desc

Parameter Name SQL text Validation
Started within Days
fcr.actual_start_date>sysdate-:days
Number
Running from Date
fcr.actual_completion_date>=:from_date
Date
Running to Date
fcr.actual_start_date<:to_date+1
Date
Program Name
fcpt.user_concurrent_program_name like :program_name
LOV
System Program Name
fcp.concurrent_program_name like :system_program_name
LOV
Executable Short Name
(fcr.concurrent_program_id,fcr.program_application_id) in (
select
fcp0.concurrent_program_id,
fcp0.application_id
from
fnd_executables fe,
fnd_concurrent_programs fcp0
where
fe.executable_name=:executable_name and
fe.application_id=fcp0.executable_application_id and
fe.executable_id=fcp0.executable_id
)
LOV
Execution Method
(fcr.concurrent_program_id,fcr.program_application_id) in
(
select
fcp.concurrent_program_id,fcp.application_id
from
fnd_concurrent_programs fcp,
fnd_executables fe,
fnd_lookup_values flv
where
flv.meaning=:execution_method and
fcp.executable_application_id=fe.application_id and
fcp.executable_id=fe.executable_id and
fe.execution_method_code=flv.lookup_code and
flv.lookup_type='CP_EXECUTION_METHOD_CODE' and
flv.language(+)=userenv('lang') and
flv.view_application_id=0 and
flv.security_group_id=0
)
LOV
Show Argument Text
regexp_replace(fcr.argument_text,'\d+', '%') argument_text,
LOV
Started within Days
,round(100*x.sum_seconds/:days/86400,2) time_percentage
Show Argument Text
x.argument_text,
Show Argument Text
,regexp_replace(fcr.argument_text,'\d+','%')