|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracleappstechnical/
课程评论：没有评论
**课程名称：Oracle Apps Technical** **课程概述：** 本课程专注于Oracle Applications（包括 R12 和 11i版本）的技术方面，旨在帮助学员深入理解和掌握其核心技术和开发工具。课程内容涵盖了Oracle Apps SCM（供应链管理）和Finance（财务）模块的技术实现，并辅以大量的疑惑解答和实践指导，同时提供eoe82@gmail.com和WhatsApp：+91-6363474973进行支持。 **核心内容：** * **报表开发 (Reporting Tools):** * Oracle XML Publisher / BI Publisher * Oracle Discoverer * D2K Reports (RDF Reports) * SQL Reports * PL/SQL Reports * 重点讲解报表开发步骤、报表注册、以及各种报表工具（如Developer Reports）的核心概念，包括绑定参数、词汇参数、摘要列、公式列、占位符列、数据链接、数据模型、布局模型、框架、重复框架、文本字段、OLE2、定位工具、限制模式、对齐对象、调整对象大小、置于底层、每页显示有限记录、金额以单词显示、每条主记录在新页开始、重置页码等。 * 提供具体示例，如公式列、摘要列、占位符列的实现，动态图像显示，条件格式化（动态隐藏字段），在付款登记报表中添加取消原因，单字符串显示多值，词汇参数（带格式化查询示例），矩阵报表（包含完整发票历史的未结销售订单列表），动态创建表，包含零发票金额。 * 讲解报表触发器，如动态显示报表名称和公司名称，设置RDF报表警告状态，从其他报表中调用报表，以及通过Forms Personalization调用报表。 * **接口与转换 (Interfaces and Conversions):** * Inbound（入站）和 Outbound（出站）接口开发。 * 讲解Unix Shell Scripting在数据加载和管理中的应用，包括将Shell脚本注册为并发程序，实现文件复制，通过Unix脚本加载数据，以及从Unix脚本提交并发程序。 * **扩展与定制 (Extensions & Customizations):** * Oracle Forms Personalization：讲解如何使用Forms Personalization实现各种功能，如调用报表，禁用按钮，修改LOV（列表值），调用存储过程，设置初始值，显示AOL消息，隐藏字段，以及限制行级别数量（带示例）。 * Forms Personalization表及实例间迁移。 * **工作流与审批 (Workflow and Approval Management Engine - AME):** * Oracle Workflow 及其与 Approval Management Engine (AME) 的集成。 * **架构与基础知识：** * Oracle XML Publisher/BI Publisher * Oracle Discoverer * Oracle Alerts * Multi Org Multiorg Access Control (MOAC) * Trading Community Architecture (TCA) Architecture * 11i vs R12 差异分析 * Application Object Library (AOL) - Application Developer, System Administrator * AIM (Application Implementation Methodology) 文档 * **业务流程集成：** * Procure To Pay (P2P) - 采购到付款周期 * Order to Cash (O2C) - 订单到收款周期 * Internal Sales Order - 内部销售订单 * Drop Shipment - 第三方发货 * Back to Back Order - 背靠背订单 * Oracle Projects Billing and Costing Flow 及其与 Payables, Receivables, Inventory and Purchasing 的集成。 * **Unix Shell Scripting：** * 基础Unix命令。 * 将Shell脚本注册为并发程序。 * 文件操作（复制文件）。 * 数据加载。 * 从Unix提交并发程序。 **目标学员：** Oracle Apps 技术顾问、开发人员、系统管理员以及对Oracle Applications技术感兴趣的IT专业人士。 **课程特色：** * 内容全面，覆盖Oracle Apps技术开发的各个方面。 * 强调实践操作和问题解答，提供直接的技术支持。 * 深入讲解报表和接口开发的常用工具和技术。 * 包含对Oracle Apps重要概念和架构的详细解释。
Doubts clarification - oebs82@gmail.com WhatsApp number +91-6363474973Oracle Apps SCM And Finance Technical Ricew-Reports ,Interfaces,Conversions,Extensions,Workflow.Cycles· Procure To pay(P2P)· Order to cash(O2C)· Internal Sales order· Drop shipment· Back to back order· Oracle projects Billing and Costing flow and its integration with payables receivables inventory and purchasingReporting Tools· Oracle XML Publisher/BI Publisher· Oracle Discoverer· D2k Reports(RDF Reports)· SQL Reports· PLSQL ReportsOracle applications Alerts, Multi Org, MOAC,TCA Architecture,11i vs R12 Differences.AOL(Application Object Library)· Application Developer· System AdministratorAIM documentationOracle Workflow and Approval Management Engine(AME)Unix Shell ScriptingInterfaces And conversionsInbound OutboundOracle Forms Personalization's TasksZOOMcalling the reportDisable the buttonchanging LOVcalling procedureSetting initial ValueDisplay AOL MessagesHiding the fieldsRestricting line level qty with exampleForm personalization tables and migration from one instance to other instanceUnix Shell ScriptingSteps to Register Shell Script as a concurrent programUnix Script copying file from one location to other locationloading data by using unix scriptsubmitting concurrent program from unixBasic unix commandsSql Report DevelopmentPlsql Report DevelopmentPLSQL Report to EXCELDeveloper ReportsReport Development steps and report registrationDeveloper reporting tool fundamentals like Bind parameter, Lexical parameter, Summary column, Formula column, Place holder column, Data link, Data model, layout model, Frame ,Repeating Frame, Text field ,Boiler Text ,OLE2, pinning a toolconfine mode, flex mode, Align objects, size objects, send it to backdisplay limited records per pagedisplay amt in wordseach master records starts on the starting of the pagereset page numbering.Formula column with exampleSummary column with exampleplaceholder column with exampleFormat triggersDisplay dynamic imagescondtional formatting:dynamically hiding the fields.adding void reason to void payment register reportDisplay multiple values in single stringUser exitslexical parameter with formatted query exampleMatrxi report - outstanding sales order list including complete invoice historyCreation of table dynamicallyInclude zero invoice amounts.Report triggersDisplay dynamic report name in the outputDisplay dynamic company name in the report outputset rdf report with warning statuscalling a report from other reportcalling a report using form personalization.
