OracleERP系统结构研讨.pptVIP

2、註冊併發程式 3、掛上請求組 運行報表 報表結果 Oracle 開發工具及開發過程 -Form (See AVI File) - Report (See AVI File) - Discoverer (See AVI File) - Workflow - PL/SQL - FSG (Financial Statement Generator) Oracle 開發工具及開發過程 -Form (See AVI File) - Report (See AVI File) - Discoverer (See AVI File) - Workflow (See Following) - PL/SQL - FSG (Financial Statement Generator) Workflow: 系統中的Workflow: Oracle 開發工具及開發過程 -Form (See AVI File) - Report (See AVI File) - Discoverer (See AVI File) - Workflow (See Following) - PL/SQL - FSG (Financial Statement Generator) 5. Oracle 開放式介面/ 應用程式設計介面(API) 開放式介面、應用程式設計介面(API)原理 Excel File Table Open Interface Table Package API Build in Process Oracle ERP Oracle ERP系統 系統介面資料表和應用程式設計介面(API)程式 Module Function Interface Table/API Comments AP Suppliers PO_VENDORS PO_VENDOR_SITES_ALL PO_VEDNRO_CONTACTS No Interface /API AR Customers RA_CUSTOMERS_INTERFACE_ALL RA_CUSTOMER_PROFILES_INT_ALL RA_CUSTOMER_BANKS_INT_ALL Open interface table AR Receipts AR_RECEIPT_API_PUB ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPT API packages GL Journals GL_INTERFACE Open interface table 6. Oracle使用的其它相關工具 -ADI (Application Desktop Integrator) - Dataload () - Sql loader - Fndload - Toad - SQL Developer - etc… Oracle 資料字典 全部資料字典在如下三個組 - DBA_OBJECTS - DBA_TABLES -DBA_VIEWS - ALL_OBJECTS - ALL_TABLES -ALL_VIEWS - USER_OBJECTS -USER_TABLES -USER_VIEWS 系統登錄使用者 由系統來定義、分配和控制 資料庫使用者 只用 APPS Oracle 系統命名的標準規則 Type Rules Example Table English Plural, start with module name AP_INVOICES View table name_V AP_INVOICES_V Unique Index table name_U n AP_INVOICES_U1 Non-Unique Index table name_Nn AP_INVOICES_N1 Sequence generator table name_S AP_INVOICES_S Trigger table_name_event AR_CUSTOMER_PROFILES_BRU Oracle 系統 － 資料庫觸發器 CREATE OR REPLACE TRIGGER ar_customer_profiles_bru /* $Header: arplt26.sql 70.4 96/10/29 15:04:58 porting ship $ */ BEFORE UPDATE ON AR.AR_CUSTOMER_PROFILES FOR EACH ROW DECLARE CreditHold varchar2(1) := null; Ri