Master Oracle Fusion BI: Build & Analyze OTBI Reports

Master Oracle Fusion BI Publisher: Comprehensive Technical Training

Unlock the power of data visualization and reporting with this in-depth Oracle Fusion BI Publisher course. This online course provides comprehensive technical training for creating sophisticated reports within the Oracle Fusion Cloud environment (SAAS). Gain expertise in data analysis and business intelligence to drive informed decision-making. A certification may be available upon completion (check with Udemy).

Course Content Breakdown:

This course is structured to guide you from foundational concepts to advanced reporting techniques.

• Class 1: Introduction - An overview of Oracle Fusion applications and BI Publisher's role.
• Class 2: Oracle Fusion Application (SAAS) User Creation with Base Tables - Learn to manage users and understand the underlying base tables within the Oracle Fusion system.
• Class 3: Oracle Fusion BI Publisher - First Report - Build your first report and understand the core BI Publisher workflow.
• Class 4: Running the Report From Catalog - Learn to access and run reports directly from the BI Publisher catalog.
• Class 5: Running the Report From Fusion Application by Creating ESS Job - Automate report execution using ESS Jobs within the Fusion Application.
• Class 6-11: Report Layout Creation using Manual Method - Master report layout design, including properties, caching, formatting, and currency handling. Learn to create visually appealing and informative reports.
• Class 12: Style Sheet Template - Utilize style sheet templates for consistent and professional report styling.
• Class 13-16: Master Detail Report - Develop complex master-detail reports using element-level, group-level, and subgroup linking.
• Class 17-23: Expressions - Write powerful expressions to perform calculations, conditional logic (using IF, NOT, AND, OR), and utilize functions like MIN, MAX, ROUND, and SUM.
• Class 24-25: Working with Bind Parameters - Implement dynamic reporting with bind parameters, including independent and translated independent LOVs.
• Class 26: Bind Parameters with Table Value Set and $FLEX$ Concept in Fusion - Advanced bind parameter techniques leveraging table value sets and the $FLEX$ concept.
• Class 27: Sub Templates in BI Publisher - Create reusable report components using sub templates.
• Class 28-29: Multi-Lingual Reports - Develop reports that support multiple languages with BI Publisher and translation management. Includes testing procedures.
• Class 30: Oracle BI Publisher Bursting - Delivery Channel - Configure various delivery channels (email, fax, SFTP, FTP, print) for automated report distribution.
• Class 31: Oracle BI Publisher Bursting - Delivery Channel (Email) - Testing - Test and troubleshoot email delivery configurations.
• Class 32-36: AR Invoice Report Development from Scratch - Develop AR Invoice Reports from the ground up, including SQL query development, for-each and master-detail report types, and handling page breaks and repeating headers.
• Class 37: Sub Template with Parameter or Dynamic Logo Based on Business Unit Name - Create dynamic sub templates with parameters and logos based on business unit.
• Class 38-39: Limiting Lines per Page in RTF Logic & BI Publisher with Execution - Control report output length with line limits in RTF and BI Publisher execution.
• Class 40: Display Barcodes in BI Publisher with Execution - Integrate barcode functionality into your reports.
• Class 41: Working With Excel Templates - Utilize Excel templates for creating simple, master-detail, and multi-sheet reports.
  Future Topics:

This course will expand to include:

1. AP Check Printing Customization
2. ACH Payment File Customization
3. AR Invoice Customization
   Procure-to-Pay (P2P) Cycle in Oracle Fusion Cloud ERP:

Gain a practical understanding of the Procure-to-Pay cycle within Oracle Fusion Cloud ERP:

• Create Requisition
• Create Purchase Order
• Create Receipt
• Create AP Invoice
• Create Payment
• Post To GL
• Base Tables for Requisition
• Base Tables for Purchasing
• Base Tables for Receiving Transactions
• Base Tables for AP Invoice