Set Output Options

The Output tab has two regions: Output and Destination. Each scheduled job can have multiple output files with distinct characteristics. Each output file can have multiple destinations.

To set the output options for a report job:
  1. Select the Output tab.
  2. Select the output options.
    Option Description

    Use Bursting Definition to Determine Output and Delivery Destination

    Enable this option to use the report bursting definition for output and delivery. Once selected, all other fields on this page are disabled for selection. This option is only available when bursting is enabled for the report.

    Make Output Public

    Enable this option to make this job output available to all users with permission to access this report. Users with access can view the report from the Report Job History page.

    Save Data for Republishing

    Enable this option to save the XML data that is generated for this job. Access the saved data from the Report Job History page where you can republish it, selecting a new layout and output options.

    Compress output prior to delivery

    Enable this option to compress each report (all report formats except HTML) before delivery. The format for the file name of each compressed report is Name_Output Format.zip. For example, if the delivery destination is email for Order.pdf and Invoice.xlsx reports, the order_PDF.zip and Invoice_XLSX.zip reports are attached to the email.

    Supports email, HTTP, Content Server, and Documents Cloud Service (Oracle Content and Experience Cloud) delivery channels.

    In the Report Job History page, if you view the details of a job that was configured with the Compress output prior to delivery option, and then click Send in the Output & Delivery section, the delivered output isn’t compressed.

Add Destination Types to Report Output

Enter delivery details in the report’s Destination region to deliver a report to multiple destinations.

Administrator must set up the delivery servers in the Administration page.
To add destination types to report output:
  1. From an existing report in the Report Viewer, select Actions, and then select Schedule.
  2. In Schedule Report Job, click the Output tab.
  3. In the Output tab, open Destinations, and from the Destination Type list, choose a destination type.

    Only those destination types set up by your administrator are displayed in the Destination Type list.

  4. For each destination, from the Output list, select the documents to send to the destination.
  5. Click Add Destination to deliver a report document to multiple destinations.
  6. Select Save Output to view the output from the Report Job History page.

Report Output Destination Types

Select and define the destination types for your report’s output in the Schedule Report Job page.

Only the destination types configured by the administrator are available for selection. You can add multiple destinations for the report’s output.

Destination Type Description
Email

Enter multiple email addresses separated by a comma.

Enter any message text to include with the report. To format the message text, you can use HTML 4 elements such as fonts, lists, table cells, hyperlinks, and embedded GIF images.

Use these options to configure a notification for email receipt and email read.

  • Request Delivery Status Notification

    Select this option to email a notification message to the sender when the email delivery is successful, delayed, or failed.

  • Request Read Receipt

    Select this option to email a notification message to the sender when the recipient opens the email message.

Printer

Select the printer group and the printer, enter the number of copies, and then select single sided or double sided (the printer must support duplex printing for this option to take effect). Optionally, select the printer default tray from which to print the report, and the print range pages.

Fax

Enter the fax number to which to send the report.

FTP

Enter valid user name and password credentials for the FTP server.

Specify the following properties:

  • Remote Directory

    (Required) Enter the delivery directory location, for example, /pub/.

    To deliver the document to the user's home directory, enter . (period).

  • Remote File Name

    (Required) Enter the file name for BI Publisher to assign to the delivery document on the remote server, for example, myreport.pdf.

    You must include the file extension in the name, for example, .pdf .

    You can assign a file name dynamically using a date expression.

Content Server

To limit access to the report on the content server, assign a Security Group and Account to the report. Oracle BI Publisher retrieves the Security Group and Account values configured for the content server.

Oracle Content and Experience Cloud

Select CEC and the destination folder.

Content Server Destination Type Properties

Content Server is one of the destination types to deliver your report document. Select the content server where you want the report delivered.

Use the information in this table to enter appropriate values for the Content Server properties.

Property Name Description
Security Group (Optional) Select the WebContent Server security group to assign to the report.
Account (Optional) Select an Account within the Security Group to assign to the report.

You can enter values for the following required metadata fields. If you do not enter values for these fields, the values from the default report information apply.

Author (Optional) enter a value for Author. If you do not enter an Author, your user name is used for the Author metadata field on the WebContent Server.
Title (Optional) Type a Title for the report. If you do not enter a Title, the Layout name is used for the Title on the WebContent Server.
File Name Enter the file name to assign to the delivered document on the remote server, for example, myreport.pdf. The File Name field is used as the Native File Name on the WebContent Server. If you do not supply a file name value, the Output name is used.
Comments (Optional) Type a description to include with the document on the WebContent Server.
Include Custom Metadata The Include Custom Metadata option is only available if the data model for the report includes a Custom Metadata component. When you select the Include Custom Metadata option, the delivered document includes the custom metadata fields specified in the data model.

When you can configure an embedded parameterized report to display online, the parameters display the appropriate values from an analysis or a direct connection to a subject area. When you schedule a an embedded parameterized report, the parameters from the analysis are not passed to the report. As a result, the report displays default values of the parameters used in the analysis. For a direct connection with a scheduled report, the parameters are passed and the values are displayed correctly in the report.

Add Outputs

You can create multiple report documents for one or more layouts using a combination of output format, locale, time zone, and calendar.

To add outputs to the report job:
  1. From an existing report in the Report Viewer, select Actions, and then select Schedule.
  2. In Schedule Report Job page, click the Output tab.
  3. In the Output tab, click + to add an output.
  4. In Name, type a name for the output.
  5. Select the options to use from the Layout, Format, Locale, Timezone, and Calendar lists.

    The output format is the type of document that is generated, for example, PDF, HTML, or Excel. The options available here are specified in the report definition.

    Locale defaults to the Report Locale defined in the user Preferences. If the layout does not have an available translation for the selected locale, BI Publisher applies a locale fallback logic to select the layout. The appropriate number and date formatting are applied independently of the template translation.

  6. Click Save Output.