Report Development - Sample Report

Note: This post applies to OTM version 6.x — Query and Format template based reports.

In OTM, you can develop a report with basic knowledge of SQL, PL/SQL, and Oracle BI Publisher. Report developers need to install Oracle BI Publisher Desktop from the …

Report Workspaces

If you want to restrict users to running or viewing only specific reports, you can use the Report Workspace feature in OTM. The steps below restrict a list of reports to a particular user or user role.

Step 1 — Configure the Report Workspace

Configuration …

Emailing Reports to Users on a Business Event

OTM can automatically generate a report and email it as an attachment when a business event occurs. The example below shows how to send a custom report to the user who created a purchase order when a shipment tender is accepted.

Step 1 — Create a Report …