Oracle Fusion Technical-Business Intelligence & OTBI Reports
4.1 (289 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,187 students enrolled

Oracle Fusion Technical-Business Intelligence & OTBI Reports

Oracle Fusion(Oracle Cloud) Techincal Training SAAS (R13 ) - Bi Publisher Reports For Oracle Apps Technical Developers
4.1 (289 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,186 students enrolled
Last updated 5/2020
English
English [Auto-generated]
Current price: $65.99 Original price: $94.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 18.5 hours on-demand video
  • 3 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 72 lectures 18:25:59
+ Procure To Pay Cycle
22 lectures 03:37:19

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

Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports
00:07
Basic Flow Of P2P Cycle
01:50
Prerequistes - Part 1
24:47
Prerequisites - Part2
32:14
Create Item and Item Class
16:27
Item and item Class base Tables
11:38
Item and Item Class get from Subject area
04:18
create Requisition
05:41
Base Table for Requisition
08:25
get requisiton data using Subject area
04:51
Create Purchase order
07:05
Base tables for Purchase order
10:01
get PO Data Using Subject area
05:13
Create Receipt against PO
07:04
Receipt Base Tables
09:54
Create Ap Invoice
13:19
Base Table For Ap invoice
13:19
Ap Invoice - Post To GL
02:07
Ap Invoice - base table from Ap To Gl
24:26
Create Payment
05:20
Payment Tables
08:43
+ Bi Publisher Reports
42 lectures 12:28:46
Introduction
00:40
Running The report From Catalog
06:28
Running The report From Fusion Application by creating ESS JOB
17:05
Report Layout Creation using Manual Method
18:16
Report Layout Creation using Manual Method
08:56
Report Layout Properties Explained - General
10:47
Report Layout Properties Explained - Caching
03:47
Report Layout Properties Explained - Formatting
05:37
Report Layout Properties Explained - Currency Format
02:45
Style Sheet Template
23:54
Master Detail Report using Element Level link
09:48
Master Detail Report using Group Level link
07:02
Master Detail Report using subgroups
07:59
Aggregate functions
37:40
Arithematic Operation on columns
09:42
Expressions - IF (exp) With Example
07:11
Expressions - NOT with xdo_user_report_locale
06:31
Expressions - AND Function
11:19
Expressions - OR Function
09:29
Expressions - MIN AND MAX Functions
08:29
Expressions - ROUND , SUM Function
08:20
working with bind parameters
19:52
Bind Parameters with Independent and translated independent LOV
12:49
Bind Parameters with Table valueset and $FLEX$ concept in Fusion
09:42
Subtemplate
44:10
Multilanguage Report or transalations
31:00
Multi language report or Transalations. -Testing
02:34
Bursting - Delivery Channel - EMAIL and FTP and SFTP and FILE
47:12
Bursting Report Testing fixing the issues in bursting query
09:47
AR invoice report development from Scratch - SQL query development part1
37:58
AR invoice report development from Scratch - SQL query development part2
43:26
AR Invoice Report -for-each and for-each@section and master Details Report
59:27
AR Invoice Report - for-each@section and split-by-page-break
13:17
Ar Invoice Report - Repeaing Header
17:54
Subtemplates with parameters or dynamic logo based on business unit name
26:32
Limiting lines per page in BI Publisher Logic
09:32
Limiting Lines per page in BI Publisher execution
20:55
Display Barcodes in Bi publisher with execution
18:48
Working With Excel Templates - Part 1
27:06
Working With Excel Template - Master Details Report
26:12
+ OTBI Reports
8 lectures 02:19:52
Class1 - How To Create Analysis - First Report
40:02
Class2 - Working With Prompts in Analysis
07: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 prompt
08:54
Class-5-Selection Steps - Select Member On Attributes
22:57
Class-6-Selection Steps - Add Group On Attributes
09:13
Class-7-Selection Steps - New Calculated item On Attributes
09:27

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 !

Coming Soon
00:06
Requirements
  • Basics of Oracle Sql
  • Basiscs of Oralcle xml Publisher Reports
Description

Course Content  :


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 valueset and $FLEX$ concept in Fusion

Class27- sub templates in bi publisher

Class28-Multi Lingual Report with BI Publisher or transalations

Class29- Multi Lingual Report with BI Publisher or transalations -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

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

1. Ap Check Printing Customisation

2. ACH Payment File Customisation

3. AR Invoice Customisation



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

Who this course is for:
  • Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional - FINANCE ,SCM ,HCM