Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Development Tools Business Intelligence

Oracle Fusion Technical-Business Intelligence & OTBI Reports

Oracle Fusion(Oracle Cloud) Techincal Training SAAS (R13 ) - Bi Publisher Reports For Oracle Apps Technical Developers
Rating: 4.2 out of 54.2 (421 ratings)
2,124 students
Created by Ravinder Reddy Guduru
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

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

  • Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports
    00:07
  • Preview00: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

  • Introduction
    00:40
  • Preview22:38
  • Preview26: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

  • 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
  • Class- 8- Master Detail Report in OTBI Reports
    19:00
  • Class9-Dashboards with prompt
    14:04
  • Class10-Action Links (Part -1 ) - Navigate to Bi Content
    05:58
  • 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

Eragamreddy Srinivasulu Reddy
Eragamreddy Srinivasulu Reddy
2 courses
1 review
Rating: 5.0 out of 55 months ago
Hi Ravi, I would like to say thanks the useful information. The information which you shared is awesome. Keep rocking with few more videos related to fusion finance technical. If possible with OIC. Regards, Srini.

Instructor

Ravinder Reddy Guduru
Technology Analyst - Oracle Apps/Fusion Tech Consultant
Ravinder Reddy Guduru
  • 4.2 Instructor Rating
  • 793 Reviews
  • 3,558 Students
  • 4 Courses

Working As A Oracle Apps/Fusion Technical Consultant In One of the Top 2 Leading MNC India .

• Having 3 Years Of total Experience As Oracle Apps/Fusion Technical  Trainer 

• Providing training for clients around World (India , USA ,Dubai , South Africa, Quatar )

• Having work experience in Financials ( Account Receivables , Account Payables) ,Order Management  ,  Purchasing and Inventory modules in Oracle Applications  R12. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.