DIS Workbook Owner Export Script – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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.

Report Parameters

End User Layer

Oracle EBS Tables Used

fnd_user

Report Categories

Enginatics

CAC Cost Group Accounts Setup, CAC Category Accounts Setup, FND Responsibility Access, CAC ICP PII WIP Pending Cost Adjustment, CAC Subinventory Accounts Setup

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output
Blitz Report™ XML Import DIS_Workbook_Owner_Export_Script.xml
Full SQL on Enginatics www.enginatics.com/reports/dis-workbook-owner-export-script/

DIS Workbook Owner Export Script

Description

This script is a utility designed to facilitate the support and migration process from Oracle Discoverer to Blitz Report. It generates a list of workbook owners, which is required to remotely export workbook XML definitions.

When migrating complex Discoverer environments, it is often necessary to export workbook definitions for analysis or conversion. This script provides the necessary user information to target specific owners’ workbooks for export, streamlining the migration workflow and ensuring that support teams have the correct context for troubleshooting or conversion tasks.

Parameters

Used Tables

Categories

© 2026 Enginatics