OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

Master Oracle Fusion BI

Build & Analyze OTBI Reports

Ravinder Reddy Guduru

Course Content  :

General:

Read more

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

Enroll now

14 deals to help you save

We found 14 deals and offers that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout. Valid until December 3
Cyber Monday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout. Only 18 hours left!
Black Friday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout. Valid until December 1
For new customers
Save when you purchase top courses. For new customers only.
Special Offer
UDEAFNULP2024
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off

What's inside

Learning objectives

  • 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
  • Show more
  • Show less

Syllabus

Procure To Pay Cycle

..

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

Read more
Introduction To P2P Cycle
Basic Flow Of P2P Cycle
Prerequistes - Part 1
Prerequisites - Part2
Create Item and Item Class
Item and item Class base Tables
Item and Item Class get from Subject area
create Requisition
Base Table for Requisition
get requisiton data using Subject area
Create Purchase order
Base tables for Purchase order
get PO Data Using Subject area
Create Receipt against PO
Receipt Base Tables
Create Ap Invoice
Base Table For Ap invoice
Ap Invoice - Post To GL
Ap Invoice - base table from Ap To Gl
Create Payment
Payment Tables
Bi Publisher Reports
Oracle Fusion application (SAAS) User Creation with base tables
Oracle Fusion BI publisher - First Report
Running The report From Catalog
Running The report From Fusion Application by creating ESS JOB
Report Layout Creation using Manual Method
Report Layout Properties Explained - General
Report Layout Properties Explained - Caching
Report Layout Properties Explained - Formatting
Report Layout Properties Explained - Currency Format
Style Sheet Template
Master Detail Report using Element Level link
Master Detail Report using Group Level link
Master Detail Report using subgroups
Aggregate functions
Arithematic Operation on columns
Expressions - IF (exp) With Example
Expressions - NOT with xdo_user_report_locale
Expressions - AND Function
Expressions - OR Function
Expressions - MIN AND MAX Functions
Expressions - ROUND , SUM Function
working with bind parameters
Bind Parameters with Independent and translated independent LOV
Bind Parameters with Table valueset and $FLEX$ concept in Fusion
Subtemplate
Multilanguage Report or transalations
Multi language report or Transalations. -Testing
Bursting - Delivery Channel - EMAIL and FTP and SFTP and FILE
Bursting Report Testing fixing the issues in bursting query
AR invoice report development from Scratch - SQL query development part1
AR invoice report development from Scratch - SQL query development part2
AR Invoice Report -for-each and for-each@section and master Details Report
AR Invoice Report - for-each@section and split-by-page-break
Ar Invoice Report - Repeaing Header
Subtemplates with parameters or dynamic logo based on business unit name
Limiting lines per page in BI Publisher Logic
Limiting Lines per page in BI Publisher execution
Display Barcodes in Bi publisher with execution
Working With Excel Templates - Part 1
Working With Excel Template - Master Details Report
Oracle Transaction Business Intelligent Report in Oracle fusion SAAS
Class1 - How To Create Analysis - First Report
Class2 - Working With Prompts in Analysis
Class3-Working With Compund Layout(Title,Logo,Calculated field,page control Etc)
Class-4 - Working With Inline Prompts or prompt value based on other prompt
Class-5-Selection Steps - Select Member On Attributes
Class-6-Selection Steps - Add Group On Attributes
Class-7-Selection Steps - New Calculated item On Attributes
Class- 8- Master Detail Report in OTBI Reports
Class9-Dashboards with prompt
Class10-Action Links (Part -1 ) - Navigate to Bi Content

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 !

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Provides a foundational understanding of Oracle Fusion BI Publisher and its key components
Develops skills in creating and designing effective reports using Oracle Fusion BI Publisher
Covers advanced concepts such as bursting, delivery channels, and multilingual reports
Focuses specifically on Oracle Fusion Cloud applications, ensuring relevance to users in that ecosystem
Provides practical examples and hands-on exercises to reinforce learning
May require prior knowledge of Oracle Fusion Cloud applications to fully benefit from the course

Save this course

Save Master Oracle Fusion BI: Build & Analyze OTBI Reports to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Master Oracle Fusion BI: Build & Analyze OTBI Reports with these activities:
Follow tutorials on Oracle BI Publisher basics
Gain a deeper understanding of Oracle BI Publisher by completing guided tutorials on key concepts
Show steps
  • Locate and read tutorials on the official Oracle BI Publisher documentation website
  • Follow video tutorials on YouTube or other platforms
  • Complete interactive tutorials on Oracle BI Publisher training platforms
Refresh your knowledge of Oracle BI Publisher from previous coursework
Get a solid foundational understanding of Oracle BI Publisher before starting this course
Show steps
  • Review your notes and assignments from previous Oracle BI Publisher courses
  • Complete practice questions on Oracle BI Publisher concepts
  • Set up a practice environment for Oracle BI Publisher
Attend networking events for Oracle BI Publisher professionals
Expand your network and learn from other Oracle BI Publisher professionals by attending networking events
Show steps
  • Identify and research upcoming Oracle BI Publisher networking events
  • Register and attend the networking event
  • Connect with other professionals, share experiences, and exchange knowledge
  • Follow up with new connections after the event
Five other activities
Expand to see all activities and additional details
Show all eight activities
Complete practice drills on Oracle BI Publisher expressions
Sharpen your skills in writing Oracle BI Publisher expressions to enhance your reporting capabilities
Show steps
  • Solve practice problems on evaluating Oracle BI Publisher expressions
  • Create your own practice reports using Oracle BI Publisher expressions
  • Participate in online forums or discussion groups to ask questions and get feedback on your expressions
Attend an Oracle BI Publisher workshop or training session
Gain hands-on experience and expert guidance by attending an Oracle BI Publisher workshop or training session
Show steps
  • Research and identify upcoming Oracle BI Publisher workshops or training sessions
  • Register and attend the workshop or training session
  • Actively participate in the sessions and ask questions
  • Follow up with the instructors or facilitators after the session to clarify any doubts
Develop a simple Oracle BI Publisher report for a business scenario
Apply your Oracle BI Publisher skills to a practical use case by developing a report for a business scenario
Show steps
  • Define the business scenario and identify the data requirements
  • Design the report layout and structure
  • Write Oracle BI Publisher expressions to retrieve and format the data
  • Generate and review the report
  • Refine the report based on feedback and iterations
Mentor junior colleagues or students in Oracle BI Publisher
Strengthen your understanding of Oracle BI Publisher by mentoring others and sharing your knowledge
Show steps
  • Identify opportunities to mentor junior colleagues or students
  • Create a structured mentoring plan
  • Provide guidance and support on Oracle BI Publisher concepts and practices
  • Review and provide feedback on mentees' work
  • Regularly assess progress and adjust the mentoring plan as needed
Contribute to open-source projects related to Oracle BI Publisher
Enhance your skills and make valuable contributions to the Oracle BI Publisher community by participating in open-source projects
Show steps
  • Identify open-source projects related to Oracle BI Publisher
  • Review the project documentation and codebase
  • Contribute to the project by fixing bugs, adding features, or improving documentation
  • Collaborate with other contributors and maintainers
  • Share your contributions back to the community

Career center

Learners who complete Master Oracle Fusion BI: Build & Analyze OTBI Reports will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Master Oracle Fusion BI: Build & Analyze OTBI Reports.
Create a Mortgage Calculator in Excel
ACE the AP Statistics Exam and MASTER Elementary...
Aspen Plus - Physical Properties
Power BI Data Import Playbook
1Z0-071 Oracle SQL Developer: Certified Associate...
PowerBI Report Development Crash Course
Oracle SQL Performance Tuning
Jakarta Persistence (JPA)
Build an End-to-End Data Capture Pipeline using Document...
Course image
Effort
19 total hours
Via
Udemy
Instructor
Ravinder Reddy Guduru
Language
English
Good to know
Provides a foundational understanding of Oracle Fusion BI Publisher and its key components
Develops skills in creating and designing effective reports using Oracle Fusion BI Publisher
Covers advanced concepts such as bursting, delivery channels, and multilingual reports
Focuses specifically on Oracle Fusion Cloud applications, ensuring relevance to users in that ecosystem
Provides practical examples and hands-on exercises to reinforce learning
May require prior knowledge of Oracle Fusion Cloud applications to fully benefit from the course
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser