13.4 Submitting Reports to Pluggable Destinations from Oracle Forms Services

To submit requests to any Oracle Reports-registered pluggable destinations from Oracle Forms Services:

  1. Create or install a pluggable destination for Reports Server (refer to the Oracle Reports Plugin Exchange on the Oracle Technology Network (OTN) at http://www.oracle.com/technology/products/reports/pluginxchange/index.html).

  2. In Oracle Forms, create a form and set it up to run a report to Reports Server (refer to Integrating Oracle Reports in Oracle Forms Services white paper at http://www.oracle.com/technology/products/forms/pdf/10g/frm10gsrw10g.pdf).

    The parameters to submit the request should be set as follows:

    set_report_object_property(report_id, REPORT_DESTYPE, PLUGDEST);
    set_report_object_property(report_id, REPORT_OTHER, 'PLUGDESTYPE=pluggable destination' );
  3. Observe in Reports Server that the report output is sent to the pluggable destination.

When the PLUGDESTYPE parameter is specified, DESTYPE (in Oracle Reports) and REPORT_DESTYPE (in Oracle Forms) will be ignored and the value of PLUGDESTYPE will be used.