OracleERP培訓(xùn)教程ppt課件

1、1 目 錄Oracle ERP系統(tǒng)開發(fā)工具及開發(fā)過程3開放式接口 / 運用編程接口(API)5如何在系統(tǒng)中注冊表單4如何在系統(tǒng)中注冊報表6其它2Oracle ERP系統(tǒng)構(gòu)造 1. 三層邏輯體系構(gòu)造User InterfaceApplication logicDatabase logic客戶端運用效力器數(shù)據(jù)庫效力器客戶端Use a web browserNetscapeInternet ExplorerOn WindowsMacintoshTo displayJavaHTML 運用效力器層MobileJSPFormsReportsDiscovererBC4JServlet EngineWeb L

2、istenerLogin ServerIntegrationPortalApplication Server 9i 1.0.2.2.2數(shù)據(jù)庫效力器層:8i9i9iR2StoredProceduresPL/SQL 運轉(zhuǎn)原理運用效力器數(shù)據(jù)庫效力器WebApplicationsDictionaryListenerDataBrowserPL/SQLGateway客戶端WorkflowJava code downloaded as neededApplet cached on client Forms Network TrafficBrowser running Forms java appletDat

3、a ServerForms ServerLANWANDial-up系統(tǒng)靈敏性 歷史記錄和診斷、檢查用戶可以看到當(dāng)前記錄來源于哪個表(視圖)、哪個字段和最后一查詢的SQL語句等其它的信息。這對客戶化開發(fā)有極大的協(xié)助。Custom.pll開發(fā)人員只需客戶化此文件，而不需求修正Oracle 的規(guī)范程序來到達客戶化的目的。用戶自已在FORM中定義字段，來保管其它的附加信息。彈性域用戶自已在FORM中定義字段，來保管其它的附加信息。附件對每一記錄能附上文件、文本信息或Web Page的大容量信息.修正Forms 界面的文件功能或Show隱藏字段用戶能顯示自已想要顯示的字段，并能調(diào)整順序Export用戶能

4、用export功能從Form 中export數(shù)據(jù)到文件中。通常用來轉(zhuǎn)換到Excel文件中。2. Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Report (See AVI File)- Discoverer (See AVI File)- Workflow (See Following)- PL/SQL- FSG (Financial Statement Generator)Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Report (See AVI File)- Discoverer (See AVI File)- Workflo

5、w- PL/SQL- FSG (Financial Statement Generator)實例：3. 如何在系統(tǒng)中注冊表單編譯表單登記表單注冊功能掛上菜單(子菜單 -菜單)分配菜單到職責(zé)分配職責(zé)到用戶 Compiler Forms.fmb文件上傳到ServerTelnet 銜接到Server，Login In切換到 $AU_TOP/forms/USCompiler Form4piler Formf60gen apps/f60gen Module=BD_TEST.fmb userid=apps/apps output_file=/u21/oracle/visappl/po/11.5.0/for

6、ms/US/BD_TEST.fmxCompiler Form4piler Formf60gen apps/Compiler Form5piler 勝利 ,Create .fmx 文件用戶權(quán)限控制構(gòu)造1,23452、登記表單3、注冊功能4.1、掛上菜單(子菜單)4.2、掛上菜單(子系統(tǒng)菜單)4.3、掛上菜單(系統(tǒng)菜單)5、分配菜單到職責(zé)6、分配職責(zé)到用戶客戶化表單的界面表單的數(shù)據(jù)來源(數(shù)據(jù)表)表單的數(shù)據(jù)來源(字段)Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Report (See AVI File)- Discoverer (See AVI File)- Work

7、flow - PL/SQL- FSG (Financial Statement Generator)4. 如何在系統(tǒng)中注冊報表注冊可執(zhí)行并發(fā)程序注冊并發(fā)程序掛上懇求組1、注冊可執(zhí)行并發(fā)程序2、注冊并發(fā)程序3、掛上懇求組運轉(zhuǎn)報表報表結(jié)果Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Report (See AVI File)- Discoverer (See AVI File)- Workflow - PL/SQL- FSG (Financial Statement Generator)Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Rep

8、ort (See AVI File)- Discoverer (See AVI File)- Workflow (See Following)- PL/SQL- FSG (Financial Statement Generator)Workflow:系統(tǒng)中的Workflow:Oracle 開發(fā)工具及開發(fā)過程-Form (See AVI File)- Report (See AVI File)- Discoverer (See AVI File)- Workflow (See Following)- PL/SQL- FSG (Financial Statement Generator)5. Or

9、acle 開放式接口/運用編程接口(API)開放式接口、運用編程接口(API)原理Excel FileTableOpen Interface TablePackage APIBuild in ProcessOracle ERPOracle ERP系統(tǒng)系統(tǒng)接口數(shù)據(jù)表和運用編程接口(API)程序Module Function Interface Table/APICommentsAP SuppliersPO_VENDORSPO_VENDOR_SITES_ALLPO_VEDNRO_CONTACTSNo Interface /APIAR CustomersRA_CUSTOMERS_INTERFACE_

10、ALLRA_CUSTOMER_PROFILES_INT_ALLRA_CUSTOMER_BANKS_INT_ALLOpen interface tableAR ReceiptsAR_RECEIPT_API_PUB ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPTAPI packagesGL JournalsGL_INTERFACEOpen interface table6. Oracle運用的其它相關(guān)工具-ADI (Application Desktop Integrator)- Dataload (quest)- Sql loader - Fndloa

11、d- Toad- SQL Developer- etcOracle 數(shù)據(jù)字典全部數(shù)據(jù)字典在如下三個組- DBA_OBJECTS - DBA_TABLES-DBA_VIEWS - ALL_OBJECTS - ALL_TABLES-ALL_VIEWS- USER_OBJECTS -USER_TABLES-USER_VIEWS系統(tǒng)登錄用戶 由系統(tǒng)來定義、分配和控制數(shù)據(jù)庫用戶只用 APPSOracle 系統(tǒng)命名的規(guī)范規(guī)那么TypeRulesExampleTableEnglish Plural, start with module nameAP_INVOICESView_VAP_INVOICES_VUn

12、ique Index_U AP_INVOICES_U1Non-Unique Index_NAP_INVOICES_N1Sequence generator_SAP_INVOICES_STrigger_AR_CUSTOMER_PROFILES_BRUOracle 系統(tǒng) 數(shù)據(jù)庫觸發(fā)器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_PROFILESFOR EA

13、CH ROWDECLARE CreditHold varchar2(1) := null; RiskCode varchar2(30) := null; CreditRating varchar2(30) := null; ChangesMade varchar2(1) := N;BEGIN IF ( :new.credit_hold != :old.credit_hold ) OR ( :new.credit_hold is null and :old.credit_hold is not null ) OR ( :new.credit_hold is not null and :old.c

14、redit_hold is null ) THEN CreditHold := :old.credit_hold; /* IF FIELD VALUE OF credit_hold IS CHANGED THEN SET */ /* THE VALUE OF THIS VARIABLE TO Y */ ChangesMade := Y; END IF; IF ( :new.risk_code != :old.risk_code ) OR ( :new.risk_code is null and :old.risk_code is not null ) OR ( :new.risk_code i

15、s not null and :old.risk_code is null ) THEN RiskCode := :old.risk_code; ChangesMade := Y; END IF; IF ( :new.credit_rating != :old.credit_rating ) OR ( :new.credit_rating is null and :old.credit_rating is not null ) OR ( :new.credit_rating is not null and :old.credit_rating is null ) THEN CreditRati

16、ng := :old.credit_rating; ChangesMade := Y; END IF;IF ChangesMade = Y THEN INSERT INTO ar_credit_histories (credit_history_id, last_updated_by, last_update_date, created_by, creation_date, customer_id, on_hold, hold_date, credit_rating, risk_code, site_use_id) VALUES (ar_credit_histories_s.nextval, :old.last_updated_by, :old.last_update_date, :old.last_updated_by, :old