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 Oracle Technology Network.
Once BI Publisher is installed, a Word document menu appears with an ‘Add-Ins’ option:
The report development steps for a typical BI Publisher report in OTM are: