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 E51E8E890324184CE0536AFB09059FEDY select 'if not exist workbook_'||ed.doc_id||'.eex (start '||:executable_path||' /connect '||:eul||'/'||:eul_password||'@'||:db_service_name||' /export "workbook_'||ed.doc_id||'.eex" /workbook "'||xxen_util.dis_user_name(xxen_util.dis_user(ed.doc_eu_id,:eul),'N')||'.'||ed.doc_name||'" /xmlworkbook'||chr(38)||' ping /n '||:delay_seconds||' localhost >NUL) else (echo workbook_'||ed.doc_id||'.eex exists)' text, ed.doc_name workbook, xxen_util.dis_user_name(ed.doc_eu_id,:eul) owner, 'workbook_'||ed.doc_id||'.eex' file_name from &eul.eul5_documents ed where 1=1 and (ed.doc_name, xxen_util.dis_user_name(ed.doc_eu_id,:eul,'N')) in (select eqs.qs_doc_name, upper(eqs.qs_doc_owner) qs_doc_owner from &eul.eul5_qpp_stats eqs where 2=2 &or_owner_restriction) order by ed.doc_id US DIS Workbook Export Script https://youtu.be/17_Au_11IBE Use this report to migrate Discoverer workbooks to Blitz Report. The migration process is described in the following link: https://www.enginatics.com/blog/discoverer-replacement-with-blitz-report/ 1. Run this report 'DIS Workbook Export Script' to generate a list of commands to export xmls for all recently used Discoverer workbooks. 2. Create a new folder on a windows machine having the Discoverer Admin executable dis51adm.exe installed (contact Enginatics, if you need help with the Discoverer Administrator installation). 3. Open a Command Prompt window, cd to the new folder, and execute (copy and paste) the commands generated in step 1. This will start individual processes to export the workbooks as .eex files. Depending on your client capacity, you can run between 100 and 200 export processes at the same time. In case of errors, delete all zero size .eex files and rerun the script. 4. Zip together all generated (non-zero size) workbook_*.eex files. Do not include the generated *.log files. Note that the .zip needs to be created with older Windows10 compression methods, as the latest Windows11 method cannot be processed by the Oracle 19c database yet. 5. If you have more than one EUL, set the profile option 'Blitz Report Discoverer Default EUL' to the end user layer for which you run the migration 6. Navigate to Setup>Tools>Import>XML Upload and upload the .zip file generated in step 4. You will see a message with the count of uploaded xml files. 7. Run concurrent program 'Blitz Report Discoverer Import' from the System Administrator responsibility, and specify a report name prefix to easily distinguish the migrated reports. 8. Verify the migration result by running reports: 'Blitz Report Parameter Uniqueness Validation' and correct the nonunique parameter names. 'Blitz Report LOV SQL Validation' and correct errors plus change slow 'distinct' style ones to fast SQLs 'Blitz Report SQL Validation' and correct problems 'Blitz Report Parameter Bind Variable Validation' 'DIS Migration identify missing EulConditions' 'Blitz Report Parameter Table Alias Validation' 'Blitz Reports' for Discoverer check for column 'required_parameters' 'Blitz Report Parameter Default Values' for discoverer check for default value having partition 'Blitz Report Templates' and search for Subtotals: Y in the description and train the users to switch compact pivot to tabular format In case you need to completely re-run the Discoverer import, for example with a different cut-off date parameter, you can use the following script to purge the previously imported data: declare l_eul varchar2(30):='eul_us'; begin --Delete staging tables delete xxen_discoverer_workbook_xmls xdwx where xdwx.eul=l_eul; delete from xxen_discoverer_fnd_user xdfu where xdfu.eul=l_eul; delete from xxen_discoverer_pivot_fields xdpf where xdpf.eul=l_eul; delete from xxen_discoverer_sheets xds where xds.eul=l_eul; delete from xxen_discoverer_workbooks xdw where xdw.eul=l_eul; --Delete all reports from category 'Discoverer' and their related LOVs for c in (select xrca.report_id from xxen_report_categories_v xrcv, xxen_report_category_assigns xrca where xrcv.category='Discoverer' and xrcv.category_id=xrca.category_id) loop xxen_api.delete_report(c.report_id,'Y'); end loop; for c in (select xrplv.lov_id from xxen_report_parameter_lovs_v xrplv where xrplv.description=upper(xrplv.description) and xrplv.lov_id not in (select xrp.lov_id from xxen_report_parameters xrp where xrp.parameter_type='LOV' and xrp.lov_id is not null)) loop xxen_api.delete_lov(c.lov_id); end loop; commit; end; Enginatics &eul &or_owner_restriction 1=1 2=2 :db_service_name :delay_seconds :eul :eul_password :executable_path 1 10 2=2 eqs.qs_created_date>=:date_from Date sysdate-nvl(fnd_profile.value('XXEN_REPORT_DISCOVERER_IMPORT_LOV_ACCESS_HISTORY_DAYS'),600) US Accessed After 2 20 &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 3 30 2=2 eqs.qs_doc_name=: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 US Workbook 4 40 &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 US End User Layer 5 :eul US End User Layer 6 50 :eul_password Char :$flex$.End_User_Layer US End User Layer Password 7 60 :executable_path Char C:\Oracle\product\11.1.1\as_1\bin\dis51adm.exe US Executable Path 8 70 :db_service_name Char r1213a US DB Service Name 9 80 1=1 ed.doc_id not in (select xdwx.doc_id from xxen_discoverer_workbook_xmls xdwx where xdwx.eul=:eul) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Not yet imported only :$flex$.End_User_Layer End User Layer End User Layer Password