DIS Workbook Owner Export Script

➜ Back to Library
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
Download
Related Blitz Reports
FND Access Control 11i CAC WIP Pending Cost Adjustment FND Access Control FND W3H_Role_Functions CAC ICP PII WIP Pending Cost Adjustment FND W3H_Object_Users FND W3H_User_Functions FND W3H_Function_Users CAC Subinventory Accounts Setup CAC Cost Group Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: