Oracle Bi Publisher Reports - Fusion Erp

eText, RTF and Excel Templates - and Misc Topics

What you'll learn

Oracle Fusion ERP - Different Reporting Methodologies

RTF Template Styles

Excel Template Styles

Etext Template STyles

Requirements

Basic SQL Knowledge is nice to have

Description

Greetings From OraTrainings – Welcome to Oracle Fusion ERP – BI Publisher Course.Business Intelligence Publisher from Oracle is an advanced reporting solution that helps users in creating, managing and delivering documents or reports faster than traditional tools. Oracle BI Publisher is the reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser or familiar desktop tools to create everything from pixel-perfect customer facing documents to interactive management reports against practically any data source. View reports online or schedule them and deliver tens of thousands of documents per hour with minimal impact to transactional systems.Oracle BI Publisher course curriculumWhy should you learn Oracle BI Publisher?BI Publisher Course is in high demand as this is the main skill for the Oracle Fusion ERP which is the Robust ERP in the worldBI Publisher requirements are mandatory for every client who implements Oracle Fusion ERPWho this course is for:Oracle ERP ConsultantsOracle BI Technical ConsultantsOracle Database DevelopersIT Consultants Interested to sail through Oracle ERP CareerOracle BI Publisher DevelopersOBIEE Technical DevelopersOracle Cloud Report DevelopersBI ProfessionalsBusiness & Technical AnalystsSoftware DevelopersApplication DevelopersOracle BI Publisher course curriculum1. Introduction2. Layout Editora. Sample Demo3. RTF Templatesa. Sample Demob. Group Reportc. Bind Parameters and List of Valuesd. Dynamic Images4. Excel Templatesa. Basic Excel Template Demob. Multi Sheet Excel Report Democ. Master Child Excel Report Demod. How to Split Data Into Multiple Sheetse. How to perform Sum and Count in Excel Template5. eText Templatesa. Sample Demo6. Migration7. Miscellaneous Approachesa. Invoke BIP Report Using SOAP/Pythonb. Customize Standard AR Invoice Reportc. Schedule BIP Reportd. BIP Audit Reportse. Display Invoke/BIP Report from Fusion Pagef. RTF-BIP Report Translation

Overview

Section 1: Introduction

Lecture 1 Data Model DeepDive

Section 2: Layout Editor

Lecture 2 Layout Editor Overview - Sample Report

Section 3: RTF Templates

Lecture 3 RTF Template Overview

Lecture 4 Group Report - Using Single Group and Multi Group Data Model

Lecture 5 Bind Parameter and List of Values

Lecture 6 Dynamic Images-From Database

Lecture 7 Display QR Code and PDF417

Lecture 8 Dynamically Display Logon Based on SubTemplate

Lecture 9 Pivot Table

Section 4: Excel Templates

Lecture 10 Basic Excel Sample

Lecture 11 How To Design Multi Sheet Report

Lecture 12 How To Design Master Child Report

Lecture 13 How To Split Data Into Multiple Sheets

Lecture 14 How To Split Data Into MultipleSheets Using ROW COUNT Logic by XSL File

Lecture 15 How To Perform Sum and Count in Excel Template

Section 5: eText Template

Lecture 16 eText Template Overview

Section 6: Migration

Lecture 17 BI Components Migration

Section 7: Misc

Lecture 18 Invoke BIP Using : SOAP UI - Python - ReportService WSDL

Lecture 19 Customize standard report and data model - Print Receivables Transactions

Lecture 20 Schedule BIP Report

Lecture 21 BIP Audit Reports

Lecture 22 Display/Invoke BIP Report Via Link From Fusion Page

Lecture 23 RTF-BIP Report - Translation

Anyone Who is Interested To Explore Oracle Business Intelligence Reports in Oracle Fusion ERP