|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-procure-to-pay-cycle-in-oracle-cloudfusion-erp/
课程评论：没有评论
**课程总结：Oracle Fusion 技术 - 采购到付款 (P2P) 完整流程** 本课程全面讲解了 Oracle Fusion Cloud ERP 中的采购到付款 (P2P) 周期，涵盖了从requisition（请购单）创建到 payment（付款）完成并过账至 General Ledger (GL) 的整个流程。 **核心内容包括：** * **P2P 流程详解：** 1. 创建请购单 (Requisition) 2. 创建采购订单 (Purchase Order) 3. 创建收货 (Receipt) 4. 创建 AP 发票 (AP Invoice) 5. 创建付款 (Payment) 6. 过账至总账 (Post To GL) * **关键模块的后端数据库表：** * 请购单 (Requisition) 相关 G (POR_REQUISITION_HEADERS_ALL, POR_REQUISITION_LINES_ALL, POR_REQ_DISTRIBUTIONS_ALL) * 采购 (Purchasing) 相关表 * 收货交易 (Receiving transactions) 相关表 * AP 发票及 AP 发票付款 (AP invoice and AP Invoice payments) 相关表 * XLA 和 GL (XLA and GL) 相关表 * 物品 (Item) 和物品类别 (Item class) 相关表 * **Oracle Fusion 中的重要概念和配置：** * 请购单 (Purchase Requisition) 的定义及其在采购流程中的作用。 * 执行 P2P 周期所需的必备角色 (Roles required to perform P2P Cycle)。 * 付款格式的配置 (Basics for Payment Format (Manage Formats))。 * 银行账户的付款文件管理 (Payment Documents for bank accounts (Manage Bank Accounts ))。 * 付款处理请求和配置 (Payment Process Request / profile)。 * 如何创建物品和物品类别 (How to create item / item class)。 * **Top 9 Oracle Fusion 库存表：** * EGP_SYSTEM_ITEMS * EGP_CATEGORY_SETS_VL * EGP_CATEGORIES_VL * EGP_ITEM_CATEGORIES * INV_ORG_PARAMETERS * EGP_ITEM_REVISIONS_B * EGP_ITEM_CAT_ASSIGNMENTS * INV_ONHAND_QUANTITIES_DETAIL * INV_RESERVATIONS **本课程适用于希望深入了解 Oracle Fusion Cloud ERP 中采购到付款流程的技术人员，以及需要掌握相关后端数据库表和配置以进行开发、支持或分析的专业人士。** #P2PCYCLE #ORACLEFUSIONTECHNICAL #ORACLECLOUD #oraclecloudreport #oracleHCM #Oraclefinancecloud #oraclefusioncloud #oracleOTBIreports #Oraclefinancebasetables
Procure 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#P2PCYCLE#ORACLEFUSIONTECHNICAL#ORACLE CLOUD#oraclecloudreport#oracleHCM#Oraclefinancecloud#oraclefusioncloud#oracleOTBIreports#OraclefinancebasetablesTop 9 Inventory Tables in Oracle Fusion1.EGP_SYSTEM_ITEMS2.EGP_CATEGORY_SETS_VL3.EGP_CATEGORIES_VL4.EGP_ITEM_CATEGORIES5.INV_ORG_PARAMETERS6.EGP_ITEM_REVISIONS_B7.EGP_ITEM_CAT_ASSIGNMENTS8.INV_ONHAND_QUANTITIES_DETAIL9.INV_RESERVATIONSRequisition TablesPOR_REQUISITION_HEADERS_ALLPOR_REQUISITION_LINES_ALLPOR_REQ_DISTRIBUTIONS_ALLPurchase RequisitionA requisition is a request for the goods or services. A purchase requisition is a formal document that is used when an employee needs to purchase or order something on behalf of their organization. The purchasing process is not processed when Purchase Requisition is created. This document informs the department managers or purchasing staff of the decision first. The purchasing department can start the process of purchasing the requested products or services after they receive an approved Purchase Requisition document.
