©CopyrightIBMCorporation2013IBMGlobalBusinessServicesOracleEBS-应用开发培训2013.11IBMGlobalBusinessServices©CopyrightIBMCorporation201321OracleERP系统开发工具及开发过程3开放式接口/应用编程接口(API)5如何在系统中注册应用开发4如何在系统中追溯数据来源2OracleERP系统结构内容IBMGlobalBusinessServices©CopyrightIBMCorporation20133三层逻辑体系结构UserInterfaceApplicationlogicDatabaselogic客户端应用服务器数据库服务器IBMGlobalBusinessServices©CopyrightIBMCorporation20134软件架构OracleDatabaseOracleApplicationServerHTTP/SJDBC/SQLNetWebServer:ApacheJavaEngineConcurrentManagerBusinessEventPersonalizationMaterializedViewsDataGuardPartitioningGridGlobalSingleDataModelWorkflowBI&ReportingOLAPUserInterfaceClientExcelAdd-InSpatialIBMGlobalBusinessServices©CopyrightIBMCorporation20135|客户端浏览器-InternetExplorer操作系统-Windows-Macintosh展示-Java-HTMLJAVA虚拟机IBMGlobalBusinessServices©CopyrightIBMCorporation20136|应用服务器层应用服务器层,有两个核心的作用。1、管理各种服务,为业务逻辑提供支撑。2、连接客户端和数据库的纽带。-WebservicesClientRequestWebListenerJavaServletEngine(OC4J)Data-FormsservicesFormsserver-ConcurrentProcessingserverReportingprogramsanddataupdatingprogramsinbackground.Table:FND_CONCURRENT_REQUESTSFND_CONCURRENT_PROGRAMSFND_CONCURRENT_PROCESSESFND_CONCURRENT_QUEUES-AdminserverApplypatches…IBMGlobalBusinessServices©CopyrightIBMCorporation20137|Oracle数据库服务性能强大的商用数据库-8i-9i-9iR2-10g-11g数据库服务器层IBMGlobalBusinessServices©CopyrightIBMCorporation20138|应用文件系统db/apps_st/data(DATA_TOP)datafile,tablespace,logfiledb/tech_st/10.2.0ORACLE_HOMEindbnodeapps/apps_st/appl(APPL_TOP)productfilesapps/apps_st/comn(COMMON_TOPorCOMN_TOP)dictionaryandfilesapps/tech_st/10.1.2&apps/tech_st/10.1.3(ORACLE_HOME)ApplicationtechnologystackcomponentsIBMGlobalBusinessServices©CopyrightIBMCorporation20139|APPL_TOP目录结构IBMGlobalBusinessServices©CopyrightIBMCorporation201310|APPL_TOP目录结构APPL_TOP包含:核心的技术文件与目录结构。所有的应用产品文件与目录结构。应用环境变量文件,CONTEXT_NAME.envIBMGlobalBusinessServices©CopyrightIBMCorporation201311|应用产品目录结构每个应用产品都在APPL_TOP目录结构下.例如:GL_TOP核心的技术文件与目录结构:AD_TOPAU_TOPFND_TOPIBMGlobalBusinessServices©CopyrightIBMCorporation201312|应用产品数据库用户(Schema)APPSSchemaAPPSschema可以访问所有ERP应用产品的数据库对象。IBMGlobalBusinessServices©CopyrightIBMCorporation201313开发过程开发环境测试环境产品环境开发人员版本管理Bugbase功能顾问用户需求功能设计开发测试打包移植测试移植CloneCloneIBMGlobalBusinessServices©CopyrightIBMCorporation201314系统维护日常工作数据库启动及关闭应用启动及关闭数据库备份及恢复Patch管理Clone管理定时收集统计信息并发管理器管理系统登陆,数据库连接,应用连接监控系统空间,表空间监控定时清理请求及请求日志请求监控:监控请求失败,警告等情况成批编译无效对象应用级优化及问题解决Tunning&TroubleShootingIBMGlobalBusinessServices©CopyrightIBMCorporation201315EBS应用开发人员工作对系统标准程序进行适当的客户化设计,编码,测试建立全新的客户化应用协助功能顾问解决系统相关问题程序级性能优化IBMGlobalBusinessServices©CopyrightIBMCorporation201316EBS技术体系Database&SystemApplicationDevHardwareSystemSADBA&SADeveloperHardwareNetworkOSOSDatabaseApplicationsystemadminBackup&recoverPatchadminCloneDatabaseApplicationarchitectureSql&Pl/sqlFormReport&XmlpubliserJava&OAFDiscoverWorkflowShellIBMGlobalBusinessServices©CopyrightIBMCorporation201317开发工具SQL&PLSQL程序开发-PLSQLDeveloper,SQL*PlusForm表单开发-OracleDeveloperJava开发-Jdeveloper报表开发工具-OracleReport-XMLPublisherBIS分析工具-Discover工作流工具-Workflow应用桌面集成工具-ADI-XMLPUBLISHERFORDESKTOP应用集成-SOA,企业服务总线-标准接口IBMGlobalBusinessServices©CopyrightIBMCorporation201318Oracle开发步骤1.注册应用.2.设置应用的目录结构.3.创建表、视图等等数据库对象.4.开发表单(Form).5.开发报表(Report).6.开发并发请求(PL/SQL).7.注册表单、报表、并发请求.IBMGlobalBusinessServices©CopyrightIBMCorporation201319在系统中注册表单1.编译表单2.登记表单3.注册功能4.挂上菜单(子菜单-菜单)5.分配菜单到职责6.分配职责到用户IBMGlobalBusinessServices©CopyrightIBMCorporation201320编译表单Forms1..fmb文件上传到应用产品目录2.Telnet连接到应用产品服务器3.切换到$AU_TOP/forms/ZHS4.执行编译语句IBMGlobalBusinessServices©CopyrightIBMCorporation201321编译表单Formsfrmcmp_batchFormNameapps/appspasswordfrmcmp_batchModule=TEST.fmbuserid=apps/appsoutput_file=/u01/oracle/visappl/po/11.5.0/forms/US/TEST.fmx编译Form的语法IBMGlobalBusinessServices©CopyrightIBMCorporation201322编译表单Forms4.CompilerFormfrmcmp_batchFormNameapps/appspasswordIBMGlobalBusinessServices©CopyrightIBMCorporation201323编译表单Forms5.Compiler成功,Create.fmx文件IBMGlobalBusinessServices©CopyrightIBMCorporation201324登记表单IBMGlobalBusinessServices©CopyrightIBMCorporation201325注册功能IBMGlobalBusinessServices©CopyrightIBMCorporation201326挂上菜单(子菜单)IBMGlobalBusinessServices©CopyrightIBMCorporation201327挂上菜单(系统菜单)IBMGlobalBusinessServices©CopyrightIBMCorporation201328分配菜单到职责IBMGlobalBusinessServices©CopyrightIBMCorporation201329分配职责到用户IBMGlobalBusinessServices©CopyrightIBMCorporation201330客户化表单的界面IBMGlobalBusinessServices©CopyrightIBMCorporation201331表单的数据来源(数据表)IBMGlobalBusinessServices©CopyrightIBMCorporation201332表单的数据来源(字段)IBMGlobalBusinessServices©CopyrightIBMCorporation201333在系统中注册报表1.注册可执行并发程序2.注册并发程序3.挂上请求组IBMGlobalBusinessServices©CopyrightIBMCorporation201334注册可执行并发程序IBMGlobalBusinessServices©CopyrightIBMCorporation201335注册并发程序IBMGlobalBusinessServices©CopyrightIBMCorporation201336挂上请求组IBMGlobalBusinessServices©CopyrightIBMCorporation201337运行报表IBMGlobalBusinessServices©CopyrightIBMCorporation201338报表结果IBMGlobalBusinessServices©CopyrightIBMCorporation201339开放式接口、应用编程接口(API)ExcelFileTableOpenInterfaceTablePackageAPIBuildinProcessOracle