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
Course Content :
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 OTBIReports
Based On response to This course I will add bellow Topics in Near Future
1. AP CheckPrinting 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 XLAand 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
