11i Oracle XML Publisher Fundamentals - Self-Study Course

Starting with the basic concepts, architecture, and underlying standards of Oracle XML Publisher, this course will lead a student through a progressive series of exercises building their expertise. By the end of the course, the student should be able to create Oracle XML Publisher templates in RTF and PDF formats. They should also be able to deploy those templates to an Oracle BI Publisher Enterprise server and an eBusiness Suite instance.

Learn To:

• Understand the basic concepts and uses of Oracle XML Publisher
• Understand the underlying X standards
• Create and use an RTF template
• Create and use a PDF template
• Set-up, configure, and use Oracle BI Publisher Enterprise server
• Deploy, create, and modify templates on an e-Business Suite instance

Audience

• Business Analysts
• Business Intelligence Developer
• Functional Implementer
• Reports Developer
• End Users
• Technical Consultant

Course Topics Course Overview Introduction

• Understanding XML
• Classic Reporting Tools Issues
• Advantages of Oracle BI Publisher
• Oracle BI Publisher Technology

Working with Oracle BI Publisher Desktop

• Installing Oracle BI Publisher Desktop
• Running the Installer
• Understanding Oracle BI Publisher Desktop
• Creating an RTF Template
• Understanding Field Properties
• Creating a Chart

Oracle BI Publisher Architecture

• Components of Oracle BI Publisher
• Architecture of Oracle BI Publisher

Introduction to the Standards

• XML Standards Objectives
• Components of XML Documents
• Well-Formed XML Documents
• Creating an XML Document
• Editing XML
• Understanding XML Namespaces
• Document Type Definition
• Understanding the XML Schema

Introduction to the Standards, cont.

• Creating an XML Schema Document
• Using the JDeveloper XML Schema Editor
• Registering an XML Schema
• Using the XML Schema-Aware Editor
• Understanding XML Path
• Understanding XSL
• Understanding Template Rules
• Using XSLT

Installing Oracle BI Publisher Enterprise

• Installing Oracle BI Publisher Enterprise 5.6.2
• Installing Oracle BI Publisher Enterprise 5.6.2 on Windows
• Installing Oracle BI Publisher Enterprise 5.6.2 on Linux
• Installing Oracle BI Publisher Enterprise 5.6.2 Patches

RTF Templates

• Using the Basic Method
• Editing an RTF Template
• Understanding BI Publisher Template Viewer
• Viewing the Report
• Using the Form Field Method
• Creating a Template Using the Form Field Method
• Previewing the Report
• Associating XML Data

RTF Templates, cont.

• Designing Template Layouts
• Designing Template Layouts
• Image, Charts, and Graphics
• Data-driven Shape Support
• Template Features
• Conditional Formatting
• Page-level Calculations
• Data Handling, Variables, Parameters, and Properties

Working with Oracle BI Publisher Enterprise Edition

• Accessing the Administration Options
• Oracle BI Publisher Enterprise Server Administration
• Working with User Roles
• Understanding Other Admin Options
• Working with Reports
• Understanding Report Actions
• Using the Online Analyzer
• Working with the Analyzer

Working with Oracle BI Publisher Enterprise Edition, cont.

• Creating a New Folder
• Understanding Folder Actions
• Creating a Query
• Understanding Folder Actions
• Creating a Query
• Translating Reports
• Using the XLIFF Option
• Understanding XLIFF Files and Adding a Report File Translation

Other Templates

• PDF Template
• Adding Markup
• Field Properties Options
• Adding a Check Box
• Working with PDF Template
• ETEXT Templates

Integration with Oracle BI Enterprise Edition

• Publishing a Report from the Answer Request
• Creating Answers Request
• Creating a Report
• Publishing a Report from BI Server
• Creating a Query

E-Business Suite Development Suite

• Creating an XML Publisher Solution
• Searching and Modifying and Existing Report
• Modifying a Report

Building a Data Template

• Understanding the XML Publisher Data Template
• Creating the XML Publisher Data Template

Advanced eBusiness Suite Concepts

• Understanding FSG Templates
• Using Specialized Fonts
• XML Publisher Bursting
• Migrating Oracle Reports to XML Publisher

Administration in 11i eBusiness Suite

• Customize the Behavior of BI Publisher
• Moving Templates and Data Definitions

XML Publisher Report Standards

• General Guidelines
• Report Layout Guidelines
• Data Formatting in a Report

Course Objectives

• Create and use a portable document format (PDF) template
• Create and use an rich text format (RTF) template
• Deploy, create, and modify templates on an eBusiness Suite instance
• Describe the underlying XML standards
• Explain the basic concepts and uses of Oracle XML Publisher
• Set up, configure, and use the Oracle BI Publisher Enterprise server