Siebel Reports Integration to Oracle BI Publisher

History and Introduction: Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and Peoplesoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.

BI Publisher separates the creation of data from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Servicesor any data source available through JDBC. BI Publisher can merge multiple data sources into a single output document.


BI Publisher allows reports to be designed within Microsoft Word or Adobe Acrobat and other familiar desktop environments, therefore doing away with the requirement of having specific reporting skills. Users can choose among a variety of different output formats, such as Word RTF, Microsoft Excel XLS, Adobe PDF, and HTML before the report output is generated. In addition to the ease of development, BI Publisher also has the advantage of Fusion technology stack and will be the reporting tool for Fusion. The architecture of BI Publisher is structured so that reports can be produced in multiple language translations easily, and it supports Unicode throughout.

The Siebel 8.1.1 Reports Solution is based on a loosely coupled architecture where BI Publisher runs as a standalone Server. The integration point for Siebel Reporting will be through standard Web Services integration using Siebel EAI.

Key Features: 

Integration Features

• Siebel Reports Server will be integrated with Oracle BI Publisher Reports.

• SRF compilation not required to new report generation.

• Deployment of report file can be performed by the Siebel application administrator.

• Recompiling of reports is not required when upgrading to newer versions of the software.

• Quick solution for end-users to generate simple, short reports with flexible distribution formats.

• Issue reports in multiple languages, or containing mixed data from different scripts (e.g. English, Russian, Arabic, and Chinese in the same report).

• BI Publisher is the reporting Server for other Oracle products such as E-Business Suite, Siebel Analytics or Peoplesoft, thus making the look and feel same across the corporate landscape.

• Additional output formats like RTF, XLS, HTML and PDF available out of the box

• Flexibility to create custom based report templates for easy report generation, existing  standardized corporate documents such as forms, contracts etc can be re-used.

• Easily configurable data abstraction from the repository using Integration Objects

• Reports that have complex data requirements like multiple business objects.

• Ability to pass parameter before report generation

• Heavy usage of Report server functionality including batch mode generation or scheduling

• Requirement for complex layouts

• About 150+ out of the box report templates will be shipped as part of the release


Deployment Options

• A complete solution for the Siebel Reporting solution across the various releases (7.7, 7.8, 8.0, 8.1.x) of the Siebel product. The Siebel 8.1.1 integration to BI Publisher has also been ported to earlier Siebel releases.

• The BI Publisher integration can co-exist with the Actuate integration for generating Siebel Reports

• A free migration tool (Actuate Conversion Assistant) is available to migrate Actuate reports to BI Publisher.

• BI Publisher enterprise can be deployed independently or deployed as part of OBIEE.



  1. Oracle Corporation
  2. Wikipedia

Leave A Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!