Oracle Fusion Technical Bi Publisher Reports

  1. Home
  2. Business-intelligence
  3. Oracle Fusion Technical Bi Publisher Reports

Tags: Business Intelligence

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

Last updated 2022-01-10 | 4.4

- 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

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

  • 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

3 sections • 75 lectures

Procure To Pay Cycle 23 lectures

Before you start Read Description !!!!!!! Preview 00:51

..

Before Proceeding with P2P Cycle Go Through first video of BI and OTBI Reports Preview 00:07

I request You Go through P2P Cycle after Completing BI Report first Video and OTBI First Video in this course if you don't know how to create BI and OTBI Report

Introduction To P2P Cycle Preview 00:30

Basic Flow Of P2P Cycle Preview 01:50

Prerequistes - Part 1 Preview 24:47

Prerequisites - Part2 Preview 32:14

Create Item and Item Class Preview 16:27

Item and item Class base Tables Preview 11:38

Item and Item Class get from Subject area Preview 04:18

create Requisition Preview 05:41

Base Table for Requisition Preview 08:25

get requisiton data using Subject area Preview 04:51

Create Purchase order Preview 07:05

Base tables for Purchase order Preview 10:01

get PO Data Using Subject area Preview 05:13

Create Receipt against PO Preview 07:04

Receipt Base Tables Preview 09:54

Create Ap Invoice Preview 13:19

Base Table For Ap invoice Preview 13:19

Ap Invoice - Post To GL Preview 02:07

Ap Invoice - base table from Ap To Gl Preview 24:26

Create Payment Preview 05:20

Payment Tables Preview 08:43

Bi Publisher Reports 41 lectures

Oracle Fusion application (SAAS) User Creation with base tables Preview 22:38

Oracle Fusion BI publisher - First Report Preview 26:10

Running The report From Catalog Preview 06:28

Running The report From Fusion Application by creating ESS JOB Preview 17:05

Report Layout Creation using Manual Method Preview 18:16

Report Layout Creation using Manual Method Preview 08:56

Report Layout Properties Explained - General Preview 10:47

Report Layout Properties Explained - Caching Preview 03:47

Report Layout Properties Explained - Formatting Preview 05:37

Report Layout Properties Explained - Currency Format Preview 02:45

Style Sheet Template Preview 23:54

Master Detail Report using Element Level link Preview 09:48

Master Detail Report using Group Level link Preview 07:02

Master Detail Report using subgroups Preview 07:59

Aggregate functions Preview 37:40

Arithematic Operation on columns Preview 09:42

Expressions - IF (exp) With Example Preview 07:11

Expressions - NOT with xdo_user_report_locale Preview 06:31

Expressions - AND Function Preview 11:19

Expressions - OR Function Preview 09:29

Expressions - MIN AND MAX Functions Preview 08:29

Expressions - ROUND , SUM Function Preview 08:20

working with bind parameters Preview 19:52

Bind Parameters with Independent and translated independent LOV Preview 12:49

Bind Parameters with Table valueset and $FLEX$ concept in Fusion Preview 09:42

Subtemplate Preview 44:10

Multilanguage Report or transalations Preview 31:00

Multi language report or Transalations. -Testing Preview 02:34

Bursting - Delivery Channel - EMAIL and FTP and SFTP and FILE Preview 47:12

Bursting Report Testing fixing the issues in bursting query Preview 09:47

AR invoice report development from Scratch - SQL query development part1 Preview 37:58

AR invoice report development from Scratch - SQL query development part2 Preview 43:26

AR Invoice Report -for-each and for-each@section and master Details Report Preview 59:27

AR Invoice Report - for-each@section and split-by-page-break Preview 13:17

Ar Invoice Report - Repeaing Header Preview 17:54

Subtemplates with parameters or dynamic logo based on business unit name Preview 26:32

Limiting lines per page in BI Publisher Logic Preview 09:32

Limiting Lines per page in BI Publisher execution Preview 20:55

Display Barcodes in Bi publisher with execution Preview 18:48

Working With Excel Templates - Part 1 Preview 27:06

Working With Excel Template - Master Details Report Preview 26:12

OTBI Reports 11 lectures

Class1 - How To Create Analysis - First Report Preview 40:02

Class2 - Working With Prompts in Analysis Preview 07:12

Class3-Working With Compund Layout(Title,Logo,Calculated field,page control Etc) Preview 42:01

Class-4 - Working With Inline Prompts or prompt value based on other prompt Preview 08:54

Class-5-Selection Steps - Select Member On Attributes Preview 22:57

Class-6-Selection Steps - Add Group On Attributes Preview 09:13

Class-7-Selection Steps - New Calculated item On Attributes Preview 09:27

Class- 8- Master Detail Report in OTBI Reports Preview 19:00

Class9-Dashboards with prompt Preview 14:04

Class10-Action Links (Part -1 ) - Navigate to Bi Content Preview 05:58

Coming Soon Preview 00:06

Around 4 to 6 hrs of Content will added to OTBI Report section in this course as soon as possible !


Hope you liked the course !