|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-fusion-technical-bi-publisher-reports/
课程评论：没有评论
课程名称：掌握Oracle Fusion BI：构建和分析OTBI报告 课程概述： 本课程主要讲解Oracle Fusion BI的相关技能，尤其是如何构建和分析OTBI报告。课程内容涵盖Oracle Fusion BI发布、Oracle Fusion云、SAAS、报告设计、数据分析和商业智能等领域。学员将通过在线学习掌握相关技术，并可获得认证（如适用）。 课程具体内容包括： 1. 用户创建（第2节） 2. 基础表（第2节） 3. 报告设计（第3节） 4. 报告布局（第6-11节） 5. 表达式（第17-23节） 6. 报告拆分（第30节） 7. 交付渠道（第30节） 8. 多语言报告（第28-29节） 9. 应收账款发票报告（第32-36节） 10. Excel模板（第41节） 11. ESS作业（第5节） 12. 采购到支付流程（如适用） 课程章节详细内容： - 第1节：课程介绍 - 第2节：Oracle Fusion应用（SAAS）用户创建与基础表 - 第3节：Oracle Fusion BI出版商 - 第一个报告 - 第4节：从目录运行报告 - 第5节：通过创建ESS作业从Fusion应用程序运行报告 - 第6-11节：报告布局创建（手动方法与属性解释） 此外，课程还将涉及多种表达式的操作、绑定参数的使用、BI出版商的报告拆分、多语言报告的创建与测试、应收账款发票的开发，从SQL查询的开发到复杂的报告设计。 课程展望： 基于学员反馈，未来将添加与AP支票打印、ACH支付文件定制、应收账款发票定制等相关的主题内容。 适合对象：希望深入了解Oracle Fusion BI的技术人员以及需要构建和分析OTBI报告的业务分析师。通过本课程，学员将掌握强大的商业智能工具，提升数据分析和报告能力。
Course Content :General:Oracle Fusion BI PublisherOracle Fusion CloudSAASReportingData AnalysisBusiness IntelligenceTechnical TrainingOnline CourseUdemyCertification (if applicable)Specific:User Creation (Class 2)Base Tables (Class 2)Report Design (Class 3)Report Layout (Class 6-11)Expressions (Class 17-23)Bursting (Class 30)Delivery Channels (Class 30)Multi-Lingual Reports (Class 28-29)AR Invoice Reports (Class 32-36)Excel Templates (Class 41)ESS Jobs (Class 5)Procure-to-Pay Cycle (if applicable)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 value set and $FLEX$ concept in FusionClass27- sub templates in bi publisherClass28-Multi Lingual Report with BI Publisher or translations Class29- Multi Lingual Report with BI Publisher or translation's -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 executionClass41- Working With Excel templates (Simple and master detail and multi sheet) And complete OTBI Reports Based On response to This course I will add bellow Topics in Near Future1. AP Check Printing Customization2. ACH Payment File Customization3. AR Invoice CustomizationProcure To pay cycle in oracle Fusion Cloud ERP 1. 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 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#oraclefusiontechnical#oraclecloudtechnical#Otbireports#bireportisfusioncloud#oic#oracleoic#oic#oracleintegrationcloud#oraclefusiontechnical #oraclecloudtechnical#oraclefusionhcm#oraclecloud#oracle#FBDI#BIP Reports#OTBIReports#FRS#SMARTVIEW#Sandbox#Applicationcomposer#groovyscript#p2pcycle#o2ccycle#OracleFusiontechnicalbireportsandotbireports#Oracle Fusion HCm
