《Oracle_ERP培訓講稿-系統(tǒng)簡介》由會員分享,可在線閱讀,更多相關《Oracle_ERP培訓講稿-系統(tǒng)簡介(49頁珍藏版)》請在裝配圖網上搜索。
1、Body Text,,Second Level,,Third Level,,Fourth Level,,Fifth Level,,Click to edit Master title style,,,Sun_nan2004,1,目 錄,Oracle ERP,系統(tǒng)開發(fā)工具及開發(fā)過程,3,開放式接口 / 應用編程接口(,API),5,如何在系統(tǒng)中注冊表單,4,如何在系統(tǒng)中注冊報表,6,其它,2,Oracle ERP,系統(tǒng)結構,1. 三層邏輯體系結構,User Interface,Application logic,Database logic,客戶端,應用服務器,數(shù)據(jù)庫服務器,客戶端,Use
2、a web browser,,Netscape,,Internet Explorer,,On,,Windows,,Macintosh,,To display,,Java,,HTML,,應用服務器層,Mobile,JSP,Forms,Reports,Discoverer,BC4J,Servlet,Engine,Web Listener,Login Server,Integration,Portal,Application Server 9,i,1.0.2.2.2,數(shù)據(jù)庫服務器層:,,8,i,,9,i,,9,i,R2,Stored,,Procedures,PL/SQL,運行原理,應用服務器,數(shù)據(jù)
3、庫服務器,Web,,Applications,,Dictionary,Listener,Data,Browser,PL/SQL,,Gateway,客戶端,Workflow,Java code downloaded as needed,,Applet cached on client,Forms Network Traffic,Browser running Forms,,java applet,Data,,Server,Forms,,Server,LAN,,WAN,,Dial-up,系統(tǒng)靈活性,,歷史記錄和診斷、檢查,,用戶可以看到當前記錄來源于哪個表(視圖)、哪個字段和最后一查詢的,SQL,
4、語句等其它的信息。這對客戶化開發(fā)有極大的幫助。,,Custom.,pll,,開發(fā)人員只需客戶化此文件,而不需要修改,Oracle,的標準程序來達到客戶化的目的。用戶自已在,FORM,中定義字段,來保存其它的附加信息。,,彈性域,,用戶自已在,FORM,中定義字段,來保存其它的附加信息。,,附件,,對每一記錄能附上文件、文本信息或,Web Page,的大容量信息.,,修改,Forms,界面的文件功能或,Show,隱藏字段,,用戶能顯示自已想要顯示的字段,并能調整順序,,Export,,用戶能用,export,功能從,Form,中,export,數(shù)據(jù)到文件中。,,通常用來轉換到,Excel,文件中
5、。,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),,- Workflow,,- PL/SQL,
6、,- FSG (Financial Statement Generator),,實例,:,3. 如何在系統(tǒng)中注冊表單,,,編譯表單,,登記表單,,注冊功能,,掛上菜單(子菜單 ->菜單),,分配菜單到職責,,分配職責到用戶,,Compiler Forms,.,fmb,文件上傳到,Server,,,Telnet,連接到,Server,Login In,,,切換到 $,AU_TOP/forms/US,,,Compiler Form,4.Compiler Form,f60gen,,apps/,,,,f60gen Module=BD_TEST.,fmb userid,=apps/apps output
7、_file=/u21/oracle/,visappl,/,po,/11.5.0/forms/US/BD_TEST.,fmx,,,Compiler Form,4.Compiler Form,f60gen,,apps/,,Compiler Form,5.Compiler,成功 ,,Create .,fmx,文件,用戶權限控制結構,1,2,3,4,5,2、,登記表單,3、,注冊功能,4.1、,掛上菜單(子菜單,),4.2、,掛上菜單(子系統(tǒng)菜單,),4.3、,掛上菜單(系統(tǒng)菜單,),5、,分配菜單到職責,6、,分配職責到用戶,客戶化表單的界面,表單的數(shù)據(jù)來源(數(shù)據(jù)表,),表單的數(shù)據(jù)來源(字段,),
8、Oracle,開發(fā)工具及開發(fā)過程,,,-Form (See AVI File),,,- Report (See AVI File),,- Discoverer (See AVI File),,- Workflow,,- PL/SQL,,- FSG (Financial Statement Generator),,4. 如何在系統(tǒng)中注冊報表,,,注冊可執(zhí)行并發(fā)程序,,注冊并發(fā)程序,,掛上請求組,1、注冊可執(zhí)行并發(fā)程序,2、注冊并發(fā)程序,3、掛上請求組,運行報表,報表結果,Oracle,開發(fā)工具及開發(fā)過程,,,-Form (See AVI File),,- Report (See AV
9、I File),,,- Discoverer (See AVI File),,- Workflow,,- PL/SQL,,- FSG (Financial Statement Generator),,Oracle,開發(fā)工具及開發(fā)過程,,,-Form (See AVI File),,- Report (See AVI File),,- Discoverer (See AVI File),,,- Workflow (See Following),,- PL/SQL,,- FSG (Financial Statement Generator),,Workflow:,系統(tǒng)中的,Workflow
10、:,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. Oracle,開放式接口/,,應用編程接口(,API),開放式接口、應用編程接口(,API),原理,Excel,,File,Table,Open Interface,,Table,Package,,API,Build in,,Proce
11、ss,Oracle,,ERP,Oracle,ERP,系統(tǒng),系統(tǒng)接口數(shù)據(jù)表和應用編程接口(,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,A
12、R 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,數(shù)據(jù)字典,全部數(shù)據(jù)字典在如下三個組,,- DBA
13、_OBJECTS - DBA_TABLES -DBA_VIEWS,,- ALL_OBJECTS - ALL_TABLES -ALL_VIEWS,,- USER_OBJECTS -USER_TABLES -USER_VIEWS,,,系統(tǒng)登錄用戶,,,由系統(tǒng)來定義、分配和控制,,,數(shù)據(jù)庫用戶,,只用,APPS,,Oracle,系統(tǒng)命名的標準規(guī)則,Type,Rules,Example,Table,English Plural, start with module name,AP_INVOICE,S,View,_V,AP_INVOICES_V,Unique Index,_U ,AP_INV
14、OICES_U1,Non-Unique Index,_N,AP_INVOICES_N1,Sequence generator,_S,AP_INVOICES_S,Trigger,_,AR_CUSTOMER_PROFILES_BRU,Oracle,系統(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_PROFILES"
15、,,FOR EACH ROW,,DECLARE,,,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 nu
16、ll ) OR,,( :new.credit_hold is not null and :old.credit_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_cod
17、e ) OR,,( :new.risk_code is null and :old.risk_code is not null ) OR,,( :new.risk_code is 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.c
18、redit_rating is null and :old.credit_rating is not null ) OR,,( :new.credit_rating is not null and :old.credit_rating is null )) THEN,,,CreditRating,:= :old.credit_rating;,,,ChangesMade,:= 'Y';,,END IF;,,IF,ChangesMade,= 'Y' THEN,,INSERT INTO,ar,_credit_histories,,(credit_history_id, last_updated_
19、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.last_update_date,:old.customer_id,,CreditHold,, decode(,CreditHold,, 'Y', :old.last_update_date, null ),,CreditRating,,,RiskCode,,:old.site_use_id);,,END IF;,,END;,Oracle Application – Stored Procedure,Client,Server,Oracle,S1,,S2,,S3,,S4,S1,,S2,,S3,,S4,Oracle,Abc,(S1, S2, S3, S4),Abc,Q & A,