Oracle Fusion Technical-Business Intelligence & OTBI 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 valueset and $FLEX$ concept in Fusion

Class27- sub templates in bi publisher

Class28-Multi Lingual Report with BI Publisher or transalations

Class29- Multi Lingual Report with BI Publisher or transalations -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

Based On response to This course I will add bellow Topics in Near Future

1. Ap Check Printing Customisation

2. ACH Payment File Customisation

3. AR Invoice Customisation

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