Using Oracle BI Publisher

This section describes the steps for creating a custom report using the Oracle BI Publisher Desktop tool.

Creating the custom report

  1. Select Reports, select Configure Reports, and then select Create Reports.

  2. Enter or select the Property.

  3. Select a Report Group. For example, Confirmation Letter, Folios, Registration Cards, and so on.

  4. Select Customized Report for the Report Type.

  5. Select the Sample Report to base your Customized Report on by clicking the search icon next to the field, selecting a sample report, and then clicking Select. This is the Rich Text Format (RTF) file.

    Figure 8-1 Sample Report to base your Customized Report


    This figure shows the Sample Report to base your Customized Report field.
  6. Click Download Sample Report and click Download Sample Data to download the sample report and sample data.

    Figure 8-2 Download Sample Report and Sample Data links


    This figure shows the Download Sample Report and Download Sample Data links.

    Note:

    Once downloaded, the files are located in the default download folder (that is, the Downloads Folder on your local machine).

  7. Navigate to the file location and right click the downloaded file and then click the Show in folder option. You can also navigate to the preset download folder to open or view the file.

    Figure 8-3 Show in folder option


    This figure shows where to click on the downloaded file and select the Show in folder option.
  8. Rename the .rtf file (that is, the sample_folio) per your requirement and ensure the updated name does not begin with “SAMPLE.” No name changes are needed for the XML files. Right click the .rtf file and then select the Rename option to change the name.

    Figure 8-4 Rename File


    This figure shows the rename option for renaming the .rtf file.

  9. Customize the file as needed and then save the file.

  10. Save the file and close it.

  11. Upload the customized file by clicking Choose File and then select the .rtf file (that is, the customized file) from the location and click Open.

    Figure 8-5 Choose File


    This figure shows the Choose File button.
    Once Uploaded, the file display name in the Display Name field automatically updates to the uploaded .rtf file’s name.

    Figure 8-6 Display Name matches the uploaded .rtf file’s name


    This figure shows the Display Name matching the uploaded rtf file’s name.

  12. Enter the number of Print Copies based on your requirements (for example, enter 1 or 2).

  13. Enter or select a Language based on your requirements (for example, English).

  14. Add Report Parameters if needed.

  15. Click Save.

Running the report

This section describes the steps to validate the customization for the sample reports.

  1. Select Bookings, Reservations, and then Manage Reservation.

  2. Select Departures for the Search Type and then click Search. Verify the search results only contain departure reservations.

  3. Select any reservation with a balance.

    Figure 8-7 Select a reservation with a balance


    This figure shows a reservation with a balance being selected.

  4. Click I Want To... and then select Go To Billing.

  5. On the Billing screen, click the Information Folio link.

    Figure 8-8 Information Folio link


    This figure shows the Information Folio link on the Billing screen.
  6. Select Preview to Print for the report destination option on the Folio Print screen. Click Process.

    Figure 8-9 Folio Print


    This figure shows the report destination options on the Folio Print screen.
    The Folio appears with the configured customized report.

    Figure 8-10 Custom Folio PDF


    This figure shows the custom folio PDF.
  7. Open the PDF to view the report with folio details.

    Figure 8-11 Custom Report Output


    This figure shows the custom report output.

Parent topic: Oracle Business Intelligence (BI) Publisher