Oracle Fusion Technical-Business Intelligence & Otbi Reports

Oracle Fusion(Oracle Cloud) Techincal Training SAAS (R13 ) - Bi Publisher Reports For Oracle Apps Technical Developers

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

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 -for-each@section 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

Who this course is for:
Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional - FINANCE ,SCM ,HCM