DIS Workbook Owner Export Script

Description
Categories: Enginatics
Repository: Github
This export of workbook owners is required to remotely export workbook XMLs on the Enginatics environments for customers requiring support when migrating from Discoverer to Blitz Report.
Run DIS Workbook Owner Export Script and other Oracle EBS reports with Blitz Report™ on our demo environment
select
'insert into xxen_discoverer_fnd_user (eul,user_id,user_name) values ('''||:eul||''','||fu.user_id||','''||fu.user_name||''');' insert_sql
from
fnd_user fu
where
fu.user_id in
(
select distinct
case when eeu.eu_username like '#%' and eeu.eu_username not like '#%#%' then to_number(substr(eeu.eu_username,2)) end user_id
from
&eul.eul5_documents ed,
&eul.eul5_eul_users eeu
where
ed.doc_eu_id=eeu.eu_id
)
union all
select 'commit;' insert_sql from dual
Parameter Name SQL text Validation
End User Layer
<parameter_value>
LOV