Oracle Fusion Technical-Business Intelligence & OTBI Reports

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

1,186 students enrolled

Created by Ravinder Reddy Guduru

Last updated 5/2020

English

English [Auto-generated]

Preview this course

Oracle Fusion Technical-Business Intelligence & OTBI Reports

$65.99 $94.99 31% off

5 hours left at this price!

30-Day Money-Back Guarantee

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

+ – 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

Introduction To P2P Cycle

Preview 00:30

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

Oracle Fusion application (SAAS) User Creation with base tables

Preview 22:38

Oracle Fusion BI publisher - First Report

Preview 26:10

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

Featured review

Arunkumar Menon ( 61 courses, 1 review )

a year ago

Easy to follow along course, will give a very good idea about the OTBI reports in Fusion and Ravi covers most of the topics so as to set the base correct! May add little more advanced topics if possible, but still well worth the price!