How To Identify Which Scheduled Workbooks And User Are Associated With Which Database View / Result Set
Last updated on SEPTEMBER 27, 2016
Applies to:Oracle Discoverer - Version 10.1.2.1 to 184.108.40.206.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***
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:
- A view is created containing the select statement to create the result tables -
- A table is created for each run with the results - e.g. EUL5_B070312143115Q1R1
- A package is created with the run information - e.g. EUL5_BATCH_PACKAGE070312143115
- A job is created to call package at specified schedule intervals - e.g.EUL5_BATCH_PACKAGE070312143115.RUN
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.
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