How To Identify Which Scheduled Workbooks And User Are Associated With Which Database View / Result Set (Doc ID 747806.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.1 to 11.1.1.6.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***


Goal

Is it possible to identify the particular scheduled workbook which is associated with the EUL batch database objects?

For example, when a Discoverer workbook is scheduled the following database objects are created:

All these objects have the same unique sequence number within the object name.

The objects are created in the schema specified in the Discoverer Administrator under Tools ->
Privileges -> "Scheduled Workbooks" tab -> under  user that "owns the tables which store scheduled workbook results."

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

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

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