My Oracle Support Banner

How To Find A Particular Scheduled Workbook's Result Set Table In Discoverer (Doc ID 459747.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Discoverer - Version to [Release 10.1.2 to 11g]
Information in this document applies to any platform.


When a Discoverer scheduled workbook job is executed it creates a result set table that contains the data of the scheduled workbook.

The table is created in the schema specified in the Discoverer Administrator >> Tools >> Privileges >> Scheduled Workbooks tab 'Select the user toown the tables which stores any workbook result'. 

There may be many result set tables created under the same schema.

The goal of this document is to provide an example to illustrate how to identify the Discoverer result set table name that holds data from a particular Discoverer scheduled workbook.  Based on this example, it can also be used to verify if the Discoverer scheduled workbook job has been executed and the data is correct and updated.

Note: The tables mentioned here should never be updated or deleted manually.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.