OracleEBS应用开发培训

1、 Copyright IBM Corporation 2013IBM Global Business ServicesOracle EBS - 应用开发培训2013.11IBM Global Business Services Copyright IBM Corporation 20132Oracle ERP系统开发工具及开发过程系统开发工具及开发过程开放式接口开放式接口 / 应用编程接口应用编程接口(API)如何在系统中注册应用开发如何在系统中注册应用开发如何在系统中追溯数据来源如何在系统中追溯数据来源Oracle ERP系统结构系统结构内容内容IBM Global Business Ser

2、vices Copyright IBM Corporation 20133三层逻辑体系结构三层逻辑体系结构User InterfaceApplication logicDatabase logic客户端应用服务器数据库服务器IBM Global Business Services Copyright IBM Corporation 20134软件架构软件架构Oracle DatabaseOracle Application ServerHTTP/SJDBC/SQL NetWeb Server: ApacheJava EngineConcurrent ManagerBusiness EventP

3、ersonalizationMaterialized ViewsData GuardPartitioningGridGlobal Single Data ModelWorkflowBI & ReportingOLAPUser InterfaceClientExcelAdd-InSpatialIBM Global Business Services Copyright IBM Corporation 20135 | 客户端客户端 浏览器-Internet Explorer 操作系统-Windows-Macintosh 展示-Java-HTML JAVA虚拟机IBM Global Business

4、 Services Copyright IBM Corporation 20136 | 应用服务器层应用服务器层应用服务器层，有两个核心的作用。1、管理各种服务，为业务逻辑提供支撑。2、连接客户端和数据库的纽带。-Web services Client Request Web Listener Java Servlet Engine(OC4J) Data-Forms services Forms server-Concurrent Processing server Reporting programs and data updating programs in background. Tab

5、le: FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROGRAMS FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUES-Admin server Apply patchesIBM Global Business Services Copyright IBM Corporation 20137 | Oracle 数据库服务 性能强大的商用数据库-8i-9i-9iR2-10g-11g数据库服务器层数据库服务器层IBM Global Business Services Copyright IBM Corporation 2

6、0138 | 应用文件系统应用文件系统db/apps_st/data (DATA_TOP) datafile, tablespace, log filedb/tech_st/10.2.0 ORACLE_HOME in db nodeapps/apps_st/appl (APPL_TOP) product filesapps/apps_st/comn (COMMON_TOP or COMN_TOP) dictionary and filesapps/tech_st/10.1.2 & apps/tech_st/10.1.3 (ORACLE_HOME) Application technology

7、stack componentsIBM Global Business Services Copyright IBM Corporation 20139 | APPL_TOP 目录结构目录结构IBM Global Business Services Copyright IBM Corporation 201310 | APPL_TOP 目录结构目录结构APPL_TOP 包含: 核心的技术文件与目录结构。 所有的应用产品文件与目录结构。应用环境变量文件，.envIBM Global Business Services Copyright IBM Corporation 201311 | 应用产品

8、应用产品 目录结构目录结构 每个应用产品都在APPL_TOP目录结构下. 例如: GL_TOP 核心的技术文件与目录结构：核心的技术文件与目录结构：AD_TOP AU_TOP FND_TOPIBM Global Business Services Copyright IBM Corporation 201312 | 应用产品数据库用户（应用产品数据库用户（Schema） APPS Schema APPS schema 可以访问所有ERP应用产品的数据库对象。IBM Global Business Services Copyright IBM Corporation 201313开发过程开发过程

9、开发环境测试环境产品环境开发人员版本管理Bug base功能顾问用户需求功能设计开发测试打包移植测试移植CloneCloneIBM Global Business Services Copyright IBM Corporation 201314系统维护日常工作系统维护日常工作l数据库启动及关闭l应用启动及关闭l数据库备份及恢复lPatch 管理lClone 管理l定时收集统计信息l并发管理器管理l系统登陆,数据库连接，应用连接监控l系统空间，表空间监控l定时清理请求及请求日志l请求监控：监控请求失败，警告等情况l成批编译无效对象l应用级优化及问题解决 Tunning&Trouble Shoo

10、tingIBM Global Business Services Copyright IBM Corporation 201315EBS应用开发人员工作应用开发人员工作l对系统标准程序进行适当的客户化l设计，编码，测试 建立全新的客户化应用l协助功能顾问解决系统相关问题l程序级性能优化IBM Global Business Services Copyright IBM Corporation 201316EBS 技术体系技术体系Database&SystemApplication DevHardware SystemSADBA&SADeveloperHardwareNetworkOSOSDat

11、abaseApplication system adminBackup&recoverPatch adminCloneDatabaseApplication architectureSql&Pl/sqlFormReport &Xml publiserJava&OAFDiscoverWorkflowShellIBM Global Business Services Copyright IBM Corporation 201317开发工具开发工具SQL&PLSQL程序开发-PLSQL Developer, SQL*PlusForm表单开发-Oracle Developer Java开发-Jdeve

12、loper报表开发工具-Oracle Report-XML PublisherBIS分析工具-Discover工作流工具-Workflow应用桌面集成工具-ADI-XML PUBLISHER FOR DESKTOP应用集成-SOA,企业服务总线-标准接口IBM Global Business Services Copyright IBM Corporation 201318Oracle 开发步骤开发步骤1. 注册应用. 2. 设置应用的目录结构.3. 创建表、视图等等数据库对象.4. 开发表单(Form). 5. 开发报表(Report). 6. 开发并发请求(PL/SQL). 7. 注册表单

13、、报表、并发请求.IBM Global Business Services Copyright IBM Corporation 201319在系统中注册表单在系统中注册表单1. 编译表单编译表单2. 登记表单登记表单3. 注册功能注册功能4. 挂上菜单挂上菜单(子菜单子菜单 -菜单菜单)5. 分配菜单到职责分配菜单到职责6. 分配职责到用户分配职责到用户 IBM Global Business Services Copyright IBM Corporation 201320编译表单编译表单 Forms1. .fmb文件上传到文件上传到应用产品目录应用产品目录2. Telnet 连接到连接到应

14、用产品服务器应用产品服务器3. 切换到切换到 $AU_TOP/forms/ZHS4. 执行编译语句执行编译语句IBM Global Business Services Copyright IBM Corporation 201321编译表单编译表单 Formsfrmcmp_batch apps/frmcmp_batch Module=TEST.fmb userid=apps/apps output_file=/u01/oracle/visappl/po/11.5.0/forms/US/TEST.fmx编译编译Form的语法的语法IBM Global Business Services Copy

15、right IBM Corporation 201322编译表单编译表单 Forms4.Compiler Formfrmcmp_batch apps/IBM Global Business Services Copyright IBM Corporation 201323编译表单编译表单 Forms5.Compiler 成功成功 ,Create .fmx 文件文件IBM Global Business Services Copyright IBM Corporation 201324登记表单登记表单IBM Global Business Services Copyright IBM Corpo

16、ration 201325注册功能注册功能IBM Global Business Services Copyright IBM Corporation 201326挂上菜单挂上菜单(子菜单子菜单)IBM Global Business Services Copyright IBM Corporation 201327挂上菜单挂上菜单(系统菜单系统菜单)IBM Global Business Services Copyright IBM Corporation 201328分配菜单到职责分配菜单到职责IBM Global Business Services Copyright IBM Corpo

17、ration 201329分配职责到用户分配职责到用户IBM Global Business Services Copyright IBM Corporation 201330客户化表单的界面客户化表单的界面IBM Global Business Services Copyright IBM Corporation 201331表单的数据来源表单的数据来源(数据表数据表)IBM Global Business Services Copyright IBM Corporation 201332表单的数据来源表单的数据来源(字段字段)IBM Global Business Services Cop

18、yright IBM Corporation 201333在系统中注册报表在系统中注册报表1. 注册可执行并发程序注册可执行并发程序2. 注册并发程序注册并发程序3. 挂上请求组挂上请求组IBM Global Business Services Copyright IBM Corporation 201334注册可执行并发程序注册可执行并发程序IBM Global Business Services Copyright IBM Corporation 201335注册并发程序注册并发程序IBM Global Business Services Copyright IBM Corporation

19、 201336挂上请求组挂上请求组IBM Global Business Services Copyright IBM Corporation 201337运行报表运行报表IBM Global Business Services Copyright IBM Corporation 201338报表结果报表结果IBM Global Business Services Copyright IBM Corporation 201339开放式接口、应用编程接口开放式接口、应用编程接口(API)Excel FileTableOpen Interface TablePackage APIBuild in

20、ProcessOracle ERPOracle ERP系统IBM Global Business Services Copyright IBM Corporation 201340系统接口数据表和应用编程接口系统接口数据表和应用编程接口(API)程序示例程序示例Module Function Interface Table/APICommentsAR CustomersRA_CUSTOMERS_INTERFACE_ALLRA_CUSTOMER_PROFILES_INT_ALLRA_CUSTOMER_BANKS_INT_ALLOpen interface tableAR ReceiptsAR_R

21、ECEIPT_API_PUB ARP_PROCESS_MISC_RECEIPTS.INSERT_MISC_RECEIPTAPI packagesGL JournalsGL_INTERFACEOpen interface tableIBM Global Business Services Copyright IBM Corporation 201341其它相关工具其它相关工具IBM Global Business Services Copyright IBM Corporation 201342数据字典和开发帐号数据字典和开发帐号全部数据字典在如下三个组- DBA_OBJECTS - DBA_T

22、ABLES-DBA_VIEWS - ALL_OBJECTS - ALL_TABLES -ALL_VIEWS- USER_OBJECTS -USER_TABLES-USER_VIEWS系统登录用户 由系统来定义、分配和控制数据库用户只用 APPSIBM Global Business Services Copyright IBM Corporation 201343EBS命名标准规则命名标准规则TypeRulesExampleTableEnglish Plural, start with module nameAP_INVOICESView_VAP_INVOICES_VUnique Index_U AP_INVOICES_U1Non-Unique Index_NAP_INVOICES_N1Sequence generator_SAP_INVOICES_STrigger_TR