Oracle Fusion Technical-Business 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 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
22 lectures • 3hr 37minProcure To Pay Cycle
- 00:07Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports
- Preview00:30
- 01:50Basic Flow Of P2P Cycle
- 24:47Prerequistes - Part 1
- 32:14Prerequisites - Part2
- 16:27Create Item and Item Class
- 11:38Item and item Class base Tables
- 04:18Item and Item Class get from Subject area
- 05:41create Requisition
- 08:25Base Table for Requisition
- 04:51get requisiton data using Subject area
- 07:05Create Purchase order
- 10:01Base tables for Purchase order
- 05:13get PO Data Using Subject area
- 07:04Create Receipt against PO
- 09:54Receipt Base Tables
- 13:19Create Ap Invoice
- 13:19Base Table For Ap invoice
- 02:07Ap Invoice - Post To GL
- 24:26Ap Invoice - base table from Ap To Gl
- 05:20Create Payment
- 08:43Payment Tables
42 lectures • 12hr 29minBi Publisher Reports
8 lectures • 2hr 20minOTBI Reports
Requirements
- Basics of Oracle Sql
- Basiscs of Oralcle xml Publisher Reports
Description
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
Who this course is for:
- Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional - FINANCE ,SCM ,HCM
Featured review
![Arunkumar Menon](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructor
- 4.3 Instructor Rating
- 633 Reviews
- 2,519 Students
- 4 Courses
Working As A Oracle Apps/Fusion Technical Consultant In One of the Top 2 Leading MNC India .
• Having 3 Years Of total Experience As Oracle Apps/Fusion Technical Trainer
• Providing training for clients around World (India , USA ,Dubai , South Africa, Quatar )
• Having work experience in Financials ( Account Receivables , Account Payables) ,Order Management , Purchasing and Inventory modules in Oracle Applications R12.