ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDEBE79D2E0530100007F1FF2 FND Application Short Name Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 4A9F4B6B0E4F285AE0530100007F85D7 select distinct xxen_util.client_time(nvl(aprba.creation_date,apr.start_date)) start_date, xxen_util.client_time(apr.end_date) end_date, case when apd.patch_abstract is null and apd.driver_file_name in ('uprepare.drv','ufinalize.drv','ucutover.drv','ucleanup.drv','uactualize.drv','uabort.drv') then decode(apd.driver_file_name,'uprepare.drv','PREPARE','ufinalize.drv','FINALIZE','ucutover.drv','CUTOVER','ucleanup.drv','CLEANUP','uactualize.drv','ACTUALIZE_ALL','uabort.drv','ABORT') else aap.patch_name end patch, ( select distinct listagg(x.bug_number,', ') within group (order by x.bug_number) over () patch_number from (select distinct acp.patch_driver_id, ab.bug_number from ad_comprising_patches acp, ad_bugs ab where acp.bug_id=ab.bug_id) x where apd.patch_driver_id=x.patch_driver_id ) included_patches, coalesce( apd.patch_abstract, decode(apd.driver_file_name,'uprepare.drv','adop phase=prepare','ufinalize.drv','adop phase=finalize','ucutover.drv','adop phase=cutover','ucleanup.drv','adop phase=cleanup','uactualize.drv','adop phase=actualize_all','uabort.drv','adop phase=abort'), decode(apd.merged_driver_flag,'Y','Merged Patch') ) patch_description, aap.patch_type, aat.applications_system_name instance_name, aat.name appl_top_name, apd.driver_file_name, apr.patch_top, &col_bug &col_action xxen_util.meaning(aprba.executed_flag,'YES_NO',0) bug_action_executed, xxen_util.meaning(apr.success_flag,'YES_NO',0) run_success, xxen_util.meaning(aprb.applied_flag,'YES_NO',0) bug_applied, xxen_util.meaning(aprb.success_flag,'YES_NO',0) bug_success from ad_appl_tops aat, ad_applied_patches aap, ad_patch_drivers apd, ad_patch_runs apr, (select aprb.* from ad_patch_run_bugs aprb where '&show_bug'='Y') aprb, ad_bugs ab, (select aprba.* from ad_patch_run_bug_actions aprba where '&show_action'='Y') aprba, ad_patch_common_actions apca, ad_files af, ad_file_versions afv1, ad_file_versions afv2, fnd_application_vl fav where 1=1 and aat.appl_top_id=apr.appl_top_id and aap.applied_patch_id=apd.applied_patch_id and apd.patch_driver_id=apr.patch_driver_id and apr.patch_run_id=aprb.patch_run_id(+) and aprb.bug_id=ab.bug_id(+) and aprb.patch_run_bug_id=aprba.patch_run_bug_id(+) and aprba.common_action_id=apca.common_action_id(+) and aprba.file_id=af.file_id(+) and aprba.onsite_file_version_id=afv1.file_version_id(+) and aprba.patch_file_version_id=afv2.file_version_id(+) and upper(aprb.application_short_name)=fav.application_short_name(+) order by start_date desc &sort_action Renamed &enable_ lexicals to &show_ Y :display_level<>'Filename / Action' or :display_level='Filename / Action' and ( :Application_Name is not null or :Application_Short_Name is not null or :Filename is not null or :Patch is not null or :Bug_Number is not null or :Applied_within_Days is not null or :Applied_Date_from is not null ) AR AD Applied Patches قام AD بتطبيق التصحيحات وتشغيل التصحيح والأخطاء المضمنة وأسماء الملفات والإجراءات الرجاء إدخال المزيد من المعلمات. D AD Applied Patches AD angewandte Patches, Patch-Läufe, enthaltene Bugs, Dateinamen und Aktionen Bitte geben Sie weitere Parameter ein. E AD Applied Patches Parches aplicados por AD, ejecuciones de parches, errores incluidos, nombres de archivos y acciones Por favor, introduzca más parámetros. F AD Applied Patches AD a appliqué des correctifs, a effectué des runs de correctifs, a inclus des bugs, des noms de fichiers et des actions Veuillez entrer d'autres paramètres. I AD Applied Patches AD ha applicato patch, esecuzioni di patch, bug inclusi, nomi di file e azioni Si prega di inserire altri parametri. JA AD Applied Patches ADが適用したパッチ、パッチの実行、インクルードされたバグ、ファイル名、アクション より多くのパラメータを入力してください。 KO AD Applied Patches AD 적용 패치, 패치 실행, 포함 된 버그, 파일 이름 및 작업 더 많은 매개 변수를 입력하십시오. PTB AD Applied Patches AD correções aplicadas, correções, incluindo bugs, nomes de arquivos e ações Por favor, insira mais parâmetros. RU AD Applied Patches AD-приложенные патчи, патчи, включенные ошибки, имена файлов и действия Пожалуйста, введите дополнительные параметры. S AD Applied Patches AD-tillämpade patchar, patchkörningar, inkluderade buggar, filnamn och åtgärder Ange fler parametrar. TR AD Applied Patches AD uygulanan yamalar, yama çalıştırmaları, dahil edilen hatalar, dosya adları ve eylemler Lütfen daha fazla parametre girin. US AD Applied Patches AD applied patches, patch runs, included bugs, filenames and actions Please enter more parameters. ZHS AD Applied Patches AD应用的补丁，补丁运行，包括错误，文件名和动作。 请输入更多参数。 Enginatics R12 only &col_action &col_bug &show_action &show_bug &sort_action 1=1 1 10 &show_bug Y LOV custom Y select 'Patch' value, '' description from dual union all select 'Bug' value, '' description from dual union all select 'Filename / Action' value, '' description from dual Bug Patch Y F Niveau d'affichage US Display Level 2 &show_bug Y Filename / Action F Niveau d'affichage US Display Level 3 &col_action af.app_short_name appl_top, af.subdir, af.filename, afv1.version onsite_version, afv2.version patch_version, apca.action_code action, apca.concat_attribs, aprba.action_id, Filename / Action F Niveau d'affichage US Display Level 4 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, Bug F Niveau d'affichage US Display Level 5 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, Filename / Action F Niveau d'affichage US Display Level 6 &show_action Y Filename / Action F Niveau d'affichage US Display Level 7 &sort_action ,aprba.action_id desc Filename / Action F Niveau d'affichage US Display Level 8 20 1=1 upper(aprb.application_short_name) in (select fav.application_short_name from fnd_application_vl fav where fav.application_name=:application_name) LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name F Nom de l'application US Application Name 9 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, F Nom de l'application US Application Name 10 &show_bug Y F Nom de l'application US Application Name 11 30 1=1 upper(aprb.application_short_name)=:application_short_name LOV FND Application Short Name 8E2FF36EDEBE79D2E0530100007F1FF2 Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name F Nom court de l'application US Application Short Name 12 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, F Nom court de l'application US Application Short Name 13 &show_bug Y F Nom court de l'application US Application Short Name 14 40 1=1 af.filename=:filename LOV custom Y Y select af.filename value, '$'||af.app_short_name||'_TOP/'||af.subdir||'/'||af.filename description from ad_files af F Nom de fichier US Filename 15 &col_action af.app_short_name appl_top, decode(af.subdir,'DUMMY',null,af.subdir) directory, af.filename, afv1.version||decode(nvl(afv1.translation_level,0),0,null,':'||to_char(afv1.translation_level)) onsite_version, afv2.version||decode(nvl(afv2.translation_level,0),0,null,':'||to_char(afv2.translation_level)) patch_version, apca.action_code action, apca.concat_attribs, aprba.action_id, F Nom de fichier US Filename 16 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, F Nom de fichier US Filename 17 &show_action Y F Nom de fichier US Filename 18 &show_bug Y F Nom de fichier US Filename 19 50 1=1 ( aap.patch_name=:patch_name or apr.patch_run_id in (select aprb.patch_run_id from ad_bugs ab, ad_patch_run_bugs aprb where ab.bug_number=:patch_name and ab.bug_id=aprb.bug_id) ) LOV custom select y.patch_name value, y.creation_date||nvl2(y.description,': '||y.description,null) description from ( select distinct x.patch_name, max(x.description) description, max(x.creation_date) creation_date from ( select aap.patch_name, aap.patch_type description, aap.creation_date from ad_applied_patches aap union select ab.bug_number value, acp.patch_abstract description, acp.creation_date from ad_comprising_patches acp, ad_bugs ab where acp.bug_id=ab.bug_id ) x group by x.patch_name order by creation_date desc ) y US Patch 20 60 1=1 ab.bug_number=:bug_number LOV custom Y Y select ab.bug_number value, nvl(ab.application_short_name,ab.trackable_entity_abbr)||': '||ab.aru_release_name||': '||ab.baseline_name description from ad_bugs ab order by ab.creation_date desc F Numéro de bug US Bug Number 21 &col_bug ab.bug_number, upper(aprb.application_short_name) application_short_name, fav.application_name, F Numéro de bug US Bug Number 22 &show_bug Y F Numéro de bug US Bug Number 23 70 1=1 nvl(aprba.creation_date,apr.start_date)>=sysdate-:applied_within_days Number select 90 from dual where :$flex$.patch is null and :$flex$.bug_number is null and :$flex$.filename is null F Appliqué en quelques jours US Applied within Days 24 80 1=1 nvl(aprba.creation_date,apr.start_date)>=:applied_date_from Date sysdate-:$flex$.applied_within_days F Appliqué Date du US Applied Date from 25 90 1=1 nvl(aprba.creation_date,apr.start_date)<:applied_date_to+1 Date F Date d'application au US Applied Date to 26 100 1=1 aprba.executed_flag(+)='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.display_level='Filename / Action' F Afficher uniquement les actions exécutées US Show Executed Actions only 27 110 1=1 apr.success_flag(+)='Y' and aprb.applied_flag(+)='Y' and aprb.success_flag(+)='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher uniquement les applications réussies US Show Successfuly Applied only :$flex$.applied_within_days Applied within Days Applied Date from :$flex$.bug_number Bug Number Applied within Days :$flex$.display_level Display Level Show Executed Actions only :$flex$.filename Filename Applied within Days :$flex$.patch Patch Applied within Days