DIS Workbook Export Script

Description
Categories: Enginatics
Repository: Github
Use this report to generate the commands to export your recently excuted workbooks as individual XML files (20 seconds delay between each export).
You can open several (e.g. 5) cmd windows in parallel and copy the commands from each sheet into the windows to run the export.

Discoverer admin might fail to export some of the workbooks or create them with zero size.
In such case, you sho ... 
Use this report to generate the commands to export your recently excuted workbooks as individual XML files (20 seconds delay between each export).
You can open several (e.g. 5) cmd windows in parallel and copy the commands from each sheet into the windows to run the export.

Discoverer admin might fail to export some of the workbooks or create them with zero size.
In such case, you should remove any zero size workbook xml files and rerun the whole script (already existing files are not re-exported)
   more
Run DIS Workbook Export Script and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.text,
mod(x.row_number,:batches)+1 batch_number
from
(
select
row_number() over (order by ed.doc_id) row_number,
'IF NOT EXIST workbook_'||ed.doc_id||'.eex (Start '||:executable_path||' /connect '||:eul||'/'||:eul_passwrd||'@'||:db_service_name||' /export "workbook_'||ed.doc_id||'.eex" /workbook "'||nvl(fu.user_name,eeu.eu_username)||'.'||ed.doc_name||'" /xmlworkbook'||chr(38)||' ping /n 20 localhost >NUL) ELSE (ECHO workbook_'||ed.doc_id||'.eex exists)' text
from
&eul.eul5_documents ed,
&eul.eul5_eul_users eeu,
fnd_user fu
where
1=1 and
ed.doc_name in (select eqs.qs_doc_name from &eul.eul5_qpp_stats eqs where 2=2) and
ed.doc_id not in (select xdwx.doc_id from xxen_discoverer_workbook_xmls xdwx where xdwx.eul=:eul) and
ed.doc_eu_id=eeu.eu_id and
case when eeu.eu_username like '#%' then to_number(substr(eeu.eu_username,2)) end=fu.user_id(+)
) x
where
3=3
order by
x.row_number
Parameter Name SQL text Validation
Accessed within Days
eqs.qs_created_date>sysdate-:history_days
Number
Accessed After
eqs.qs_created_date>:date_from
Date
Batch Count
 
Number
End User Layer
<parameter_value>
LOV
End User Layer Password
 
Char
Executable Path
 
Char
DB Service Name
 
Char
Row Limit
x.row_number<=:row_limit
Number
Blitz Report™