Oracle Fusion TechnicalBusiness Intelligence OTBI Reports
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 [email protected] ,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
Requirements
Basics of Oracle Sql
Basiscs of Oralcle xml Publisher Reports
Description
Course Content :Class1- Introductionclass2 – Oracle Fusion application (SAAS) User Creation with base tablesclass3 – Oracle Fusion BI publisher – First Reportclass4 – Running The report From Catalogclass5 – Running The report From Fusion Application by creating ESS JOBclass6 – Report Layout Creation using Manual Method – 1class7 – Report Layout Creation using Manual Method – 2class8 – Report Layout Properties Explained – Generalclass9 – Report Layout Properties Explained – Cachingclass10 – Report Layout Properties Explained – Formattingclass11- Report Layout Properties Explained – Currency Formatclass12- Style Sheet Templateclass13- Master Detail Report using Element Level linkclass14- Master Detail Report using Group Level linkclass15- Master Detail Report using subgroupsclass16- Aggregate functions Class17- Expression – Arithmetic Operation on columnsClass18- Expressions – IF (exp) With Exampleclass19- Expressions – NOT with xdo_user_report_localeclass20- Expressions – AND Functionclass21- Expressions – OR Functionclass22- Expressions – MIN AND MAX Functionclass23- Expressions – ROUND , SUM Functionclass24- working with bind parametersclass25- Bind Parameters with Independent and translated independent LOVclass26- Bind Parameters with Table value set and $FLEX$ concept in FusionClass27- sub templates in bi publisherClass28-Multi Lingual Report with BI Publisher or translations Class29- Multi Lingual Report with BI Publisher or translation’s -TestingClass30- Oracle BI Publisher Bursting – Delivery Channel (EMAIL ,FAX ,SFTP , FTP ,PRINT )Class31- Oracle BI Publisher Bursting – Delivery Channel (EMAIL ) -TestingClass32-AR invoice report development from Scratch – SQL query development part1Class33-AR invoice report development from Scratch – SQL query development part2Class34-AR Invoice Report -for-each and master Details ReportClass35-AR Invoice Report [email protected] and split-by-page-breakClass36- AR Invoice Report – Repeating HeaderClass37-Sub template with parameter or dynamic logo based on business unit nameClass38-Limiting Lines per page in RTF Logic Class39-Limiting Lines per page in Bi Publisher with executionClass40-Display Barcodes in Bi publisher with executionClass41- Working With Excel templates (Simple and master detail and multi sheet) And complete OTBI Reports Based On response to This course I will add bellow Topics in Near Future1. AP Check Printing Customization2. ACH Payment File Customization3. AR Invoice CustomizationProcure To pay cycle in oracle Fusion Cloud ERP 1. Create Requisition2. Create Purchase Order 3. Create Receipt 4. Create AP Invoice 5. Create Payment 6. Post To GL 7. Bases tables For requisition8. 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
Overview
Section 1: Procure To Pay Cycle
Lecture 1 Before you start Read Description !!!!!!!
Lecture 2 Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports
Lecture 3 Introduction To P2P Cycle
Lecture 4 Basic Flow Of P2P Cycle
Lecture 5 Prerequistes – Part 1
Lecture 6 Prerequisites – Part2
Lecture 7 Create Item and Item Class
Lecture 8 Item and item Class base Tables
Lecture 9 Item and Item Class get from Subject area
Lecture 10 create Requisition
Lecture 11 Base Table for Requisition
Lecture 12 get requisiton data using Subject area
Lecture 13 Create Purchase order
Lecture 14 Base tables for Purchase order
Lecture 15 get PO Data Using Subject area
Lecture 16 Create Receipt against PO
Lecture 17 Receipt Base Tables
Lecture 18 Create Ap Invoice
Lecture 19 Base Table For Ap invoice
Lecture 20 Ap Invoice – Post To GL
Lecture 21 Ap Invoice – base table from Ap To Gl
Lecture 22 Create Payment
Lecture 23 Payment Tables
Section 2: Bi Publisher Reports
Lecture 24 Oracle Fusion application (SAAS) User Creation with base tables
Lecture 25 Oracle Fusion BI publisher – First Report
Lecture 26 Running The report From Catalog
Lecture 27 Running The report From Fusion Application by creating ESS JOB
Lecture 28 Report Layout Creation using Manual Method
Lecture 29 Report Layout Creation using Manual Method
Lecture 30 Report Layout Properties Explained – General
Lecture 31 Report Layout Properties Explained – Caching
Lecture 32 Report Layout Properties Explained – Formatting
Lecture 33 Report Layout Properties Explained – Currency Format
Lecture 34 Style Sheet Template
Lecture 35 Master Detail Report using Element Level link
Lecture 36 Master Detail Report using Group Level link
Lecture 37 Master Detail Report using subgroups
Lecture 38 Aggregate functions
Lecture 39 Arithematic Operation on columns
Lecture 40 Expressions – IF (exp) With Example
Lecture 41 Expressions – NOT with xdo_user_report_locale
Lecture 42 Expressions – AND Function
Lecture 43 Expressions – OR Function
Lecture 44 Expressions – MIN AND MAX Functions
Lecture 45 Expressions – ROUND , SUM Function
Lecture 46 working with bind parameters
Lecture 47 Bind Parameters with Independent and translated independent LOV
Lecture 48 Bind Parameters with Table valueset and $FLEX$ concept in Fusion
Lecture 49 Subtemplate
Lecture 50 Multilanguage Report or transalations
Lecture 51 Multi language report or Transalations. -Testing
Lecture 52 Bursting – Delivery Channel – EMAIL and FTP and SFTP and FILE
Lecture 53 Bursting Report Testing fixing the issues in bursting query
Lecture 54 AR invoice report development from Scratch – SQL query development part1
Lecture 55 AR invoice report development from Scratch – SQL query development part2
Lecture 56 AR Invoice Report -for-each and [email protected] and master Details Report
Lecture 57 AR Invoice Report – [email protected] and split-by-page-break
Lecture 58 Ar Invoice Report – Repeaing Header
Lecture 59 Subtemplates with parameters or dynamic logo based on business unit name
Lecture 60 Limiting lines per page in BI Publisher Logic
Lecture 61 Limiting Lines per page in BI Publisher execution
Lecture 62 Display Barcodes in Bi publisher with execution
Lecture 63 Working With Excel Templates – Part 1
Lecture 64 Working With Excel Template – Master Details Report
Section 3: OTBI Reports
Lecture 65 Class1 – How To Create Analysis – First Report
Lecture 66 Class2 – Working With Prompts in Analysis
Lecture 67 Class3-Working With Compund Layout(Title,Logo,Calculated field,page control Etc)
Lecture 68 Class-4 – Working With Inline Prompts or prompt value based on other prompt
Lecture 69 Class-5-Selection Steps – Select Member On Attributes
Lecture 70 Class-6-Selection Steps – Add Group On Attributes
Lecture 71 Class-7-Selection Steps – New Calculated item On Attributes
Lecture 72 Class- 8- Master Detail Report in OTBI Reports
Lecture 73 Class9-Dashboards with prompt
Lecture 74 Class10-Action Links (Part -1 ) – Navigate to Bi Content
Lecture 75 Coming Soon
Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional – FINANCE ,SCM ,HCM
Course Information:
Udemy | English | 19h 4m | 13.50 GB
Created by: Ravinder Reddy Guduru
You Can See More Courses in the Developer >> Greetings from CourseDown.com