Oracle BI Publisher/OTBI &( FRS,SmartView)- Fusion ERP

Create simple, interactive reports with the Oracle Fusion ERP layout editor. Drag and drop a single-table layout from a data model to view output in HTML, PDF, Excel, or PowerPoint.

Rtf template overview in oracle bi publisher for fusion erp; learn data model creation, xml data, and word-based template design to produce pdf, html, doc, excel, csv, and xml outputs.

Explore grouping in Oracle BI Publisher templates using single and multi group data models, with a sales order example showing header and line data and group by logic.

Learn to use bind parameters and list of values in templates, with data models and the concept of a dependent parameter for a sales order report.

Display dynamic images in BI Publisher reports by pulling blob data from the per_images table. Apply in-stream or URL syntax and set image height and width for correct rendering.

Learn to display QR code and PDF417 barcodes in Oracle BI Publisher for Fusion ERP using 2D barcode tags and size parameters.

Learn to create and test sub templates in Oracle Fusion to dynamically display logos by business unit and address in a main template, using import and call template commands.

Learn to build a pivot table in Oracle BI Publisher by creating a data model, grouping by ledger and period, and generating layout-ready reports without custom logic.

Learn to format numbers using the format hyphen number and dates using format date in Oracle BI Publisher, plus Word-based formatting and conditional cell styling.

Use section logic to split data in Oracle BI Publisher templates, turning a for-each into per-invoice pages by linking header and line data and generating separate PDFs.

Master if, if-else, and choose-when logic in Oracle BI Publisher templates to render bill-to country and state data from xml.

Learn to create and apply a style template in Oracle Fusion BI Publisher to enforce consistent headers, footers, logos, and formatting across reports, with data model and template setup.

Design and publish an Excel template in Oracle Fusion ERP using BI Publisher, map data to the template, and generate XLS, XML, or CSV outputs.

Design a three-sheet Excel report by building a data model with independent queries and creating a template with repeating groups, then upload to BI Publisher.

design a master detailed report in excel using a data model and repeating groups, linking party and accounts, exporting sample data, and testing the template for fusion ERP.

Learn how to split data into multiple sheets in an Excel template using underscore sheet logic and sheet name patterns, including business unit names and invoice counts.

Split Excel data into multiple sheets by row count using an XSLT preprocessor and Excel template in Oracle BI Publisher OTBI Fusion ERP, with data model tweaks.

Master the calculation of group totals and line counts in an Excel template for Oracle BI Publisher by grouping header and lines, summing extended amount, and counting lines per invoice.

Learn to design eText templates in Oracle Fusion Cloud with RDF templates, producing delimiter based or fixed length outputs (CSV, text, XML) from data models, tested via the template viewer.

Generate a csv output with a delimiter based BI Publisher text template in a tab-delimited format, illustrating master-detail data with department as the parent and employees as the child.

Compare two template types in Oracle Fusion BI Publisher: Excel style sheet and XSL-FO templates. Learn their output formats and when to use each to tailor XML and PDF outputs.

Master OTBI foundation in Fusion ERP by navigating subject areas, building analyses, and exporting outputs (PDF, Excel, CSV, XML), plus archiving and unarchiving for deployment across instances.

Learn to create OTBI analysis prompts for payables invoices in real time, including analysis-level and table-level prompts, to enable runtime input for filtering data.

Explore the distinction between logical and physical queries in OTBI, learn how to identify the underlying physical tables, and use database lineage mappings to align subject areas with columns.

Build a master-child analysis by creating a master and detail analyses, linking on registry id, and using prompts to pass parameters and navigate between analyses.

Explore OTBI column properties to customize style, format, data and conditional formatting, including hiding columns, custom headings, suppressing repeats, date formats, and conditional colors for invoice data.

Create a vertical bar chart in OTBI by turning a payable invoice analysis into a graph with fields: business unit name, legal entity, invoice amount, and payment terms, with prompts.

Learn to implement a master-detail interaction in Oracle Fusion OTBI, configuring a master-detail event between a table view and a graph, with the general category as the prompt.

Learn to check how many times an OTBI analysis runs using the OTB performance real time subject area, with start date and end date filters and aggregated counts.

Learn to display a custom error message in OTBI by configuring a custom message in analysis properties with a header and message when no results are found.

Enable the descriptive flexfield on the AP invoice, enable its BI flag, deploy the flexfield, run the data extract job, and display the DF attribute in OTBI analysis.

Learn how to use top end and bottom end aggregate functions in OTBI analysis, and apply ease in top and bottom filter criteria to fetch top or bottom records.

Create a dashboard by combining two otbi analytics and a vip report, powered by a data model. Arrange pages with drag-and-drop to include the two analyses and the vip report.

Create an analysis with a prompt, build a dashboard with a dashboard prompt, and run the supplier number filter to view results in Oracle BI OTBI.

Learn to migrate oracle fusion bi components and reports between instances using archive, unarchive, upload, and download. Leverage soap api catalog service and automation via visual builder studio for deployment.

Explore invoking Oracle BI Publisher reports via SoapUI and Python using the report service WSDL, passing ledger name parameters, and decoding base64 outputs to CSV.

Learn to customize a standard Oracle report by copying the print receivable transaction to a custom folder, updating the template and data model, and mapping to the custom data model.

Learn how to schedule a BI Publisher report as a job, configure output, and monitor status via history and job output.

Explore auditing in Oracle Cloud ERP with audit reports, using a dedicated data source and the publisher_view to track CRUD actions, and compare standard against custom audit reports.

Learn to invoke a BIP report link from Fusion pages using page composer and structure tools, creating a sandbox and a static link that opens in a new window.

Use xliff translation to create multilingual oracle reports by defining source and target languages with language codes, and test outputs at runtime via scheduler and end-to-end jobs.

Hide a standard BI catalog folder for non-admin users with custom webcat reporting duty. Use Oracle BI Publisher and OTBI security console to import user and role application security data.

Learn to design a BI report with a value set parameter and configure an SS job, including value set creation, sources, and testing for correct report output.

Learn to build a VIP report in an ESS job using dependent value sets, with an independent ledger value set and period value sets that drive the period name options.

Learn how to pass comma separated values to a BIP/VIP input by splitting the CSV into multiple rows with regex substr and connect by level, enabling an in clause.

Learn to display amounts in words in a bi report using an rtf template, via the x2x check number function with amount, currency, case, and decimals on an invoice model.