ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 80492D0C92AB0D79E0530100007F3E2A select fcqv.user_concurrent_queue_name manager, fcqv.concurrent_queue_name short_name, xxen_util.meaning(fcqv.enabled_flag,'YES_NO',0) enabled_flag, fav.application_name, fcsv.service_name type, fcqv.target_node, fcqv.running_processes actual_count, fcqv.target_processes target, fcwr0.running, fcwr0.pending, fcwr0.on_hold, fcwr0.scheduled, xxen_util.meaning(fcqv.control_code,'CP_CONTROL_CODE',0) status, &columns fcqv.cache_size, fcqv.sleep_seconds, fcqv.node_name primary_node, fcqv.node_name2 secondary_node, fcqv.concurrent_queue_id, fcqv.application_id from fnd_concurrent_queues_vl fcqv, fnd_application_vl fav, fnd_cp_services_vl fcsv, ( select fcwr.concurrent_queue_id, fcwr.queue_application_id, sum(case when fcwr.phase_code='R' then 1 end) running, sum(case when fcwr.phase_code='P' and fcwr.hold_flag<>'Y' and fcwr.requested_start_date<=sysdate then 1 end) pending, sum(case when fcwr.hold_flag='Y' then 1 end) on_hold, sum(case when fcwr.phase_code='P' and fcwr.hold_flag<>'Y' and fcwr.requested_start_date>sysdate then 1 end) scheduled from fnd_concurrent_worker_requests fcwr where fcwr.phase_code in ('R','P') group by fcwr.concurrent_queue_id, fcwr.queue_application_id ) fcwr0, ( select fcwr.queue_application_id, fcwr.concurrent_queue_id, row_number() over (partition by fcwr.queue_application_id,fcwr.concurrent_queue_id order by fcwr.priority,fcwr.priority_request_id,fcwr.request_id) position, fcwr.request_id, fnd_amp_private.get_phase (fcwr.phase_code,fcwr.status_code,fcwr.hold_flag,fcwr.enabled_flag,fcwr.requested_start_date,fcwr.request_id) phase, fnd_amp_private.get_status (fcwr.phase_code,fcwr.status_code,fcwr.hold_flag,fcwr.enabled_flag,fcwr.requested_start_date,fcwr.request_id) status, fcwr.request_description program, xxen_util.user_name(fcwr.requested_by) requestor, fcwr.argument_text request_parameters from fnd_concurrent_worker_requests fcwr where '&show_requests'='Y' and (fcwr.phase_code='P' or fcwr.phase_code='R') and fcwr.hold_flag!='Y' and fcwr.requested_start_date<=sysdate ) fcwr, (select fcqc.* from fnd_concurrent_queue_content fcqc where '&show_specialization_rules'='Y') fcqc, fnd_concurrent_programs_vl fcpv, (select fcpr.* from fnd_concurrent_processes fcpr where '&show_processes'='Y') fcpr, ( select distinct fcr.controlling_manager, decode(fcr.status_code,'R','A','T','A','X','K') process_status_code, max(fcr.request_id) over (partition by fcr.controlling_manager,decode(fcr.status_code,'R','A','T','A','X','K')) request_id, max(fcr.os_process_id) keep (dense_rank last order by fcr.request_id) over (partition by fcr.controlling_manager,decode(fcr.status_code,'R','A','T','A','X','K')) os_process_id from fnd_concurrent_requests fcr where '&show_processes'='Y' and fcr.status_code in ('R','T') ) fcr where 1=1 and fcqv.application_id=fav.application_id and fcqv.manager_type=fcsv.service_id(+) and fcqv.application_id=fcwr0.queue_application_id(+) and fcqv.concurrent_queue_id=fcwr0.concurrent_queue_id(+) and fcqv.application_id=fcwr.queue_application_id(+) and fcqv.concurrent_queue_id=fcwr.concurrent_queue_id(+) and fcqv.application_id=fcqc.queue_application_id(+) and fcqv.concurrent_queue_id=fcqc.concurrent_queue_id(+) and decode(fcqc.type_code,'P',fcqc.type_application_id)=fcpv.application_id(+) and decode(fcqc.type_code,'P',fcqc.type_id)=fcpv.concurrent_program_id(+) and fcqv.application_id=fcpr.queue_application_id(+) and fcqv.concurrent_queue_id=fcpr.concurrent_queue_id(+) and fcpr.concurrent_process_id=fcr.controlling_manager(+) and fcpr.process_status_code=fcr.process_status_code(+) order by fcqv.enabled_flag desc, decode (fcqv.application_id,0,decode(fcqv.concurrent_queue_id,1,1,4,2)), sign(fcqv.max_processes) desc, fcqv.concurrent_queue_name, fcqv.application_id, &order_by 1 Y AR FND Concurrent Managers إعداد المديرين المتزامنين والوضع الحالي ، على سبيل المثال العمليات والطلبات قيد التشغيل والمعلقة وما إلى ذلك. يعرض نفس المعلومات مثل المتزامن-> المدير-> المسؤول والمتزامن-> المدير-> تعريف D FND Concurrent Managers Einrichtung und aktueller Status der Concurrent-Manager, z. B. laufende Prozesse und Anforderungen, ausstehende usw. Zeigt die gleichen Informationen wie Concurrent->Manager->Administer und Concurrent->Manager->Define E FND Concurrent Managers Configuración y estado actual de los gestores concurrentes, por ejemplo, procesos y solicitudes en ejecución, pendientes, etc. Muestra la misma información que Concurrent->Manager->Administer y Concurrent->Manager->Define F FND Concurrent Managers Configuration et état actuel des gestionnaires simultanés, par exemple les processus et les demandes en cours, en attente, etc. Affiche les mêmes informations que Concurrent->Gestionnaire->Administrateur et Concurrent->Gestionnaire->Définir I FND Concurrent Managers Impostazione e stato attuale dei manager concorrenti, ad esempio processi e richieste in esecuzione, in sospeso, ecc. Mostra le stesse informazioni di Concurrent->Manager->Administer e Concurrent->Manager->Define JA FND Concurrent Managers コンカレントマネージャーの設定と現在の状態（プロセスやリクエストの実行中、保留中など）を表示します。 Concurrent->Manager->Administer および Concurrent->Manager->Define と同じ情報を表示します。 KO FND Concurrent Managers 동시 관리자의 설정 및 현재 상태 (예 : 실행 중, 보류중인 프로세스 및 요청 동시 접속-> 관리자-> 관리 및 동시 접속-> 관리자-> 정의와 동일한 정보를 보여줍니다. PTB FND Concurrent Managers Configuração e status atual dos gerentes simultâneos, por exemplo, processos e solicitações em execução, pendentes, etc. Mostra as mesmas informações que Concorrente->Gerente->Administrador e Concorrente->Gerente->Definir RU FND Concurrent Managers Одновременная настройка менеджеров и текущее состояние, например, запущенные процессы и запросы, ожидающие своей очереди и т.д. Показывает ту же информацию, что и "Концерт->Менеджер->Администратор" и "Концерт->Менеджер->Дефинировать". S FND Concurrent Managers Samtidiga cheferns inställningar och nuvarande status, t.ex. processer och förfrågningar som körs, väntar etc. Visar samma information som Samtidig-> Manager-> Administrera och Concurrent-> Manager-> Definiera TR FND Concurrent Managers Eşzamanlı yöneticilerin kurulumu ve mevcut durumu, ör. çalışan, bekleyen vb. işlemler ve istekler Eşzamanlı-> Yönetici-> Yönet ve Eşzamanlı-> Yönetici-> Tanımla ile aynı bilgileri gösterir US FND Concurrent Managers Concurrent managers' setup and current status, e.g. processes and requests running, pending etc. Shows the same information as Concurrent->Manager->Administer and Concurrent->Manager->Define ZHS FND Concurrent Managers 并发管理器的设置和当前状态，如正在运行的进程和请求、待处理等。 显示与并发->Manager->Administer和并发->Manager->Define相同的信息。 Enginatics &columns &order_by &show_processes &show_requests &show_specialization_rules 1=1 1 10 1=1 fcqv.user_concurrent_queue_name=:manager_name LOV custom Y select fcqv.user_concurrent_queue_name value, fcqv.concurrent_queue_name||nvl2(fcqv.control_code,' ('||xxen_util.meaning(fcqv.control_code,'CP_CONTROL_CODE',0)||')',null) description from fnd_concurrent_queues_vl fcqv order by fcqv.user_concurrent_queue_name F Nom du gestionnaire US Manager Name 2 50 &show_specialization_rules Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Règles de spécialisation des spectacles US Show Specialization Rules 3 &columns xxen_util.meaning(fcqc.include_flag,'INCLUDE_EXCLUDE',0) include_exclude, xxen_util.meaning(fcqc.type_code,'CP_SPECIAL_RULES',0) type, (select fav.application_name from fnd_application_vl fav where fcqc.type_application_id=fav.application_id) type_application, fcpv.user_concurrent_program_name name, F Règles de spécialisation des spectacles US Show Specialization Rules 4 60 &show_processes Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les processus US Show Processes 5 &columns xxen_util.meaning(fcpr.process_status_code,'CP_PROCESS_STATUS_CODE',0) process_status_code, fcpr.concurrent_process_id, fcpr.oracle_process_id oracle_id, fcpr.os_process_id os_id, fcr.request_id, fcr.os_process_id request_os_id, fcpr.process_start_date, F Afficher les processus US Show Processes 6 &order_by decode (fcpr.process_status_code,'R',1,'T',1,'A',2,'P',2,'Z',3,'K',3,'S',3,'X',3,4), fcpr.last_update_date desc, F Afficher les processus US Show Processes 7 70 1=1 fcpr.process_status_code not in ('K','S') LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_processes is not null select 'Y' from dual where :$flex$.show_processes is not null F Processus actifs uniquement US Active Processes only 8 80 &show_requests Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Demandes d'exposition US Show Requests 9 &columns fcwr.position, fcwr.request_id, fcwr.phase, fcwr.status, fcwr.program, fcwr.requestor, fcwr.request_parameters, F Demandes d'exposition US Show Requests 10 &order_by fcwr.position, F Demandes d'exposition US Show Requests 11 90 1=1 fcwr.request_id is not null LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_requests is not null select 'Y' from dual where :$flex$.show_requests is not null F Demandes actives uniquement US Active Requests only :$flex$.show_processes Show Processes Active Processes only :$flex$.show_requests Show Requests Active Requests only