ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDED979D2E0530100007F1FF2 FND Concurrent Execution Method Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_EXECUTION_METHOD_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDE9179D2E0530100007F1FF2 FND Concurrent Program Name (wildcard) select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name US 8E2FF36EDEAD79D2E0530100007F1FF2 FND Executable Short Name Y select fev.executable_name value, fav.application_name||': '||case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id and (:$flex$.FND_Concurrent_Execution_Method is null or xxen_util.contains(:$flex$.FND_Concurrent_Execution_Method,xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0))='Y') order by fev.executable_name US 8E2FF36EDEA479D2E0530100007F1FF2 FND System Concurrent Program Name Y select fcpv.concurrent_program_name value, fcpv.description from fnd_concurrent_programs_vl fcpv order by fcpv.concurrent_program_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8038B08ACE0530100007FEB91Y 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.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, xxen_util.time(x.avg_wait_seconds) avg_wait_time, xxen_util.time(x.sum_wait_seconds) sum_wait_time, xxen_util.time(x.avg_non_conflict_wait_seconds) avg_non_conflict_wait_time, xxen_util.time(x.sum_non_conflict_wait_seconds) sum_non_conflict_wait_time, xxen_util.time(x.avg_conflict_wait_seconds) avg_conflict_wait_time, xxen_util.time(x.sum_conflict_wait_seconds) sum_conflict_wait_time, x.min_seconds, x.max_seconds, x.avg_seconds, x.sum_seconds, x.avg_wait_seconds, x.sum_wait_seconds, x.avg_non_conflict_wait_seconds, x.sum_non_conflict_wait_seconds, x.avg_conflict_wait_seconds, x.sum_conflict_wait_seconds, xxen_util.client_time(x.first_run_date) first_run_date, xxen_util.client_time(x.last_run_date) last_run_date, xxen_util.user_name(x.last_user) last_user, x.last_responsibility, x.execution_method_code, x.total_users &time_percentage from ( select distinct fcpv.user_concurrent_program_name, fcr.description_ description, fcpv.concurrent_program_name, fe.executable_name, fe.execution_method_code, fe.execution_file_name, &col_argument count(*) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name) executions, count(distinct fcr.requested_by) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) users, min(fcr.seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) min_seconds, max(fcr.seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) max_seconds, avg(fcr.seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) avg_seconds, sum(fcr.seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) sum_seconds, avg(fcr.wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) avg_wait_seconds, sum(fcr.wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) sum_wait_seconds, avg(fcr.non_conflict_wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) avg_non_conflict_wait_seconds, sum(fcr.non_conflict_wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) sum_non_conflict_wait_seconds, avg(fcr.conflict_wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) avg_conflict_wait_seconds, sum(fcr.conflict_wait_seconds) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) sum_conflict_wait_seconds, min(fcr.actual_start_date) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) first_run_date, max(fcr.actual_start_date) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) last_run_date, max(fcr.requested_by) keep (dense_rank last order by fcr.actual_start_date, fcr.request_id) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) last_user, max(frv.responsibility_name) keep (dense_rank last order by fcr.actual_start_date, fcr.request_id) over (partition by fcpv.user_concurrent_program_name,fcr.description_,fcpv.concurrent_program_name,fe.executable_name,fe.execution_file_name &partition_argument) last_responsibility, count(distinct fcr.requested_by) over () total_users from ( select 86400*greatest(0,nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) seconds, 86400*greatest(0,nvl(fcr.actual_start_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' then sysdate end)-greatest(fcr.request_date,fcr.requested_start_date)) wait_seconds, 86400*greatest(0,nvl(fcr.actual_start_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' then sysdate end)-nvl(nvl(fcr.crm_release_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' and fcr.status_code='Q' and fcr.crm_tstmp is not null then sysdate end),greatest(fcr.request_date,fcr.requested_start_date))) non_conflict_wait_seconds, 86400*greatest(0,nvl(fcr.crm_release_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' and fcr.status_code='Q' and fcr.crm_tstmp is not null then sysdate end)-greatest(fcr.request_date,fcr.requested_start_date)) conflict_wait_seconds, regexp_replace(fcr.description,'\d+', '%') description_, fcr.* from fnd_concurrent_requests fcr ) fcr, fnd_concurrent_programs_vl fcpv, fnd_user fu, fnd_executables fe, fnd_responsibility_vl frv where 1=1 and fcr.actual_completion_date is not null and fcr.requested_by=fu.user_id and fcr.concurrent_program_id=fcpv.concurrent_program_id and fcpv.executable_application_id=fe.application_id and fcpv.executable_id=fe.executable_id and fcr.responsibility_application_id=frv.application_id(+) and fcr.responsibility_id=frv.responsibility_id(+) ) x order by x.executions desc, x.sum_seconds desc #,##0 AR FND Concurrent Requests Summary البرامج المتزامنة مرتبة حسب مجموع أوقات التنفيذ التاريخية D FND Concurrent Requests Summary Gleichzeitige Programme sortiert nach der Summe ihrer historischen Ausführungszeiten E FND Concurrent Requests Summary Programas concurrentes ordenados por la suma de sus tiempos históricos de ejecución F FND Concurrent Requests Summary Programmes simultanés triés par la somme de leurs temps d'exécution historiques I FND Concurrent Requests Summary Programmi concorrenti ordinati in base alla somma dei loro tempi di esecuzione storici JA FND Concurrent Requests Summary 過去の実行時間の合計でソートされた同時実行プログラム KO FND Concurrent Requests Summary 과거 실행 시간의 합계를 기준으로 정렬 된 동시 프로그램 PTB FND Concurrent Requests Summary Programas concorrentes ordenados pela soma de seus tempos históricos de execução RU FND Concurrent Requests Summary Одновременные программы, отсортированные по сумме их исторического времени исполнения. S FND Concurrent Requests Summary Samtidiga program sorterade efter summan av deras historiska exekveringstider TR FND Concurrent Requests Summary Eşzamanlı programlar, tarihsel yürütme sürelerinin toplamına göre sıralanır US FND Concurrent Requests Summary Concurrent programs sorted by the sum of their historic execution times ZHS FND Concurrent Requests Summary 并发程序按其历史执行时间的总和排序。 Enginatics &col_argument &col_argument2 &partition_argument &time_percentage 1=1 1 10 1=1 fcr.actual_start_date>sysdate-:days Number 60 F Commencé en quelques jours US Started within Days 2 &time_percentage ,100*x.sum_seconds/:days/86400 percentage F Commencé en quelques jours US Started within Days 3 30 1=1 fcr.actual_completion_date>=:from_date Date F Courir à partir de la date US Running from Date 4 40 1=1 fcr.actual_start_date<:to_date+1 Date F En cours à ce jour US Running to Date 5 50 1=1 upper(fcpv.user_concurrent_program_name) like upper(:program_name) LOV FND Concurrent Program Name (wildcard) 8E2FF36EDE9179D2E0530100007F1FF2 select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name F Nom du programme US Program Name 6 60 1=1 fcpv.concurrent_program_name like :system_program_name LOV FND System Concurrent Program Name 8E2FF36EDEA479D2E0530100007F1FF2 Y select fcpv.concurrent_program_name value, fcpv.description from fnd_concurrent_programs_vl fcpv order by fcpv.concurrent_program_name F Nom du programme du système US System Program Name 7 70 1=1 (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 FND Executable Short Name 8E2FF36EDEAD79D2E0530100007F1FF2 Y select fev.executable_name value, fav.application_name||': '||case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id and (:$flex$.FND_Concurrent_Execution_Method is null or xxen_util.contains(:$flex$.FND_Concurrent_Execution_Method,xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0))='Y') order by fev.executable_name F Nom court de l'exécutable US Executable Short Name 8 80 1=1 (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcp.concurrent_program_id,fcp.application_id from fnd_executables fe, fnd_concurrent_programs fcp where fe.execution_method_code=xxen_util.lookup_code(:execution_method,'CP_EXECUTION_METHOD_CODE',0) and fe.application_id=fcp.executable_application_id and fe.executable_id=fcp.executable_id ) LOV FND Concurrent Execution Method 8E2FF36EDED979D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_EXECUTION_METHOD_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Méthode d'exécution US Execution Method 9 90 &col_argument regexp_replace(fcr.argument_text,'\d+', '%') argument_text, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher le texte de l'argument US Show Argument Text 10 &col_argument2 x.argument_text, F Afficher le texte de l'argument US Show Argument Text 11 &partition_argument ,regexp_replace(fcr.argument_text,'\d+','%') F Afficher le texte de l'argument US Show Argument Text 12 100 1=1 ( fcpv.concurrent_program_name in ('RGFSGXML','RGRARG','XXEN_REPORT','') or lower(fcpv.user_concurrent_program_name) like '% report' or fe.execution_method_code='P' or fe.executable_name='XDODTEXE' ) and fcpv.user_concurrent_program_name not like 'Transfer %' and fcpv.user_concurrent_program_name not like 'Create %' and fcpv.concurrent_program_name not in ('APXIIMPT') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement les rapports US Show Reports only :$flex$.FND_Concurrent_Execution_Method Execution Method Executable Short Name