OracleEBS应用开发培训

©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-HTMLJAVA虚拟机IBMGlobalBusinessServices©CopyrightIBMCorporation20136|应用服务器层应用服务器层，有两个核心的作用。1、管理各种服务，为业务逻辑提供支撑。2、连接客户端和数据库的纽带。-WebservicesClientRequestWebListenerJavaServletEngine(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,logfiledb/tech_st/10.2.0ORACLE_HOMEindbnodeapps/apps_st/appl(APPL_TOP)productfilesapps/apps_st/comn(COMMON_TOPorCOMN_TOP)dictionaryandfilesapps/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*PlusForm表单开发-OracleDeveloperJava开发-Jdeveloper报表开发工具-OracleReport-XMLPublisherBIS分析工具-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