*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Oracle Fusion Cloud Technical Consultant -Business Intelligence & OTBI Reports


Be the first to rate Oracle Fusion Cloud Technical Consultant -Business Intelligence & OTBI Reports
Or log in to access your purchased courses
by fatima
Price: 280,000
2 Months
0 Lessons

Oracle Fusion Cloud Technical Consultant -Business Intelligence & OTBI Reports

Oracle Fusion Cloud Technical Consultant -Business Intelligence & OTBI Reports

This course will introduce you to Oracle Transactional Business Intelligence – OTBI, and provide you with the necessary skills to understand business requirements using an actionable insights approach Intelligence & OTBI reports. This Oracle  Business Intelligence course content is designed to expand your expertise in business data analysis. It also improves your potential and career choices with Oracle business intelligence certification


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
  • sub templates 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:

  •  Introduction
  • 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 – 1
  • Report Layout  Creation using Manual Method – 2
  • Report Layout  Properties Explained – General
  • Report Layout  Properties Explained – Caching
  • Report Layout  Properties Explained – Formatting
  • Report Layout  Properties Explained – Currency Forma
  • Style Sheet Template
  • Master Detail Report using Element Level link
  • Master Detail Report using Group Level link\
  • Master Detail Report using subgroups
  • Aggregate functions
  • Expression – Arithmetic 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 Function
  • Expressions – ROUND , SUM Function
  • working with bind paramete
  • Bind Parameters with Independent and translated independent LOV
  • Bind Parameters with Table value set and $FLEX$ concept in Fusion
  • Multi Lingual Report with BI Publisher or translations
  • Multi Lingual Report with BI Publisher or translation’s -Testing
  • Oracle BI Publisher Bursting  – Delivery Channel (EMAIL ,FAX ,SFTP , FTP ,PRINT )
  • Oracle BI Publisher Bursting  – Delivery Channel (EMAIL ) -Testing
  • 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 master Details Report
  • AR Invoice Report -for-each@section and split-by-page-bre
  • AR Invoice Report – Repeating Header
  • Sub template with parameter or dynamic logo based on business unit name
  • Limiting Lines per page in RTF Logic
  • Limiting Lines per page in Bi Publisher with execution
  • Display Barcodes in Bi publisher  with execution
  • Working With Excel templates (Simple and master detail and multi sheet)

Who this course is for:

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

Oracle Job Interview Preparation

International Student Fee: 1000$


Related Courses

Oracle Fusion Technical Course Learn BI, OTBI, BICC, FRS, Smart View and More

Oracle Fusion Technical – Procure to Pay Cycle complete flow

Oracle Techno Functional Consultant – Oracle ERP Apps

Oracle HCM – HRMS Career and Succession

Fusion Cloud ERP Training – Oracle Fusion Cloud General Ledger Fundamentals

Oracle Hyperion Planning – Implementation Installation & Configuration

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us