How To Find A Particular Scheduled Workbook's Result Set Table In Discoverer

(Doc ID 459747.1)

Last updated on SEPTEMBER 27, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms