《Oracle_ERP培訓(xùn)講稿-系統(tǒng)簡(jiǎn)介》由會(huì)員分享，可在線閱讀，更多相關(guān)《Oracle_ERP培訓(xùn)講稿-系統(tǒng)簡(jiǎn)介（49頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、Body Text,,Second Level,,Third Level,,Fourth Level,,Fifth Level,,Click to edit Master title style,,,Sun_nan2004,1,目 錄,Oracle ERP,系統(tǒng)開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,3,開(kāi)放式接口 / 應(yīng)用編程接口(,API),5,如何在系統(tǒng)中注冊(cè)表單,4,如何在系統(tǒng)中注冊(cè)報(bào)表,6,其它,2,Oracle ERP,系統(tǒng)結(jié)構(gòu),1. 三層邏輯體系結(jié)構(gòu),User Interface,Application logic,Database logic,客戶端,應(yīng)用服務(wù)器,數(shù)據(jù)庫(kù)服務(wù)器,客戶端,Use
2、a web browser,,Netscape,,Internet Explorer,,On,,Windows,,Macintosh,,To display,,Java,,HTML,,應(yīng)用服務(wù)器層,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ù)庫(kù)服務(wù)器層:,,8,i,,9,i,,9,i,R2,Stored,,Procedures,PL/SQL,運(yùn)行原理,應(yīng)用服務(wù)器,數(shù)據(jù)
3、庫(kù)服務(wù)器,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)靈活性,,歷史記錄和診斷、檢查,,用戶可以看到當(dāng)前記錄來(lái)源于哪個(gè)表(視圖)、哪個(gè)字段和最后一查詢的,SQL,
4、語(yǔ)句等其它的信息。這對(duì)客戶化開(kāi)發(fā)有極大的幫助。,,Custom.,pll,,開(kāi)發(fā)人員只需客戶化此文件，而不需要修改,Oracle,的標(biāo)準(zhǔn)程序來(lái)達(dá)到客戶化的目的。用戶自已在,FORM,中定義字段，來(lái)保存其它的附加信息。,,彈性域,,用戶自已在,FORM,中定義字段，來(lái)保存其它的附加信息。,,附件,,對(duì)每一記錄能附上文件、文本信息或,Web Page,的大容量信息.,,修改,Forms,界面的文件功能或,Show,隱藏字段,,用戶能顯示自已想要顯示的字段，并能調(diào)整順序,,Export,,用戶能用,export,功能從,Form,中,export,數(shù)據(jù)到文件中。,,通常用來(lái)轉(zhuǎn)換到,Excel,文件中
5、。,2. Oracle,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-Form (See AVI File),,- Report (See AVI File),,- Discoverer (See AVI File),,- Workflow (See Following),,- PL/SQL,,- FSG (Financial Statement Generator),,Oracle,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-Form (See AVI File),,- Report (See AVI File),,- Discoverer (See AVI File),,- Workflow,,- PL/SQL,
6、,- FSG (Financial Statement Generator),,實(shí)例,：,3. 如何在系統(tǒng)中注冊(cè)表單,,,編譯表單,,登記表單,,注冊(cè)功能,,掛上菜單(子菜單 ->菜單),,分配菜單到職責(zé),,分配職責(zé)到用戶,,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,文件,用戶權(quán)限控制結(jié)構(gòu),1,2,3,4,5,2、,登記表單,3、,注冊(cè)功能,4.1、,掛上菜單(子菜單,),4.2、,掛上菜單(子系統(tǒng)菜單,),4.3、,掛上菜單(系統(tǒng)菜單,),5、,分配菜單到職責(zé),6、,分配職責(zé)到用戶,客戶化表單的界面,表單的數(shù)據(jù)來(lái)源(數(shù)據(jù)表,),表單的數(shù)據(jù)來(lái)源(字段,),
8、Oracle,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-Form (See AVI File),,,- Report (See AVI File),,- Discoverer (See AVI File),,- Workflow,,- PL/SQL,,- FSG (Financial Statement Generator),,4. 如何在系統(tǒng)中注冊(cè)報(bào)表,,,注冊(cè)可執(zhí)行并發(fā)程序,,注冊(cè)并發(fā)程序,,掛上請(qǐng)求組,1、注冊(cè)可執(zhí)行并發(fā)程序,2、注冊(cè)并發(fā)程序,3、掛上請(qǐng)求組,運(yùn)行報(bào)表,報(bào)表結(jié)果,Oracle,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-Form (See AVI File),,- Report (See AV
9、I File),,,- Discoverer (See AVI File),,- Workflow,,- PL/SQL,,- FSG (Financial Statement Generator),,Oracle,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-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,開(kāi)發(fā)工具及開(kāi)發(fā)過(guò)程,,,-Form (See AVI File),,- Report (See AVI File),,- Discoverer (See AVI File),,- Workflow (See Following),,,- PL/SQL,,- FSG (Financial Statement Generator),,5. Oracle,開(kāi)放式接口/,,應(yīng)用編程接口(,API),開(kāi)放式接口、應(yīng)用編程接口(,API),原理,Excel,,File,Table,Open Interface,,Table,Package,,API,Build in,,Proce
11、ss,Oracle,,ERP,Oracle,ERP,系統(tǒng),系統(tǒng)接口數(shù)據(jù)表和應(yīng)用編程接口(,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,使用的其它相關(guān)工具,,,-ADI (Application Desktop Integrator),,-,Dataload,(),,-,Sql,loader,,-,Fndload,,,- Toad,,- SQL Developer,,- etc…,Oracle,數(shù)據(jù)字典,全部數(shù)據(jù)字典在如下三個(gè)組,,- DBA
13、_OBJECTS - DBA_TABLES -DBA_VIEWS,,- ALL_OBJECTS - ALL_TABLES -ALL_VIEWS,,- USER_OBJECTS -USER_TABLES -USER_VIEWS,,,系統(tǒng)登錄用戶,,,由系統(tǒng)來(lái)定義、分配和控制,,,數(shù)據(jù)庫(kù)用戶,,只用,APPS,,Oracle,系統(tǒng)命名的標(biāo)準(zhǔn)規(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ù)庫(kù)觸發(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,
Oracle_ERP培訓(xùn)講稿-系統(tǒng)簡(jiǎn)介
