资源描述
Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,*,Body Text,Second Level,Third Level,Fourth Level,Fifth Level,Click to edit Master title style,Sun_nan2004,1,目 录,Oracle ERP,系统开发工具及开发过程,3,开放式接口/应用编程接口(,API),5,如何在系统中注册表单,4,如何在系统中注册报表,6,其它,2,Oracle ERP,系统结构,1.三层,逻,逻辑体系结,构,构,UserInterface,Application logic,Database logic,客户端,应用服务器,数据库服务,器,器,客户端,Use awebbrowser,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 Server9,i,1.0.2.2.2,数据库服务,器,器层:,8,i,9,i,9,i,R2,Stored,Procedures,PL/SQL,运行原理,应用服务器,数据库服务,器,器,Web,Applications,Dictionary,Listener,Data,Browser,PL/SQL,Gateway,客户端,Workflow,Javacodedownloadedas needed,Applet cached on client,FormsNetwork Traffic,Browser runningForms,javaapplet,Data,Server,Forms,Server,LAN,WAN,Dial-up,系统灵活性,历史记录和,诊,诊断、检查,用户可以看,到,到当前记录,来,来源于哪个,表,表(视图),、,、哪个字段,和,和最后一查,询,询的,SQL,语句等其它,的,的信息。这,对,对客户化开,发,发有极大的,帮,帮助。,Custom.pll,开发人员只,需,需客户化此,文,文件，而不,需,需要修改,Oracle,的标准程序,来,来达到客户,化,化的目的。,用,用户自已在,FORM,中定义字段,，,，来保存其,它,它的附加信,息,息。,弹性域,用户自已在,FORM,中定义字段,，,，来保存其,它,它的附加信,息,息。,附件,对每一记录,能,能附上文件,、,、文本信息,或,或,Web Page,的大容量信,息,息.,修改,Forms,界面的文件,功,功能或,Show,隐藏字段,用户能显示,自,自已想要显,示,示的字段，,并,并能调整顺,序,序,Export,用户能用,export,功能从,Form,中,export,数据到文件,中,中。,通常用来转,换,换到,Excel,文件中。,2.Oracle,开发工具及,开,开发过程,-Form(See AVI File),-Report(See AVI File),-Discoverer(See AVI File),-Workflow(See Following),-PL/SQL,-FSG(Financial Statement Generator),Oracle,开发工具,及,及开发过,程,程,-Form(See AVI File),-Report(See AVI File),-Discoverer(See AVI File),-Workflow,-PL/SQL,-FSG(FinancialStatement Generator),实例,：,3.如,何,何在系统,中,中注册表,单,单,编译表单,登记表单,注册功能,挂上菜单(子菜单-菜,单,单),分配菜单,到,到职责,分配职责,到,到用户,CompilerForms,.fmb,文件上传,到,到,Server,Telnet,连接到,Server，LoginIn,切换到$,AU_TOP/forms/US,CompilerForm,4.Compiler Form,f60genapps/,f60gen Module=BD_TEST.fmb userid=apps/apps output_file=/u21/oracle/visappl/po/11.5.0/forms/US/BD_TEST.fmx,CompilerForm,4.Compiler Form,f60genapps/,CompilerForm,5.Compiler,成功,Create.fmx,文件,用户权限,控,控制结构,1,2,3,4,5,2、,登记表单,3、,注册功能,4.1、,挂上菜单(子菜单,),4.2、,挂上菜单(子系统,菜,菜单,),4.3、,挂上菜单(系统菜,单,单,),5、,分配菜单,到,到职责,6、,分配职责,到,到用户,客户化表,单,单的界面,表单的数,据,据来源(,数,数据表,),表单的数,据,据来源(,字,字段,),Oracle,开发工具,及,及开发过,程,程,-Form(See AVI File),-Report(See AVI File),-Discoverer(See AVI File),-Workflow,-PL/SQL,-FSG(FinancialStatement Generator),4.如,何,何在系统,中,中注册报,表,表,注册可执,行,行并发程,序,序,注册并发,程,程序,挂上请求,组,组,1、注册,可,可执行并,发,发程序,2、注册,并,并发程序,3、挂上,请,请求组,运行报表,报表结果,Oracle,开发工具及开,发,发过程,-Form(See AVIFile),-Report(See AVIFile),-Discoverer(SeeAVI File),-Workflow,-PL/SQL,-FSG(Financial Statement Generator),Oracle,开发工具及开,发,发过程,-Form(See AVIFile),-Report(See AVIFile),-Discoverer(SeeAVI File),-Workflow(See Following),-PL/SQL,-FSG(Financial Statement Generator),Workflow:,系统中的,Workflow:,Oracle,开发工具及开,发,发过程,-Form(See AVIFile),-Report(See AVIFile),-Discoverer(SeeAVI File),-Workflow(See Following),-PL/SQL,-FSG(Financial Statement Generator),5.Oracle,开放式接口/,应用编程接口(,API),开放式接口、,应,应用编程接口(,API),原理,Excel,File,Table,Open Interface,Table,Package,API,Buildin,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,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_INVOICE,S,View,_V,AP_INVOICES_V,Unique Index,_U,AP_INVOICES_U1,Non-Unique Index,_N,AP_INVOICES_N1,Sequence generator,_S,AP_INVOICES_S,Trigger,_,AR_CUSTOMER_PROFILES_BRU,Oracle,系统 数,据,据库触发器,CREATEOR REPLACETRIGGER ar_customer_profiles_bru,/*$Header:arplt26.sql70.4 96/10/29 15:04:58 portingship$*/,BEFOREUPDATE ON AR.AR_CUSTOMER_PROFILES,FOR EACH ROW,DECLARE,CreditHoldvarchar2(1):=null;,RiskCodevarchar2(30):=null;,CreditRatingvarchar2(30):=null;,ChangesMadevarchar2(1):=N;,BEGIN,IF(:new.credit_hold!=:old.credit_hold)OR,(:new.credit_holdis null and:old.credit_holdis notnull)OR,(:new.credit_holdis not nulland:old.credit_hold isnull)THEN,CreditHold:=:old.credit_hold;,/*IFFIELDVALUEOF credit_hold ISCHANGED THENSET*/,/*THEVALUEOF THIS VARIABLETO Y*/,ChangesMade:=Y;,END IF;,IF(:new.risk_code!=:old.risk_code)OR,(:new.risk_code is nulland:old.risk_code is not null)OR,(:new.risk_code is notnull and:old.risk_codeis null)THEN,RiskCode:=:old.risk_code;,ChangesMade:=Y;,END IF;,IF(:new.credit_rating!=:old.credit_rating)OR,(:new.credit_rating isnull and:old.credit_rating isnot null)OR,(:new.credit_rating isnot null and:old.credit_rating is null)THEN,CreditRating:=:old.credit_rating;,ChangesMade:=Y;,END IF;,IF Chang
展开阅读全文