Tag Archives: discoverer

Deleting a Schedules Request

How to delete the saved schedules, which were saved from the ‘Schedules’ tab of the ‘Submit Request’ window.
There is no standard functionality to delete any saved schedule.

The saved schedules are being stored in the table fnd_conc_release_classes_vl.
Select release_class_id, application_id, release_class_name schedule_name,
description, class_type schedule_type
from fnd_conc_release_classes_vl
where owner_req_id is null
and enabled_flag != ‘N’
and nvl(start_date_active,sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
order by release_class_name

If you want to delete any saved schedule from the LOV, then you can perform any of the following:
Delete the row from the table FND_CONC_RELEASE_CLASSES_VL for the saved schedule.
OR
It will be better to update the ENABLED_FLAG = ‘N’ for the saved schedule instead of deleting the row from the table FND_CONC_RELEASE_CLASSES_VL.

thanks – shivmohan

Sample Example on Viewing Worksheet through Discoverer Plus via URL Link Sample example on viewing worksheet through discoverer plus via URL link. Syntax: http://<Hostname>:<port#>/discoverer/plus?&cn=<Connection_Key>&opendbid=<Workbook_ID>&sheetid=<Worksheet_ID> http://<Hostname>:<port#>/discoverer/plus?&cn=<Connection_Key>&opendb=<Workbook_Name>&sheet=<Worksheet_Name>

Hello Friends, many of my past work involve integrating oracle discoverer with oracle applications, here there is one of the ways to leverage both to integrate within applications.  How To Open A Worksheet Directly From Oracle Applications Menu ?   … Continue reading

Discoverer SQL: Long Running Discoverer Report Here is a small SQL quite useful to work with discoverer to identify long running reports and start looking into the reason / troubleshooting. SELECT q.qs_doc_name Worksheet,  q.qs_doc_details Sheet ,  q.qs_num_rows Lines,  QS_ACT_CPU_TIME CPU_Time, … Continue reading

Sample Example on How To Extract Worksheet IDs of a Workbook through Discoverer Desktop via the d51wkdmp utility Syntax: d51wkdmp.exe <Workbook_Name> <Output_File> DB <Connect_String>  <Eul_Schema> -f (1) Log into your pc where Discoverer Desktop is installed. (2) Find out the … Continue reading

hello discoverer friends, here a good technical insight within oracle discoverer for scheduled report, what are the tables behind and how they linked. hope you would like n find it useful. do share ur feedback to improve future articles.   … Continue reading

How to Create a Link to a Discoverer Workbook in Apps11i  To create a link from the Oracle Applications 11i home page to a Discoverer workbook that will automatically open Discoverer Plus or Viewer and display the workbook using apps … Continue reading