When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Master Oracle Fusion BI: Build & Analyze OTBI Reports
Master Oracle Fusion R13 BI Publisher for SaaS Apps: Build Advanced Reports & Automate Delivery (Technical Developers)
This Course Includes
udemy
2.5 (1.3K reviews )
19h 4m 
english
Online - Self Paced
professional certificate
Udemy
About Master Oracle Fusion BI: Build & Analyze OTBI Reports
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 - 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 value set and $FLEX$ concept in Fusion Class27- sub templates in bi publisher Class28-Multi Lingual Report with BI Publisher or translations Class29- Multi Lingual Report with BI Publisher or translation's -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 Class41- 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 Future
1. 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
What You Will 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 Show moreShow less.