Master Oracle Fusion BI- Build Analyze OTBI Reports

Master Oracle Fusion BI: Build & Analyze OTBI Reports, available at $94.99, has an average rating of 4.48, with 75 lectures, based on 1178 reviews, and has 7203 subscribers.

You will learn about 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 This course is ideal for individuals who are Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional – FINANCE ,SCM ,HCM It is particularly useful for Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional – FINANCE ,SCM ,HCM.

Enroll now: Master Oracle Fusion BI: Build & Analyze OTBI Reports

Summary

Title: Master Oracle Fusion BI: Build & Analyze OTBI Reports

Price: $94.99

Average Rating: 4.48

Number of Lectures: 75

Number of Published Lectures: 75

Number of Curriculum Items: 75

Number of Published Curriculum Objects: 75

Original Price: ?6,500

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Procure To Pay Cycle

Lecture 1: Before you start Read Description !!!!!!!

Lecture 2: Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports

Lecture 3: Introduction To P2P Cycle

Lecture 4: Basic Flow Of P2P Cycle

Lecture 5: Prerequistes – Part 1

Lecture 6: Prerequisites – Part2

Lecture 7: Create Item and Item Class

Lecture 8: Item and item Class base Tables

Lecture 9: Item and Item Class get from Subject area

Lecture 10: create Requisition

Lecture 11: Base Table for Requisition

Lecture 12: get requisiton data using Subject area

Lecture 13: Create Purchase order

Lecture 14: Base tables for Purchase order

Lecture 15: get PO Data Using Subject area

Lecture 16: Create Receipt against PO

Lecture 17: Receipt Base Tables

Lecture 18: Create Ap Invoice

Lecture 19: Base Table For Ap invoice

Lecture 20: Ap Invoice – Post To GL

Lecture 21: Ap Invoice – base table from Ap To Gl

Lecture 22: Create Payment

Lecture 23: Payment Tables

Chapter 2: Bi Publisher Reports

Lecture 1: Oracle Fusion application (SAAS) User Creation with base tables

Lecture 2: Oracle Fusion BI publisher – First Report

Lecture 3: Running The report From Catalog

Lecture 4: Running The report From Fusion Application by creating ESS JOB

Lecture 5: Report Layout Creation using Manual Method

Lecture 6: Report Layout Creation using Manual Method

Lecture 7: Report Layout Properties Explained – General

Lecture 8: Report Layout Properties Explained – Caching

Lecture 9: Report Layout Properties Explained – Formatting

Lecture 10: Report Layout Properties Explained – Currency Format

Lecture 11: Style Sheet Template

Lecture 12: Master Detail Report using Element Level link

Lecture 13: Master Detail Report using Group Level link

Lecture 14: Master Detail Report using subgroups

Lecture 15: Aggregate functions

Lecture 16: Arithematic Operation on columns

Lecture 17: Expressions – IF (exp) With Example

Lecture 18: Expressions – NOT with xdo_user_report_locale

Lecture 19: Expressions – AND Function

Lecture 20: Expressions – OR Function

Lecture 21: Expressions – MIN AND MAX Functions

Lecture 22: Expressions – ROUND , SUM Function

Lecture 23: working with bind parameters

Lecture 24: Bind Parameters with Independent and translated independent LOV

Lecture 25: Bind Parameters with Table valueset and $FLEX$ concept in Fusion

Lecture 26: Subtemplate

Lecture 27: Multilanguage Report or transalations

Lecture 28: Multi language report or Transalations. -Testing

Lecture 29: Bursting – Delivery Channel – EMAIL and FTP and SFTP and FILE

Lecture 30: Bursting Report Testing fixing the issues in bursting query

Lecture 31: AR invoice report development from Scratch – SQL query development part1

Lecture 32: AR invoice report development from Scratch – SQL query development part2

Lecture 33: AR Invoice Report -for-each and for-each@section and master Details Report

Lecture 34: AR Invoice Report – for-each@section and split-by-page-break

Lecture 35: Ar Invoice Report – Repeaing Header

Lecture 36: Subtemplates with parameters or dynamic logo based on business unit name

Lecture 37: Limiting lines per page in BI Publisher Logic

Lecture 38: Limiting Lines per page in BI Publisher execution

Lecture 39: Display Barcodes in Bi publisher with execution

Lecture 40: Working With Excel Templates – Part 1

Lecture 41: Working With Excel Template – Master Details Report

Chapter 3: OTBI Reports

Lecture 1: Class1 – How To Create Analysis – First Report

Lecture 2: Class2 – Working With Prompts in Analysis

Lecture 3: Class3-Working With Compund Layout(Title,Logo,Calculated field,page control Etc)

Lecture 4: Class-4 – Working With Inline Prompts or prompt value based on other prompt

Lecture 5: Class-5-Selection Steps – Select Member On Attributes

Lecture 6: Class-6-Selection Steps – Add Group On Attributes

Lecture 7: Class-7-Selection Steps – New Calculated item On Attributes

Lecture 8: Class- 8- Master Detail Report in OTBI Reports

Lecture 9: Class9-Dashboards with prompt

Lecture 10: Class10-Action Links (Part -1 ) – Navigate to Bi Content

Lecture 11: Coming Soon

Instructors

Ravinder Reddy Guduru
Oracle Apps/Fusion Technical Consultant

Rating Distribution

1 stars: 28 votes

2 stars: 26 votes

3 stars: 174 votes

4 stars: 444 votes

5 stars: 506 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!