Oracle Fusion Technical-Business Intelligence & OTBI Reports

BY
Udemy

Mode

Online

Fees

₹ 449 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 449  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Procure To Pay Cycle

  • Before you start Read Description !!!!!!!
  • Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports
  • 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 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

OTBI Reports

  • 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
  • Coming Soon

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books