E-Business Suite: BI Publisher 5.6.3 for Developers

Course Description

Starting with the basic concepts, architecture, and underlying standards of Oracle XML Publisher, this course will lead a student through a progress of exercises building their expertise. By the end of the course, the student should be able to create Oracle XML Publisher RTF templates and data templates. They should also be able to deploy and maintain a BI Publisher report in an E-Business Suite instance. Students will also be introduced to Oracle BI Publisher Enterprise. Learn To: Understand the underlying X standardsCreate and use an RTF templateCreate and use Data TemplatesDeploy and maintain BI Publisher Reports in an E-Business Suite instanceAdminister BI Publisher in an E-Business Suite instanceUnderstand the basic concepts and uses of Oracle XML Publisher

Skills Gained

• Describe the underlying X standards
• Create and use a rich text format (RTF) templates
• Understand the use of a portable document format (PDF) templates
• Explain the basic concepts and uses of BI Publisher
• Understand and use BI Publisher with E-Business Suite
• Describe BI Publisher Enterprise

Who Can Benefit

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

Prerequisites

• Working knowledge of E-Business Suite applications
• Working knowledge of report development and deployment in an E-Business Suite instance
• Working knowledge of Concurrent Processing in E-Business Suite

Syllabus

Introduction

• Understand course agenda
• Understand the basics of Oracle BI Publisher

Oracle BI Publisher Architecture

• Describe the components of Oracle BI Publisher
• Describe the architecture of Oracle BI Publisher
• Describe the technology of Oracle BI Publisher

Introduction to XML

• Describe the X Standards
• Understand XML, XML Schema, DTDs, and XSL

Introduction to BI Publisher Layout Templates Using the Basic Method

• Create a Template using the Basic Method

Installing BI Publisher Desktop

Using the BI Publisher Desktop to Build Layout Templates

• Explain the capabilities of RTF templates
• Describe the methods for RTF template creation
• Create an RTF template
• Create a Crosstab report
• Create a Chart

Advanced RTF Template Techniques

• Describe advanced RTF template capabilities including Markup, Charts and Shapes, Conditional logic, Page-level Calculations, and more

Modifying an E-Business Suite Report that was Created Using Oracle Reports

• Create and deploy an XML Publisher report
• Understand the E-Business Suite development process

Modifying an E-Business Suite Report that was Created Using BI Publisher

Building and Using a Data Template in E-Business Suite

• Understand data templates
• Create and associate a data template

Advanced E-Business Suite Concepts

• Discuss GL reports in XML Publisher
• Discuss XML Publisher bursting
• Discuss migrating reports from Oracle Reports to XML Publisher

Administering BI Publisher in an E-Business Suite Install

• Administration Options
• Discuss XML Publisher specialized font usage
• Discuss moving templates and data definitions between E-Business Suite instances

Understanding PDF and eText Layout Templates

• Describe the capabilities of PDF templates
• Describe other template formats

Translating Reports

• Describe the options for translating reports

E-Business Suite Report Development Standards

• XML Publisher development standards
• General E-Business Suite development standards

Introduction to BI Publisher Enterprise

• Access the Oracle BI Publisher Enterprise Server
• Executing a BI Publisher Enterprise Report

Create a Simple BI Publisher Enterprise Report Based on an Oracle Database Query

Oracle BI Publisher Enterprise Integration Features

• Discuss how to create a BI Publisher report created from an Answers request
• Discuss how to create a BI Publisher report created from a BI Server repository
• Discuss how to create a BI Publisher report from a Discoverer Workbook