ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3879D2E0530100007F1FF2 DIS End User Layer Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc AR طبقة المستخدم النهائي للمكتشف D Entdecker-Endbenutzerschicht E Capa de usuario final de Discoverer F Couche utilisateur final Discoverer I Livello utente finale Discoverer JA 発見者エンドユーザー層 KO Discoverer 최종 사용자 계층 PTB Camada do usuário final do Discoverer RU Уровень конечного пользователя S Discoverer-slutanvändarlager TR Discoverer son kullanıcı katmanı US Discoverer end user layer ZHS 发现者终端用户层 8E2FF36EDF2079D2E0530100007F1FF2 DIS Workbook Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name AR مصنف Discoverer D Entdecker-Arbeitsmappe E Cuaderno de trabajo Discoverer F Manuel du découvreur I Libro di lavoro Discoverer JA ディスカバラーワークブック KO Discoverer 워크 북 PTB Livro de exercícios do descobridor RU рабочая тетрадь первооткрывателя S Discoverer-arbetsbok TR Discoverer çalışma kitabı US Discoverer workbook ZHS 发现者工作手册 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US F449645C95B4203DE0530100007FFFFF select x.owner, x.workbook, x.description, x.workbook_exists, x.sheet, x.access_count, x.last_accessed, x.last_accessed_by, x.object_use_key, x.last_updated_by, x.last_update_date, x.doc_id, xxen_util.meaning(nvl2(xdwx.doc_id,'Y',null),'YES_NO',0) eex_uploaded, xdw.count flattened_count, xrtv.report_name, xrtv.template_name, xrtv.description template_description from ( select nvl(xxen_util.dis_user_name(ed.doc_eu_id,:eul),xxen_util.user_name(eqs.qs_doc_owner_)) owner, nvl(ed.doc_name,eqs.qs_doc_name) workbook, xxen_util.meaning(nvl2(ed.doc_name,'Y',null),'YES_NO',0) workbook_exists, eqs.qs_doc_details sheet, eqs.access_count, eqs.last_accessed, xxen_util.dis_user_name(eqs.last_accessed_by) last_accessed_by, eqs.qs_object_use_key object_use_key, xxen_util.dis_user_name(ed.doc_updated_by) last_updated_by, ed.doc_updated_date last_update_date, ed.doc_id, ed.doc_description description from &eul.eul5_documents ed &full join ( select distinct eqs.qs_doc_name, eqs.qs_doc_owner_, eqs.qs_doc_details, count(*) access_count, max(eqs.qs_created_date) last_accessed, max(eqs.qs_created_by) keep (dense_rank first order by eqs.qs_created_date desc) last_accessed_by, eqs.qs_object_use_key from (select x.* from ( select max(eqs.qs_object_use_key) keep (dense_rank last order by eqs.qs_id) over (partition by eqs.qs_doc_name,eqs.qs_doc_details,eqs.qs_doc_owner_) max_object_use_key, eqs.* from (select upper(eqs.qs_doc_owner) qs_doc_owner_, eqs.* from &eul.eul5_qpp_stats eqs where 2=2 &or_owner_restriction) eqs ) x where x.qs_object_use_key=x.max_object_use_key ) eqs group by eqs.qs_doc_name, eqs.qs_doc_owner_, eqs.qs_doc_details, eqs.qs_object_use_key ) eqs on ed.doc_name=eqs.qs_doc_name and xxen_util.dis_user_name(ed.doc_eu_id,:eul,'N')=eqs.qs_doc_owner_ ) x, (select xdwx.* from xxen_discoverer_workbook_xmls xdwx where xdwx.eul=:eul) xdwx, (select xdw.doc_id, count(*) count from xxen_discoverer_workbooks xdw where xdw.eul=:eul group by xdw.eul, xdw.doc_id) xdw, (select regexp_substr(xrtv.description,chr(10)||'Sheet: (.+)',1,1,null,1) sheet, regexp_substr(xrtv.description,chr(10)||'Doc Id: (\d+)',1,1,null,1) doc_id, xrtv.* from xxen_report_templates_v xrtv where regexp_substr(xrtv.report_description,chr(10)||'EUL: (\w+)',1,1,null,1)=:eul) xrtv where 1=1 and x.doc_id=xdwx.doc_id(+) and x.doc_id=xdw.doc_id(+) and x.doc_id=xrtv.doc_id(+) and x.sheet=xrtv.sheet(+) order by x.owner, x.workbook, x.sheet Added last_accessed_by and description columns Y US DIS Workbook Import Validation Discoverer workbook migraton validation report showing the workbooks, sheets, how ofthen they were accessed within the given number of days, columns for the number of records in the different import process tables, and the created blitz report and template information. Enginatics &eul &full &or_owner_restriction 1=1 2=2 :eul 1 10 1=1 x.workbook=:workbook LOV DIS Workbook 8E2FF36EDF2079D2E0530100007F1FF2 Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name F Cahier d'exercices US Workbook 2 20 2=2 eqs.qs_created_date>=:accessed_after Date sysdate-nvl(fnd_profile.value('XXEN_REPORT_DISCOVERER_IMPORT_LOV_ACCESS_HISTORY_DAYS'),600) US Accessed after 3 25 &or_owner_restriction or upper(eqs.qs_doc_owner)=:doc_owner LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Workbook Owner 4 30 1=1 xrtv.template_name is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Not yet imported 5 40 &full full LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement Active US Include Inactive 6 50 &eul <parameter_value> LOV DIS End User Layer 8E2FF36EDF3879D2E0530100007F1FF2 Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc xxen_util.dis_default_eul Y F Couche de l'utilisateur final US End User Layer 7 :eul F Couche de l'utilisateur final US End User Layer