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.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
CAC Cost Group Accounts Setup CAC Category Accounts Setup FND Responsibility Access 11i FND Responsibility Access 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
Blitz Report™

Blitz Report™ provides multiple benefits: