ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9D79D2E0530100007F1FF2 FND Concurrent Program Name Y 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 AR اسم البرنامج المتزامن FND D FND gleichzeitiger Programmname E Nombre del programa concurrente FND F Nom du programme concurrent du FND I Nome del programma concorrente FND JA FND 同時進行プログラム名 KO FND 동시 작업 프로그램 이름 PTB FND nome do programa concorrente RU одновременное имя программы FND S FND-samtidiga programnamn TR FND eşzamanlı program adı US FND concurrent program name ZHS FND并发程序名称 806DAE41339D8D0BE053828A2A0A8AB6 select fcr.request_id, case when fcr.program_application_id=160 and fcr.concurrent_program_id=20392 /*alecdc*/ or fcr.request_type='M' then fcr.description else fcpv.user_concurrent_program_name end program, xxen_util.user_name(fcr.requested_by) user_name, xxen_util.client_time(fcr.requested_start_date) requested_start_date, xxen_util.time(fcr.conflict_wait_seconds) conflict_wait_time, fcr.conflict_wait_seconds, xxen_util.client_time(fcr.actual_start_date) start_date, xxen_util.client_time(fcr.actual_completion_date) completion_date, xxen_util.time(fcr.seconds) run_time, fcr2.request_id blocking_request_id, case when fcr2.program_application_id=160 and fcr2.concurrent_program_id=20392 /*alecdc*/ or fcr2.request_type='M' then fcr2.description else fcpv2.user_concurrent_program_name end blocking_program, xxen_util.user_name(fcr2.requested_by) blocking_user_name, xxen_util.client_time(fcr2.actual_start_date) blocking_start_date, xxen_util.client_time(fcr2.actual_completion_date) blocking_completion_date, xxen_util.time(fcr2.seconds) blocking_run_time, fcr2.seconds blocking_run_seconds 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, fcr.* from fnd_concurrent_requests fcr where 1=1 and fcr.hold_flag='N' and fcr.crm_tstmp is not null ) fcr, fnd_concurrent_program_serial fcps, ( 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, fcr.* from fnd_concurrent_requests fcr where 1=1 and fcr.hold_flag='N' )fcr2, fnd_concurrent_programs_vl fcpv, fnd_concurrent_programs_vl fcpv2 where 2=2 and fcr.program_application_id=fcps.running_application_id and fcr.concurrent_program_id=fcps.running_concurrent_program_id and fcps.to_run_application_id=fcr2.program_application_id and fcps.to_run_concurrent_program_id=fcr2.concurrent_program_id and fcr.request_id<>fcr2.request_id and (fcr2.actual_completion_date>=fcr.requested_start_date or fcr2.phase_code='R' and fcr2.actual_completion_date is null) and fcr2.actual_start_date<=nvl(fcr.crm_release_date,sysdate) and fcr.program_application_id=fcpv.application_id(+) and fcr.concurrent_program_id=fcpv.concurrent_program_id(+) and fcr2.program_application_id=fcpv2.application_id(+) and fcr2.concurrent_program_id=fcpv2.concurrent_program_id(+) order by fcr.requested_start_date desc, fcr.request_id desc Y AR FND Concurrent Request Conflicts يسرد الطلبات المتزامنة التي احتجزها مدير حل النزاعات ويعرض طلباتهم المتعارضة / المنعوبة التي كانت تعمل في الوقت بين تاريخ البدء المطلوب وتاريخ إصدار التعارض. قد لا يعمل هذا بنسبة 100٪ (لا يعتبر تعارض مجموعة الطلبات حتى الآن) ، ولكن يجب أن يعطي إشارة جيدة لمعظم السيناريوهات المتضاربة. D FND Concurrent Request Conflicts Listet konkurrierende Anforderungen auf, die vom Konfliktlösungsmanager gehalten wurden, und zeigt deren konfliktierende / blockierende Anforderungen, die zu der Zeit zwischen dem angeforderten Startdatum und dem Konfliktfreigabedatum liefen. Dies funktioniert vielleicht nicht zu 100 % (es berücksichtigt noch keine Request-Set-Konflikte), sollte aber einen guten Hinweis auf die meisten Konfliktszenarien geben. E FND Concurrent Request Conflicts Enumera las solicitudes concurrentes que fueron retenidas por el gestor de resolución de conflictos y muestra sus solicitudes conflictivas/bloqueantes que se estaban ejecutando en el momento entre la fecha de inicio de la solicitud y la fecha de liberación del conflicto. Puede que no funcione al 100% (aún no considera los conflictos de conjuntos de solicitudes), pero debería dar una buena indicación de la mayoría de los escenarios conflictivos. F FND Concurrent Request Conflicts Liste des demandes concurrentes détenues par le gestionnaire de résolution des conflits et indique leurs demandes conflictuelles/bloquantes qui étaient en cours d'exécution entre la date de début demandée et la date de libération du conflit. Cela peut ne pas fonctionner à 100 % (il ne prend pas encore en compte les conflits de demandes), mais devrait donner une bonne indication de la plupart des scénarios conflictuels. I FND Concurrent Request Conflicts Elenca le richieste concorrenti che sono state trattenute dal gestore della risoluzione dei conflitti e mostra le loro richieste in conflitto/blocco che erano in esecuzione nel periodo tra la data di inizio della richiesta e la data di rilascio del conflitto. Questo potrebbe non funzionare al 100% (non considera ancora i conflitti di set di richieste), ma dovrebbe dare una buona indicazione della maggior parte degli scenari conflittuali. JA FND Concurrent Request Conflicts 競合解決マネージャが保持していた同時リクエストを一覧表示し、リクエストの開始日から競合のリリース日までの間に実行されていた競合/ブロッキングリクエストを表示します。 これは完全には動作しないかもしれませんが (まだリクエストセットの競合を考慮していません)、ほとんどの競合シナリオの良い表示が得られるはずです。 KO FND Concurrent Request Conflicts 충돌 해결 관리자가 보유한 동시 요청을 나열하고 요청 된 시작 날짜와 충돌 릴리스 날짜 사이에 실행 중이던 충돌 / 차단 요청을 표시합니다. 이것은 100 % 작동하지 않을 수 있지만 (아직 요청 세트 충돌을 고려하지 않음) 대부분의 충돌 시나리오를 잘 보여줍니다. PTB FND Concurrent Request Conflicts Lista as solicitações simultâneas que foram mantidas pelo gerente de resolução de conflitos e mostra suas solicitações conflitantes / bloqueadoras que estavam em execução no momento entre a data de início solicitada e a data de liberação do conflito. Isto pode não funcionar 100% (ainda não considera as solicitações definidas como conflitos), mas deve dar uma boa indicação da maioria dos cenários conflitantes. RU FND Concurrent Request Conflicts Списки совпадающих запросов, которые находились у менеджера по разрешению конфликтов, и показывает их конфликтующие / блокирующие запросы, которые выполнялись в период между запрошенной датой начала и датой выхода из конфликта. Это может не работать на 100% (он еще не учитывает конфликты набора запросов), но должно давать хорошее представление о большинстве конфликтных сценариев. S FND Concurrent Request Conflicts Listar samtidiga förfrågningar som innehades av konflikthanteringshanteraren och visar deras motstridiga / blockerande förfrågningar som kördes vid tiden mellan det begärda startdatumet och konfliktdelningsdatumet. Det här kanske inte fungerar 100% (det tar inte hänsyn till konflikt med begäran ännu), men bör ge en bra indikation på de flesta motstridiga scenarier. TR FND Concurrent Request Conflicts Çakışma çözme yöneticisi tarafından tutulan eşzamanlı istekleri listeler ve istenen başlangıç tarihi ile çakışma yayınlanma tarihi arasında o sırada çalışmakta olan çakışan / engelleyen istekleri gösterir. Bu% 100 çalışmayabilir (henüz istek seti çakışmalarını dikkate almamaktadır), ancak çoğu çelişkili senaryo için iyi bir gösterge sağlamalıdır. US FND Concurrent Request Conflicts Lists concurrent requests that were held by the conflict resolution manager and shows their conflicting / blocking requests which were running at the time between the requested start date and conflict release date. This might not work 100% (it doesn't consider request set conflicts yet), but should give a good indication of most conflicting scenarios. ZHS FND Concurrent Request Conflicts 列出被冲突解决管理器持有的并发请求，并显示其冲突/阻塞请求，这些请求在请求开始日期和冲突发布日期之间的时间正在运行。 这可能不是100%有效（它还没有考虑请求集冲突），但应该能很好地显示大多数冲突情况。 Enginatics 1=1 2=2 1 10 2=2 fcpv.user_concurrent_program_name=:user_concurrent_program_name LOV FND Concurrent Program Name 8E2FF36EDE9D79D2E0530100007F1FF2 Y 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 Concurrent Program Name 2 20 1=1 fcr.requested_start_date>sysdate-1 Number select 7 from dual where :$flex$.concurrent_program_name is null F Commencé en quelques jours US Started within Days 3 30 1=1 fcr.requested_start_date>=:requested_start_date_from DateTime F Date de début demandée de US Requested Start Date From 4 40 1=1 fcr.requested_start_date<=:requested_start_date_to DateTime :$flex$.Requested_Start_Date_From F Date de début demandée jusqu'au US Requested Start Date To :$flex$.Requested_Start_Date_From Requested Start Date From Y Requested Start Date To :$flex$.concurrent_program_name Concurrent Program Name Started within Days