Description
Objectives :
1. How to create user in oracle fusion application with base tables
2. How to run bi publisher report in oracle fusion Application by creating as ESS Job
3. Bursting in bi publisher oracle fusion application
4. Subtemplates in bi publisher oracle fusion application
5. Translations in bi publisher oracle fusion application
6. How to create bi report in oracle fusion application
7. How to create stylesheet in oracle fusion bi publisher reports
8. How to create Multi language report in oracle fusion bi publisher reports
9. How to create transaltions in oracle fusion bi publisher reports
10. RTF Tags -Split by Page break and for-each@section ,call-template other rtf tags in oracle fusion bi reports
11. Subtemplate with parameters in oracle fusion bi reports
12. Dynamic PDF Secuirity or PDF Password in oracle fusion bi reports
13. AR Invoice Base tables in oracle fusion Receivables
14. Local variable XDO_USER_NAME
15. How to create Bi report in oracle fusion from Scratch
16. Sub template with parameter in oraclefusion
17. Dynamic logo based on business unit name in oraclefusion bi reports
18. Limiting Lines per page in Bi Publisher
19. Display Barcodes in Bi publisher or working woth barcodes in bi publisher report
Requirements :
a). Basics of Oracle Sql
b). Basics of Oracle xml Publisher Reports
a). Procure to Pay Cycle
- Introduction to P2P Cycle
- Basic Flow Of P2P Cycle
- Create Item and Item Class
- Item and item Class base Tables
- Item and Item Class get from Subject area
- Create Requisition
- Base Table for Requisition
- Get requisiton data using Subject area
- Create Purchase order
- Base tables for Purchase order
- Get PO Data Using Subject area
- Create Receipt against PO
- Receipt Base Tables
- Create Ap Invoice
- Base Table For Ap invoice
- Ap Invoice – Post To GL
- Ap Invoice – base table from Ap To Gl
- Create Payment
- Payment Tables
b). BI Publishers Report
- OracleFusion application (SAAS) user Creation with base tables.
- Running The report From Catalog
- Running The report From Fusion Application by creating ESS JOB
- Report Layout Creation using Manual Method
- Report Layout Properties Explained – General
- Report Layout Properties Explained – Caching
- Report Layout Properties Explained – Formatting
- Report Layout Properties Explained – Currency Format
- Style Sheet Template
- Master Detail Report using Element Level link
- Master Detail Report using Group Level link
- Master Detail Report using subgroups
- Aggregate functions
- Arithematic Operation on columns
- Working with bind parameters
- Bind Parameters with Independent and translated independent LOV
- Bind Parameters with Table valueset and $FLEX$ concept in Fusion
- Subtemplate
- Multilanguage Report or transalations
- Multi language report or Transalations. -Testing
- Bursting – Delivery Channel – EMAIL and FTP and SFTP and FILE
- Bursting Report Testing fixing the issues in bursting query
c). OTBI Reports
- How To Create Analysis
- Working With Prompts in Analysis
- Working With Compund Layout(Title,Logo,Calculated field,page control Etc)
- Working With Inline Prompts or prompt value based on other prompt
- Selection Steps – Select Member On Attributes
- Add Group On Attributes
- New Calculated item On Attributes
- Dashboards with prompt
Reviews
There are no reviews yet.