Oracle Cloud Reporting: OTBI and BI Publisher

Comparison of two of the main reporting options within Oracle Cloud footprint

Your organization has decided to move to Oracle Cloud, but have you determined a reporting strategy? What reporting tools will your team be leveraging? The post explores two of the main reporting options within your Oracle Cloud footprint, and offers comparisons as well as scenarios to consider when determining your reporting strategy.

OTBI & BI Publisher eBook

Download the OTBI & BI Publisher eBook!

What is Oracle Business Intelligence (BI) Publisher?

Oracle Business Intelligence Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence throughout an organization. BI Publisher can be used as an alternative reporting solution to OTBI. Some of the data sources available are SQL Query, XML, HCM Extract, and View Object (brought in through web service, ADPI, etc.).  BI Publisher works as an enterprise reporting solution for authoring, managing, and delivering reports from multiple data sources in multiple formats through multiple channels (E.g., checks, invoices, remittance, etc.). Utilize BI Publisher for writing your own SQL query, formatting reports, joining historical data with real-time information, and report bursting. Typical end users include Technical Human Resource Information System (HRIS) and IT Developers.

What is Oracle Transactional Business Intelligence (OTBI)?

OTBI provides a flexible and easy to use analysis tool that helps to gain real-time insight into transactional data.OTBI is aimed at business users and especially shines when the report creator is someone who does not know SQL and/or the underlying table structures. OTBI’s core functionality allows users to simply drag and drop selected data from subject areas and use different graphical views. Data can be filtered, drill-down can be enabled, and action links can be created. Reports or dashboards can be scheduled for delivery and reports can be exported to Excel, Word, and other formats. A reporting wizard (BI Composer) is available to guide casual business users through a few simple steps to run, edit or create OTBI reports and queries. Typical end users include Financial Analysts, Compensation Analysts, Benefit Analysts, and Human Resources Analysts. Which Reports Best Suit Your Organization’s Needs? Scenario 1: I just converted workers from PeopleSoft and need to validate the employees that loaded in Cloud

  • Answer: A direct database query to a single cloud table using BI Publisher

Scenario 2: I need a headcount report by Business Unit and Grade

  • Answer: Great candidate for OTBI, you can make the report drillable to get down to employee detail and even place as an infolet on employee homepage

Scenario 3: I have a highly formatted payslip that needs to be customized

  • Answer: BI Publisher and HCM Extracts

Compared: OBTI vs. BI Publisher

BI Publisher & OTBI Comparison


In choosing a reporting tool, there are a couple of key takeaways to keep in mind. Consideration of scalability is important, especially when it comes to payroll reporting or returning large amounts of data in general. Typically, HCM extracts are most scalable, then OTBI, then BI Publisher. Data security is also an important consideration. OTBI is more favorable when you want to use front end security configurations to which data returns on your report. If you want to bypass front end security or build in your own security parameters, BI publisher would be the tool. Both tools work well for the creation of reports. On projects where the decision to go with either OTBI or BI Publisher is a coin flip, Oracle tends to recommend OTBI. The tyical business user will probably prefer using OTBI due to OTBI enabling the customization and creation of user-friendly dashboards in a drag-and-drop fashion, whereas BI Publisher does not. Oracle maintains the presentation layer, so any changes to underlying tables Oracle will update, and thus keep your reports “upgrade safe”.   BI Publisher is more favorable for technical users and when the desired result is not a report, but data. BI Publisher is one of the primary ways of getting data out of Oracle Cloud (HCM Extract being the other). Users who are technically savvy enough to be using one of the other data source options such as web services would probably prefer the control of BI Publisher. There is also a set of APIs that allow retrieval of BI Publisher data in non-Cloud code.

Want to learn more? View our webinar recording for “Cloud Reporting: Pain Points and How to Solve Them” here.


  • Maddie Caron

    Ms. Caron serves as Elire's Marketing Specialist, specializing in content writing and digital media communications. Maddie works to deliver relevant industry updates and technical blog posts to educate and engage Elire's audience.

Recent Posts

Related Posts

Sign up for newsletters

Want to Learn more?

Explore our upcoming Events & Webinars

Register now