BI Publisher - K | slideum.com

BI Publisher - K

Download Report

Transcript BI Publisher - K

Introductions

Suren Veeramasuneni SOLBOURNE Senior Consultant Email: [email protected]

Overview

What is BI Publisher?

Where is BIP used?

How is BIP used?

Reporting Methods

Traditional Reports Rigid design Complicated development Low-fidelity XMLP Reports Provides Separation of source and formatting Offers User-friendly development tools Multiple templates per data source Eases distribution Dynamically generated at run-time Hi fidelity

Report Types

XMLP Supports Seeded EBS Reports Can be modified to work with XMLP Registration of templates automates generation process XMLP Supports Custom Reports Supports Wide range of data sources Based on existing Oracle Apps report DBMS_XML PL/SQL output SQL Queries Other PL/SQL Supports Seeded concurrent manager processing Offers Various output formats for reports

XMLP Technology

How does XMLP work?

Data XML Generated by PL/SQL, sql queries, dev6i reports, etc.

Layout Template built using MS Word RTF, Adobe Acrobat forms Many templates can be associated with one data source.

Report output PDF RTF XML EDI Excel EFT HTML Results are managed by XMLP Delivery Server Printer HTTP/S

Email

FTP

FAX

WebDAV

RTF Templates

MS Word is used to create layout for reports XMLP converts from RTF to XSL-FO automatically Layout, paginate, and render to different formats Allows for flexible delivery to fax, email, or printer At runtime, RTFs are converted to XSL-FO RTF templates can be used to manually create XSL FO

XMLP in Oracle Applications

Step-by-step process in Oracle Applications: Concurrent request submitted Request identified program used to generate XML Template selected at submission Concurrent request generates XML data Output Post Processing Engine initiated OPP started with concurrent program short name XMLP template registered with corresponding CP short name located OPP uses BI Publisher Java backend to generate output

Oracle Applications and XMPL

BI Publisher 10.1.3.3 installed on Oracle Application Server 10.1.3.1.0 or later For Apps versions older than 11.5.10, AOL patch 3435480 provides limited XMLP support.

For Apps versions 11.5.10, PASTA will support PDF printing. In 11.5.10.2, PASTA comes installed.

PASTA is a PS printer PDF Publisher print style and PASTA_PDF printer driver provide printing support Metalink notes 338990.1 and 356501.1 discuss PASTA setup

The Future and BIP

Dev6i reports replaced by queries feeding XML Publisher / BI Publisher Oracle initiative to replace all seeded reports with XMLP output Direct-database query support (Stand-alone BIP) Licensing BIP (XML Publisher) with Oracle Apps BI Publisher Can create any web-service available XML as a source Can execute DB queries directly from inside BIP Stand-alone reporting server (think Crystal or Optio)

Reporting in E-Business Suite

Beginning with Oracle E-Business Suite 11.5.10, some reports are delivered with the XML Publisher components and therefore will not require any additional setup.

For those reports not delivered with XML Publisher components, following setup steps are required: 1. Set the report concurrent program to generate XML. This can be achieved by changing the Concurrent Program Report Output Type to XML in the Concurrent Programs Window 2. Create a layout template for the report using Microsoft Word 3. Register the concurrent program as a Data Definition in XML Publisher's Template Manager.

Run the report and view output If output is not available, then run the ‘

XML Report Publisher

’ concurrent program with the request id of the original report. Note: Some of the Oracle Reports are not integrated into XML Publisher.