Oracle Fusion Technical-Business Intelligence & OTBI Reports (Udemy.com)

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

Created by: Ravinder Reddy Guduru

Produced in 2021

icon
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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 76 / 100

icon
Course 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 valueset and $FLEX$ concept in FusionClass27- sub templates in bi publisherClass28-Multi Lingual Report with BI Publisher or transalations Class29- Multi Lingual Report with BI Publisher or transalations -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 executionBased On response to This course I will add bellow Topics in Near Future1. Ap CheckPrinting Customisation2. ACH Payment File Customisation3. AR Invoice CustomisationProcure To pay cycle in oracle Fusion Cloud ERP1. 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 XLAand GL12 .
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 classWho this course is for:
Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional - FINANCE ,SCM ,HCM

icon
Instructor Details

Ravinder Reddy Guduru

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

icon
Reviews

3.8

64 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Joe Williams on 11/15/2020

Heavy accent. Difficult to understand at times.

By Gaurav Patil on 11/1/2020

Ravi has explained very well in depth and covered all topics. Thanks Ravi such a good job....

By Mansoor Ahmed Plasterwala on 10/4/2020

It was great learning experience

By Eragamreddy Srinivasulu Reddy on 9/5/2020

Hi Ravi,
I would like to say thanks the useful information.
The information which you shared is awesome.
Keep rocking with few more videos related to fusion finance technical.
If possible with OIC.
Regards,
Srini.

By Jeremy Stephenson on 8/17/2020

So far i am really enjoying the class. it is well structured and everything is presented in excellent detail.

By Asutosha Sarangi on 7/23/2020

some videos are blur so not able to re properly sometimes. video capture quality was not checked I think. Over all good

By Babu K on 7/4/2020

Excellent Teaching with Real time scenario's, Really Super.

By Pankaj Sakharam Patil on 6/21/2020

Really a Good Course for Oracle reports Covers all topics of Reports

By Mohammad Arif on 6/15/2020

Hi Ravi,
Seeing videos on P2P cycle, in the middle of this course It is realized that you are awesome in the teaching. I mean you didn't left anything what I aspect in this cycle even getting better understanding in functional part also.
I hope that you'll upload o2c cycle also. waiting for the same :)
Thanks for you efforts.

By Pandora Gaudino on 6/14/2020

It is a good match for me. I am experienced with bi publisher prior versions. There's not only a lot of repetition from prior versions but there's also a lot of repetition in this video along. I also don't think writing the queries should be part of this course. The queries should be pre-written. I also believe the report should be one save, then just use the same one over and over to add each of the functionalities. That way you don't have to recreate the data model/template all the time but just add to it. Which of course is mostly what we do anyway, adding to existing reports. The repetition is probably great for others but for me it's tedious.

By talal mohamed ibrahim Ahmed on 5/27/2020

great

By Ganesh Kamath on 5/24/2020

Trainer is good, but not excellent to train with the level of communication and writing skills he holds.