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 A5B6B611CB2E06E7E053BA6B6358CFF7 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.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( 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 4A9F4B6B0E4F285AE0530100007F85D7 :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 ) US AD Applied Patches 11i AD applied patches, patch runs, included bugs, filenames and actions. Please enter more parameters. Enginatics &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, ab.application_short_name 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, ab.application_short_name || nvl2(ab.application_short_name,': ',null) || ab.aru_release_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 and :$flex$.applied_date_from 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 F Appliqué Date du US Applied Date from 25 90 1=1 nvl(aprba.creation_date,apr.start_date)<=:applied_date_to 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 101 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 xxen_util.meaning('Y','YES_NO',0) from dual where :$flex$.display_level='Filename / Action' US Show Executed Actions Only 28 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 29 111 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 xxen_util.meaning('Y','YES_NO',0) US Show Successfuly Applied Only :$flex$.applied_date_from Applied Date from Y Applied within Days :$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