Telephone: 0870 100 4002
E-mail:  This email address is being protected from spambots. You need JavaScript enabled to view it.

Oracle BI Publisher (Part 1)

Accountants love spreadsheets! Retrieving data from Oracle E-Business Suite (EBS) to Excel has never been easy and so in the past, most customers have cobbled together their own solutions for doing this such as CSV, macro’s etc.

So how can Oracle “standard” reports in R12 be easily converted to output to an Excel spreadsheet? BI Publisher makes it much easier to do – and the new “True Excel” functionality is a powerful new feature.

BI Publisher (“Business Intelligence Publisher”, also known as BIP and XML Publisher) has been available in EBS R11 for a number of years. Oracle Reports is no longer available in Oracle Fusion, where BIP becomes Oracle’s de-facto reporting tool for EBS, therefore BIP is being increasingly used in EBS R12.

BIP has always been capable of forcing spreadsheet programs to open its output, but this was not in a true binary file format, rather XHTML output was used instead. This relies on spreadsheet programs being able to convert XHTML into a viewable spreadsheet format, something Excel (from version 2003 onwards) is able to do.

However, there are significant limitations to this approach – primarily an inability to fully leverage the formatting and formula functionality in spreadsheets. Also, output was limited to a single spreadsheet tab.

With very little fan-fare, Oracle recently added new Excel functionality to 11g BIP. Oracle calls this functionality “True Excel” – templates are developed using Excel, and can more fully leverage the functionality of Excel. With even less fan-fare, Oracle have back-ported this functionality for BIP 10g in both EBS R11 and R12.

The most significant difference between BIP and traditional reporting tools (such as Oracle Reports and SQL*Plus) is that BIP completely separates the selection of source data from the formatting of the data layout for presentation.

The theory is that while data selection remains a task for a technical IT resource, the layout of the data can be done by a functional resource. In practice, complex data layouts have remained a task for a technical IT resource, with functional resources only capable of minor changes such as fonts, boiler-plate text and logos.

However, one real advantage of the separation is that multiple layouts can be developed for a single selection of source data. Once these formats are defined in the BIP application, and are linked to the relevant concurrent program, EBS users have the ability to select which format they want when submitting a concurrent request.

Therefore, to partly answer the question, EBS users can easily select at run-time to output a concurrent program request in Excel format, BUT only if an Excel layout has been developed for the concurrent program.

In my next blog I’ll go on to show you how to practically apply this new functionality, by running through some report conversion examples.

  • Desktop Integration Framework – not just a fairy tale   Long, long ago in a place far away, a Rocela consultant blogged about the Desktop Integration Framework (DIF). The blog read like a fairy tale – it described a mythical new tool
    Read More +
  • Scottish IT Consultancy Rocela Group bought by Irish IT Services Company Version 1 We are recruiting – take a look at our vacancies page!  Scottish IT consultancy Rocela Group, has today (Monday, 13th January 2014) been acquired by Irish
    Read More +
  • Let’s imagine Let’s imagine for a moment it’s a perfect world and in that perfect world you have a large team of fully trained Oracle specialists lovingly managing the day to day health of your IT infrastructure, all
    Read More +
  • APEX 4.2 Early Adopters at the Ready! Oracle have just announced early adopters version of APEX release 4.2 A whole host of new functionality has been added to APEX proving not only that Oracle are committed to pushing
    Read More +
  • Top 5 Tips for upgrading customisations to R12 My colleague Ray Brown’s recent blog “Top 5 Tips for Oracle R12 Upgrade Success” highlighted how the cost of upgrading customisations can be a significant proportion of the total cost
    Read More +
  • Oracle BI Publisher (Part 2) So in this post, I’ll run through some report conversion examples. Data selection can achieved with any tool that produces XML output. It’s easy to convert any standard Oracle Reports concurrent program – simply
    Read More +
  • Oracle BI Publisher (Part 1) Accountants love spreadsheets! Retrieving data from Oracle E-Business Suite (EBS) to Excel has never been easy and so in the past, most customers have cobbled together their own solutions for doing this such
    Read More +
  • Oracle R12 Upgrade Planning As one of Rocela’s Project Managers who is currently managing several clients through their Oracle R12 upgrade, I have developed a deep understanding of the challenges and successes, pitfalls and quick wins of an
    Read More +
  • ApEx Application Development Start as you mean to go on Before starting any development on an ApEx application using Oracle E-Business data, the setup of the ApEx development and production environment must be considered. There is no right
    Read More +
ISO9001RegUKAS-Col  best companies to work for  OUG Logo  investor in people 

UK Small logo

GPTW Scotland Logo