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/technetwork/middleware/reports/index-085705.html).

  2. In Oracle Forms, create a form and set it up to run a report to Reports Server (refer to Integrating Oracle Forms 10g and Oracle Reports 10g white paper at http://www.oracle.com/technetwork/developer-tools/forms/documentation/techlisting10g-085500.html).

    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.