Oracle Fusion Technical - BI | OTBI | BICC | FRS | SmartView

Learn how Oracle BI Publisher integrates with Fusion Cloud to create parameterized reports and dashboards, manage roles and privileges for reports and analytics, and export outputs via various options.

Learn to create a BI report by building a data model and template. Export data to XML, save sample data, and publish reports in PDF or other formats.

Develop a parameterized BI report by creating dependent parameters for source and invoice number, using lists of values, menu parameters, and dynamic filters with data model queries.

Explore how XSLT powers published reports in Oracle BI Publisher, contrasting XSLT transformations with BIP tags, VIP decks, and custom functions for charts and formatting.

Learn to create an rtf template with BI Publisher, build a report using sample data, map fields, sort by invoice number, handle no data with choose, and export to PDF.

Discover exporting BI report output to UCM or email attachments, scheduling deliveries, and configuring destinations like content server or email, with optional notifications and other export options.

Create a master-details BI report by building header and lines data sets and linking them with a group link, showing a header can have multiple lines.

Create an rtf template for a master-detail report in publisher, with a form header, line table, and totals in words using a data model and G1/G2 grouping.

create a master detail report in fusion by building a two-group data model joined on vendor id, using parameters to filter by supplier name, then design and export pdf report.

Create a master-detail bi report using subgroup by modeling a data source with header and line groups linked by the primary key, then build and format the report.

Learn how to implement bursting in the VIP reporting tool by adding a bursting query to the data model, scheduling the report, and delivering the PDF attachment via email.

Learn how to secure Oracle Fusion BI reports by assigning user-based access or application roles, configuring permissions, and verifying run and view rights through the catalog and data model.

Build a BI Publisher Excel template in Oracle Fusion Cloud by creating a data model from SQL, saving as a dot format workbook, and uploading for the AP Invoice Report.

Learn to print a barcode in a BI report by building a supplier-based data model, pulling invoices, and applying barcode font mapping to the invoice number in the template.

Enable pdf security on the VIP report to password protect the static output, using an open document password, save, and verify password prompts on view report.

Dynamically secure pdf report output by deriving the password from a data model field, the supplier number, updating the template with security properties, and validating access at runtime.

Learn to create and register a subtemplate in Fusion BI VIP reports catalog, then call it from a main RDF template to display business unit addresses based on a parameter.

Create fixed length, position based reports in a flat file using an etext template, detailing a payables invoice record with padded fields, uppercase invoice numbers, and formatted date and amount.

Learn to render multi-language bi reports by translating static content and dynamic data via language-aware data models and user session language settings.

Create a multilingual BI report by building a template, uploading an XLIFF translation, and validating outputs in English and French.

Learn to use XSLT and XPath in BI Publisher to transform Excel data into target documents, using templates, namespaces, value-of, for-each, and choose logic.

Develop a BI report using an SSL stylesheet and an XSL template by modeling data, defining parent-child relationships, exporting sample data, and generating a formatted Excel output.

Learn to customize the standard invoice print report by adding payment term and term description to the data model header, updating the template, and testing the new configuration.

Create the breed status report in Oracle Fusion BI by linking GL ledgers and statuses with a sql query, building the data model, and auto generate an RTF template.

Configure an ftp delivery channel for a secure sftp server using public private key authentication, including uploading the ssh private key, setting host, port 22, and test connection before applying.

Learn to schedule a BI Publisher report from Fusion, burst the CSV output to an FTP server, configuring destination, remote directory, and file name with optional notifications.

Learn to prepare a SoapUI payload and schedule BI Publisher reports via SoapUI, configure FTP delivery with CSV output, and track jobs with a generated job ID.

Learn how to work with enterprise scheduler service (ess) jobs in fusion cloud: define, submit, parameterize, secure, and monitor jobs, and review logs and csv or xml outputs.

Learn to create a custom enterprise scheduler job for a BI report in Oracle Fusion, define the job path and parameters, submit, and verify the output as a pdf.

Create a fusion cloud lookup for invoice sources, attach it as a list of values source for the invoice source parameter, and schedule the process to run.

Create value sets for invoice source and dependent invoice numbers, define independent and dependent parameters, and attach them to an ESS job for scheduled output in PDFs.

Secure a BI job by creating a function privilege, building a custom job role, and assigning it to a user so they can submit the job from scheduled processes.

Explore how to extract data from Fusion cloud using the report service web service, including preparing requests, invoking run report, and decoding base64 output into a PDF.

Automate Fusion data extraction by invoking the report web service from Java, converting base64 to pdf, and packaging as a parameterized jar with environment-specific properties.

Automate Fusion report invocation and data extraction by building an Oracle SOA Suite composite that calls the Fusion report service, decodes base64 output to PDF, and writes it to disk.

Learn to use Oracle OTBI in Fusion Cloud to build analyses, tables, graphs, dashboards, and drilldowns with predefined subject areas feeding ERP data for enterprise insights.

Create an OTBI analysis in the real time payables invoice transaction subject area by selecting invoice number, invoice amount, and supplier name, then save and view results.

Create a graphical analysis in OTBI to display the top five suppliers by invoice amount, edit the formula, sort data, and visualize supplier names with invoice amounts and percentages.

Create an OTBI dashboard using a dashboard prompt and AP invoice analysis, selecting payables invoice transaction real time subject area and the supplier name as the prompt, then run.

Learn to create a drill-down OTBI report by linking a supplier analysis to a detail analysis with a hyperlink, using prompts and presentation variables.

Create a BI report using OTBI analysis by building an analysis, extracting its SQL, and modeling data with a parameter-driven dataset to generate a payables invoice report.

Explore OTBI report security through role-based access control, using transaction analysis duty roles to secure subject areas and support custom job roles for reporting.

Learn to create and customize infolets on the Oracle Fusion home page using OTBI analyses, including predefined and user defined infolets, secured by roles and privileges.

Explore BICC, the Fusion SAS data extractor that creates CSV extracts from Fusion applications, plans public views, and loads data into warehouses with secure UCM storage options.

Create and provision roles in the security console to grant a user access to the console and content server, then verify role memberships and, if needed, retrieve latest LDAP changes.

Plan and create your first BICC extract in Oracle Fusion using OTBI, selecting public views for invoices, define offerings, data stores, and schedules.

Capture incremental data for an existing extract by running or scheduling the incremental job, adjust prune time lookback, and verify results before resetting to a full extract if needed.

Secure your BICC extract by enabling GPG encryption on UCM external storage, importing a public key, and decrypting with a private key, with optional signing and verification for data integrity.

Learn to build live profit and loss and balance sheet reports in the Oracle Fusion financial reporting studio using drag-and-drop, a balancing cube from Hyperion Essbase, and multi-dimensional data.

Configure Oracle financial reporting studio (FRS) in Fusion, create a grid with POV dimensions, connect to a database, and build reports using text boxes and graphs.

Develop your first FRS report by selecting account and accounting period dimensions, applying prompts, and comparing balances across two periods; suppress zero and missing values and drill down for clarity.

Log into financial reporting studio to add a total amount column with a custom formula and insert a textbox graph and a line chart with a chart title.

Explore range and descendant functions in FRS to derive parent-child values, enable drill through to account inspector and detail balances, and apply conditional formatting in reports.