Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master Oracle Fusion BI: Build & Analyze OTBI Reports

Name: Master Oracle Fusion BI: Build & Analyze OTBI Reports
Rating: 4.1 (1376 reviews)

Master Oracle Fusion R13 BI Publisher for SaaS Apps: Build Advanced Reports & Automate Delivery (Technical Developers)

Created byRavinder Reddy Guduru

Last updated 1/2024

English

English [Auto],

What you'll learn

How to create user in oracle fusion application with base tables
how to run bi publisher report in oracle fusion Application by creating as ESS Job
bursting in bi publisher oracle fusion application
subtemplates in bi publisher oracle fusion application
translations in bi publisher oracle fusion application
How to create bi report in oracle fusion application
How to create stylesheet in oracle fusion bi publisher reports
how to create Multi language report in oracle fusion bi publisher reports
how to create transaltions in oracle fusion bi publisher reports
RTF Tags -Split by Page break and for-each@section ,call-template other rtf tags in oracle fusion bi reports
subtemplate with parameters in oracle fusion bi reports
Dynamic PDF Secuirity or PDF Password in oracle fusion bi reports
AR Invoice Base tables in oracle fusion Receivables
Local variable XDO_USER_NAME
How to create Bi report in oracle Fusion from Scratch
Sub template with parameter in oracle fusion
dynamic logo based on business unit name in oracle fusion bi reports
Limiting Lines per page in Bi Publisher
Display Barcodes in Bi publisher or working woth barcodes in bi publisher reports

Course content

3 sections • 75 lectures • 19h 4m total length

Before you start Read Description !!!!!!!0:38
..
Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports0:07
I request You Go through P2P Cycle after Completing BI Report first Video and OTBI First Video in this course if you don't know how to create BI and OTBI Report
Introduction To P2P Cycle0:30
Basic Flow Of P2P Cycle1:50
Explore the basic steps of the procure-to-pay cycle, from creating requisitions and purchase orders to receiving items, generating invoices (including pay-on-receipt setups), and posting to the general ledger.
Prerequistes - Part 124:47
Prerequisites - Part232:14
Create Item and Item Class16:27
Item and item Class base Tables11:38
Learn to locate item and item class tables in Oracle Fusion BI, query data model and views, and join item class id to item catalog to display inventory by organization.
Item and Item Class get from Subject area4:18
create Requisition5:41
Create a purchase requisition in the P2P cycle by entering lines, setting delivery to inventory, and submitting for auto-approval when costs are under 1000, and check data in OTBI reports.
Base Table for Requisition8:25
get requisiton data using Subject area4:51
Explore the procurement requisition real-time subject area in OTBI, view requisition header and lines, and identify requisition number, header ID, item description, buyer, requester, ship to location, and data restrictions.
Create Purchase order7:05
Base tables for Purchase order10:01
get PO Data Using Subject area5:13
Create Receipt against PO7:04
Receipt Base Tables9:54
Create Ap Invoice13:19
Create and manage an AP invoice with pay on receipt, using scheduled pay and receipt programs, interface tables, base tables, and role-based security to validate, tax, and post invoices.
Base Table For Ap invoice13:19
Ap Invoice - Post To GL2:07
Post an accounts payable invoice to the general ledger by posting from the manage invoices task. View accounting to see four lines, including two liability lines and recoverable tax line.
Ap Invoice - base table from Ap To Gl24:26
Learn how to trace AP invoices to GL by linking invoice distributions to event IDs through headers and lines, using import references and GL batches for OTBI reporting.
Create Payment5:20
Learn how to create a payment against an invoice in Oracle Fusion BI, including setting the check payment method, linking to a bank account, payment document, and updating unpaid amounts.
Payment Tables8:43
Explore AP payment schedules, AP invoices, and AP invoice payments to track amount remaining and payment details, including check id, bank account, and payment id.

Oracle Fusion application (SAAS) User Creation with base tables22:38
Oracle Fusion BI publisher - First Report26:10
Build an Oracle Fusion BI Publisher report with the wizard, create a SQL data model and layout, and save to shared folders for testing and PDF output.
Running The report From Catalog6:28
Running The report From Fusion Application by creating ESS JOB17:05
Learn to run a fusion publisher report by creating an enterprise scheduler job, using report analytics to set the path and layout, and scheduling a pdf output.
Report Layout Creation using Manual Method18:16
Create a manual report layout in Oracle Fusion BI by building a data model, designing with XML tags, and uploading the layout for catalog execution.
Report Layout Creation using Manual Method8:56
Report Layout Properties Explained - General10:47
Report Layout Properties Explained - Caching3:47
Report Layout Properties Explained - Formatting5:37
Explore formatting properties for report layouts, including pdf output security and password protection, and learn how to configure, schedule, and verify pdf reports in the catalog.
Report Layout Properties Explained - Currency Format2:45
Style Sheet Template23:54
Apply style sheets as templates by creating, uploading to the catalog, and applying them to report layouts to standardize header, footer, date, and PDF output across reports.
Master Detail Report using Element Level link9:48
Master Detail Report using Group Level link7:02
Create master detail reports using group level links in Oracle Fusion BI, linking groups via a bind parameter on customer ID and generating a report from the data model.
Master Detail Report using subgroups7:59
Create a master detail report using subgroups by building a single query data model, establishing master–child relationships, and moving elements between groups to form grouped layouts with subgroups.
Aggregate functions37:40
Learn how to use aggregate functions—sum, count, average, first, last, min, max, and summary—within a data model to analyze invoice data in Oracle Fusion BI.
Arithematic Operation on columns9:42
Use expressions to perform arithmetic operations on columns in Fusion DB, including addition, subtraction, multiplication, division, and modulus, to create calculated fields like extended amount and revenue amount.
Expressions - IF (exp) With Example7:11
Expressions - NOT with xdo_user_report_locale6:31
Expressions - AND Function11:19
Expressions - OR Function9:29
Expressions - MIN AND MAX Functions8:29
Learn how min and max expressions operate in OTBI reports, including single-expression results, salary examples, and the SQL-like comparison used with multiple expressions.
Expressions - ROUND , SUM Function8:20
Demonstrates round and sum expressions in OTBI, including rounding extended amount to zero decimals and adding it to revenue amount, and explains string concatenation and Oracle SQL comparison.
working with bind parameters19:52
Bind Parameters with Independent and translated independent LOV12:49
Bind Parameters with Table valueset and $FLEX$ concept in Fusion9:42
Create a table value set from a database query, attach it to a parameter, and use the $FLEX$ concept to dynamically filter values by transaction type.
Subtemplate44:10
Multilanguage Report or transalations31:00
Learn to create a multi-language OTBI report by building a data model and layout, exporting and editing an xliff translation file, and running translated outputs from the catalog.
Multi language report or Transalations. -Testing2:34
Bursting - Delivery Channel - EMAIL and FTP and SFTP and FILE47:12
Bursting Report Testing fixing the issues in bursting query9:47
Fix the bursting query to return two invoices by removing duplicate lines or using distinct, then test the bursting workflow to ensure only two emails are sent.
AR invoice report development from Scratch - SQL query development part137:58
AR invoice report development from Scratch - SQL query development part243:26
Learn to build an AR invoice report query from scratch in Oracle Fusion BI, linking party, cost accounts, and site data to produce bill-to and ship-to details with parameters.
AR Invoice Report -for-each and for-each@section and master Details Report59:27
Learn to build an OTBI invoice report in Oracle Fusion BI by configuring list of values, using Fusion DB data sources, and creating a master-detail layout with RDF.
AR Invoice Report - for-each@section and split-by-page-break13:17
Master Oracle Fusion BI OTBI reporting by generating AR invoice reports that use for-each section and page break logic to render each invoice on a separate page.
Ar Invoice Report - Repeaing Header17:54
Fix header repetition in AR invoice reports by converting the header into a template, calling it on subsequent pages, and validating the layout and data model queries.
Subtemplates with parameters or dynamic logo based on business unit name26:32
Create dynamic logos in Oracle Fusion BI reports by using a parameterized sub template called logo, called from a main template, with conditional logic for US and UK operating units.
Limiting lines per page in BI Publisher Logic9:32
Limiting Lines per page in BI Publisher execution20:55
Learn to limit lines per page in BI Publisher by declaring a lines-per-page variable and applying page breaks, ensuring headers repeat on every page for consistency.
Display Barcodes in Bi publisher with execution18:48
Working With Excel Templates - Part 127:06
Working With Excel Template - Master Details Report26:12
Learn to build a master detail report in Oracle Fusion BI using an Excel template, including data model setup, master and child queries, layout, tags, and grouping.

Class1 - How To Create Analysis - First Report40:02
Discover how to create an OTBI analysis in Oracle Fusion by selecting a subject area, building a layout, and running the report from browse catalog or home search for output.
Class2 - Working With Prompts in Analysis7:12
Class3-Working With Compund Layout(Title,Logo,Calculated field,page control Etc)42:01
Class-4 - Working With Inline Prompts or prompt value based on other prompt8:54
Class-5-Selection Steps - Select Member On Attributes22:57
Class-6-Selection Steps - Add Group On Attributes9:13
Learn to create ad groups and calculated items in OTBI, group invoice types (debit/credit memos, prepayment, payment request), and apply subtotals and formatting across operating units.
Class-7-Selection Steps - New Calculated item On Attributes9:27
Explore the new calculated item in oracle fusion bi to perform arithmetic with otbi data, compare with grouping, and compute sums, averages, and net invoice amounts including credit and debit memos.
Class- 8- Master Detail Report in OTBI Reports19:00
Class9-Dashboards with prompt14:04
Learn to build and customize dashboards in Oracle Fusion BI OTBI by adding analyses, creating dashboard prompts, and filtering data with master-detail relationships for actionable insights.
Class10-Action Links (Part -1 ) - Navigate to Bi Content5:58
Explore how action links in oracle fusion bi enable navigating to content and web pages from a dashboard, and opening standard fusion screens to view invoice details or analyses.
Coming Soon0:06
Around 4 to 6 hrs of Content will added to OTBI Report section in this course as soon as possible !

Hope you liked the course !

Requirements

Basics of Oracle Sql
Basiscs of Oralcle xml Publisher Reports

Description

Course Content :

General:

Oracle Fusion BI Publisher
Oracle Fusion Cloud
SAAS
Reporting
Data Analysis
Business Intelligence
Technical Training
Online Course
Udemy
Certification (if applicable)

Specific:

User Creation (Class 2)
Base Tables (Class 2)
Report Design (Class 3)
Report Layout (Class 6-11)
Expressions (Class 17-23)
Bursting (Class 30)
Delivery Channels (Class 30)
Multi-Lingual Reports (Class 28-29)
AR Invoice Reports (Class 32-36)
Excel Templates (Class 41)
ESS Jobs (Class 5)
Procure-to-Pay Cycle (if applicable)

Class1- Introduction

class2 - Oracle Fusion application (SAAS) User Creation with base tables

class3 - Oracle Fusion BI publisher - First Report

class4 - Running The report From Catalog

class5 - Running The report From Fusion Application by creating ESS JOB

class6 - Report Layout Creation using Manual Method - 1

class7 - Report Layout Creation using Manual Method - 2

class8 - Report Layout Properties Explained - General

class9 - Report Layout Properties Explained - Caching

class10 - Report Layout Properties Explained - Formatting

class11- Report Layout Properties Explained - Currency Format

class12- Style Sheet Template

class13- Master Detail Report using Element Level link

class14- Master Detail Report using Group Level link

class15- Master Detail Report using subgroups

class16- Aggregate functions

Class17- Expression - Arithmetic Operation on columns

Class18- Expressions - IF (exp) With Example

class19- Expressions - NOT with xdo_user_report_locale

class20- Expressions - AND Function

class21- Expressions - OR Function

class22- Expressions - MIN AND MAX Function

class23- Expressions - ROUND , SUM Function

class24- working with bind parameters

class25- Bind Parameters with Independent and translated independent LOV

class26- Bind Parameters with Table value set and $FLEX$ concept in Fusion

Class27- sub templates in bi publisher

Class28-Multi Lingual Report with BI Publisher or translations

Class29- Multi Lingual Report with BI Publisher or translation's -Testing

Class30- Oracle BI Publisher Bursting - Delivery Channel (EMAIL ,FAX ,SFTP , FTP ,PRINT )

Class31- Oracle BI Publisher Bursting - Delivery Channel (EMAIL ) -Testing

Class32-AR invoice report development from Scratch - SQL query development part1

Class33-AR invoice report development from Scratch - SQL query development part2

Class34-AR Invoice Report -for-each and master Details Report

Class35-AR Invoice Report -for-each@section and split-by-page-break

Class36- AR Invoice Report - Repeating Header

Class37-Sub template with parameter or dynamic logo based on business unit name

Class38-Limiting Lines per page in RTF Logic

Class39-Limiting Lines per page in Bi Publisher with execution

Class40-Display Barcodes in Bi publisher with execution

Class41- Working With Excel templates (Simple and master detail and multi sheet)

And complete OTBI Reports

Based On response to This course I will add bellow Topics in Near Future

1. AP Check Printing Customization

2. ACH Payment File Customization

3. AR Invoice Customization

Procure To pay cycle in oracle Fusion Cloud ERP

1. Create Requisition

2. Create Purchase Order

3. Create Receipt

4. Create AP Invoice

5. Create Payment

6. Post To GL

7. Bases tables For requisition

8. Base tables For Purchasing

9. Base tables for Receiving transactions

10. Base tables for AP invoice and AP Invoice payments

11. Base Tables For XLA and GL

12 .Roles required to perform P2P Cycle

13 .Basics for Payment Format (Manage Formats)

14.Payment Documents for bank accounts (Manage Bank Accounts )

15 . Payment Process Request / profile

16. How to create item / item class

17.base tables for item and item class

#oraclefusiontechnical

#oraclecloudtechnical

#Otbireports

#bireportisfusioncloud

#oic

#oracleoic

#oic

#oracleintegrationcloud

#oraclefusiontechnical

#oraclecloudtechnical

#oraclefusionhcm

#oraclecloud

#oracle

#FBDI

#BIP Reports

#OTBIReports

#FRS

#SMARTVIEW

#Sandbox

#Applicationcomposer

#groovyscript

#p2pcycle

#o2ccycle

#OracleFusiontechnicalbireportsandotbireports

#Oracle Fusion HCm

Who this course is for:

Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional - FINANCE ,SCM ,HCM

Master Oracle Fusion BI: Build & Analyze OTBI Reports

What you'll learn

Explore related topics

Course content

Procure To Pay Cycle23 lectures • 3hr 38min

Bi Publisher Reports41 lectures • 12hr 28min

OTBI Reports11 lectures • 2hr 59min

Requirements

Description

Who this course is for: