Oracle Business Intelligence

How to delete scheduled workbooks and results in Discoverer

hello dear friend,

Here is a very good piece on discoverer, how to know the results of schedule reports and insight into it

How to delete scheduled workbooks and results in Discoverer.

A scheduled workbook can be setup to run at a particular frequency, e.g. daily, weekly, etc., or it can be set to never repeat. When a workbook is scheduled the following database objects are created:

A view is created containing the select statement to create the result tables (e.g. EUL5_B011206161506Q1V1)

A table is created for each run with the results (e.g. EUL5_B011206161506Q1R1)

A package is created with the run information (e.g. EUL5_BATCH_PACKAGE011206161506 )

A job is created to call package at specified schedule intervals (e.g. EUL5_BATCH_PACKAGE011206161506.RUN)

All objects have the same unique sequence number in the name.  The R1 tables hold the results of a particular run of a scheduled workbook. A scheduled workbook can have a number of R1 tables, because a new table is created every time the scheduled workbook runs. If deleting the result sets for a scheduled workbook through the Discoverer Plus or Desktop then the R1 tables will be deleted from the database. If deleting the scheduled workbook from the Scheduling Manager then all the database objects will be deleted.


Shivmohan Purohit ———— share your feedback

How To Open A Worksheet Directly From Oracle Applications Menu ?

Receive the latest blog updates

Facebook Twitter Instagram Youtube Linkedin