Note: This post is applicable for OTM ver 6.x - Query and Format template based reports.

In OTM, you can develop a report with basic knowledge of SQL, PLSQL and Oracle BI Publisher. Reports Developer need to install Oracle BI Publisher Desktop version from Oracle Technology network.

Once BI Publisher is installed, Word document menu appears as below with ‘Add-Ins’ option:

Below are the report development steps for typical BI Publisher report in OTM.