My Oracle Support Banner

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

Last updated on AUGUST 19, 2019

Applies to:

Oracle Discoverer - Version 10.1.2.0.2 to 11.1.1.7.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 25-Feb-2013***

Goal

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.

Solution

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
Goal
Solution
References

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