Sunday, October 23, 2011

Multi-sheet Excel output with BI Publisher in eBusiness Suite R12

Oracle Support released note 1343225.1 (How to add Microsoft Excel as Type to the Create Template List of Values in BI Publisher). The note refers to a couple of patches that are required for eBusiness Suite to enable using Microsoft Excel templates with the embedded version of BI Publisher.


The details on using MS Excel templates are in the chapter titled "Creating Excel Templates" in Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher Release 11g (11.1.1) Part Number E13881-02.


I tried it out within 2 days of the note being published and I haven't been able to get legible output when running a concurrent program that uses a MS Excel template. The BIP development team at Oracle is working on bug 13002685 to provide a solution.


Once the solution is in place, not only do you have more options to create MS Excel output, you can create multi-sheet Excel output. Take a look at support note: 1352000.1 : BI Publisher: How to create Multisheet in Single Excel file using Excel Template.



No comments:

Post a Comment