OracleEBS全模块设置详例.doc

Doc Ref: 信息技术最佳实践二月 19, 2009信息技术最佳实践ORACLE核心应用技术E-Business Suite全模块设置详例Author:黄建华Creation Date:April 12, 2005Last Updated:二月 19, 2009Document Ref: Version:DRAFT 1AApprovals: Copy Number_Document ControlChange Record7DateAuthorVersionChange Reference12-Apr-05Jianhua.HuangDraft 1aNo Previous DocumentReviewersNamePositionDistributionCopy No.NameLocation1Library MasterProject Library2Project Manager34Note To Holders:If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.ContentsDocument Controlii1.定义客户化应用21.1.服务器端设置21.1.1.文件系统（File System）21.1.2.注册环境变量31.2.数据库端设置31.2.1.创建表空间（Tablespace）31.2.2.创建数据库用户（User）31.2.3.授权41.2.4.创建Package41.3.应用设置41.3.1.注册客户化应用（Register Application）41.3.2.Register Oracle User41.3.3.Add Application To Standard Data Group51.3.4.Create Request Group For Customized Application51.3.5.Create Customized Menu61.3.6.Create Customized Responsibility71.3.7.附：adsplice92.System Administrator132.1.Profiles132.2.未完待续143.GL, General Ledger Setup153.1.组织结构规划153.2.账户结构（COA，Chart Of Account）规划153.3.Accounting Flexfield Value Sets (Required)153.4.Accounting Flexfield Structure (Required)183.5.Accounting Flexfield Rollup Groups (Optional)203.6.Accounting Flexfield Segment Values (Required)203.7.Accounting Flexfield Security Rules (Dependent)223.8.Accounting Flexfield Cross-Validation Rules (Optional)233.9.New Period Types (Dependent)253.10.Accounting Calendar (Required)253.11.Enable Currency (Required)273.12.Set Of Books (Required)273.13.System Profile Option (Required)283.14.Locations (Required)283.15.Business Group (Optional)293.16.Organization and Organization Relationships (Required)303.17.Responsibility (Required)313.18.System Profile Option (Required)313.19.Convert to Multiple Organization Architecture (Required)323.20.Inventory Organization Security (Optional)333.21.Currency Conversion Rate Type (Optional)333.22.Historical Rates (Optional)343.23.Additional Journal Sources and Categories (Optional)343.24.Summary Accounts (Optional)353.25.Auto Reverse (Optional)363.26.Auto Post (Optional)363.27.Encumbrance Types (Optional)363.28.Concurrent Program Controls (Optional)373.29.Run the MultiOrg Setup Validation Report (Required)373.30.Set Top Reporting Level Profile Option (optional)373.31.Open Accounting Period (Required)384.INV, Inventory Setup394.1.System Item Flexfield Structure (Required)394.2.Item Catalogs Flexfield Structure (Required)394.3.Stock Locators Flexfield Structure (Optional)404.4.Account Aliases Flexfield Structure (Optional)404.5.Sales Orders Flexfield Structure (Required)404.6.Item Categories Flexfield Value Sets (Required)414.7.Item Categories Flexfield Structure (Required)424.8.Item Categories Flexfield Segment Values (Required)424.9.Locations (Required)434.10.MFG Workdays Calendar (Required)444.11.Attribute Controls (Required)444.12.Inventory Organization (Required)454.13.Inventory Organization Parameter (Required)464.14.Receiving Parameter (Required)484.15.Unit Of Measure (Required)494.16.Item Categories (Required)504.17.Category Set (Required)514.18.Default Category Sets (Required With Default)534.19.Sub Inventory (Required)534.20.Locator (Optional)544.21.Account Aliases (Optional)554.22.Transaction Sources, Types (Optional)564.23.Transaction Reasons (Optional)574.24.Organization Access (Optional)584.25.Item Type Quick Codes (Optional)584.26.Item Templates (Optional)594.27.System Profile Option (Required)604.28.Open Inventory Accounting Period (Required)605.AP, Accounts Payables Setup625.1.Choose SOB (Required)625.2.Payment Terms (Required)625.3.Invoice Tolerances (Optional)635.4.Invoice Hold and Release Name (Required with Default)645.5.Lookup Codes (Required with Default)655.6.Expense Report Templates (Optional)655.7.Master Inventory Organization (Required)665.8.Financials Options (Required)665.9.Payable Options (Required)675.10.Tax Codes (Dependent)695.11.Payment Programs (Optional)705.12.Payment Formats (Optional)705.13.Bank and Bank Accounts (Required)715.14.Open Payables Accounting Period (Required)735.15.Aging Periods (Optional)746.PO, Purchase Order Setup756.1.System Profile Option (Required)756.2.Needed Inventory Setups (Required)766.3.Job Flexfield Value Sets (Required)766.4.Job Flexfield Structure (Required)766.5.Job Flexfield Segment Values (Required)776.6.Position Flexfield Value Sets (Required)776.7.Position Flexfield Structure (Required)786.8.Position Flexfield Segment Values (Required)786.9.People Group Flexfield Value Sets (Required)786.10.People Group Flexfield Structure (Required)796.11.People Group Flexfield Segment Values (Required)796.12.Jobs (Required)796.13.Position (Required)806.14.Employees (Required)816.15.Position Hierarchy (Required)836.16.Fill Employee Hierarchy (Required)856.17.Approval Groups (Required)856.18.Approval Assignments (Required)866.19.Lookup Codes (Required)876.20.Purchasing Options (Required)896.21.Document Types (Required)906.22.Buyers (Required)916.23.Suppliers (Required)926.24.Line Types (Optional)936.25.Open Purchasing Periods (Required)936.26.Concurrent Program: Purchasing Database Administration (Optional)947.AR, Account Receivables957.1.Account Generator (Optional)957.2.Descriptive Flexfields (Optional)957.3.System Profile Option (Required)967.4.Territory Flexfield Value Sets (Optional)977.5.Territory Flexfield Structure (Optional)977.6.Territory Flexfield Segment Values (Optional)987.7.Territories (Optional)987.8.Sales Tax Location Flexfield Structure (Optional)997.9.AutoCash Rule Sets (Optional)997.10.Lookup Codes (Optional)1007.11.Demand Classes (Optional)1007.12.AutoInvoice Line Ordering Rules (Optional)1007.13.AutoInvoice Grouping Rules (Optional)1017.14.Application Rule Sets (Required With Default Value)1027.15.System Options (Required)1037.16.Countries and Territories (Optional)1057.17.Payment Terms (Required with Default)1057.18.Accounting Rules (Required)1067.19.AutoAccounting (Required)1077.20.Transaction Types (Required)1087.21.Transaction Sources (Required)1097.22.Collectors (Required)1117.23.Approval Limits (Optional)1117.24.Distribution Sets (Optional)1127.25.Receivable Activities (Required)1137.26.Banks (Required)1147.27.Receipt Classes (Required)1147.28.Receipt Sources (Required)1157.29.Aging Buckets (Optional)1167.30.Statement Cycles (Optional)1177.31.Standard Messages/Dunning Letters/Dunning Letter Sets (Optional)1187.32.Salespersons (Required)1187.33.Customer Profile Classes (Required)1197.34.Customers (Required)1207.35.Remit-to Addresses (Required)1227.36.Lockboxes/Transmission Formats/Format Programs (Optional)1237.37.Standard Memo Lines (Optional)1237.38.Cross Currency Receipts (Optional)1237.39.Taxes (Optional)1248.OM, Order Management1258.1.Descriptive Flexfields (Optional)1258.2.System Profile Option (Required)1258.2.1.OM System Parameter (Required)1268.3.Lookup Codes (Required with Default)1278.4.Sales1278.5.Workflow1278.6.Freight Carriers (Required)1278.7.Price List (Required)1288.8.Modifiers (Required)1298.9.Transaction Types (Required)1308.10.Document Sequences (Required)1338.11.Sequence Assignments (Required)1348.12.Picking Rules (Optional)1348.13.Document Sets (Optional)1348.14.Shipping Document Categories (Required)1358.15.Shipping Parameter (Required)1358.16.Shipping Execution Role (Required)1368.17.Shipping Execution Grants (Required)1378.18.Defaulting (Required)1388.19.Run Report: Build Attribute Mapping Rules (Required)1409.BOM, Bills of Material1419.1.System Profile Option (Required)1419.2.Parameters (Required)1429.3.Alternates (Required)1439.4.Calendars (Required)1439.5.Resources (Required)1449.6.Simulation Sets (Required)1459.7.Resource Groups (Required)1469.8.Department Classes (Required)1479.9.Departments (Required)1479.10.Overhead (Required)14810.WIP, Work in Process15010.1.System Profile Option (Required)15010.2.Parameters (Required)15010.3.Accounting Classes (Required)15111.MRP, Manufacturing Resource Planning15311.1.System Profile Option (Required)15311.2.Planners (Required)15411.3.Parameters (Required)15411.4.Planning Manager (Required)15511.5.Demand Class (Optional)15511.6.Forecast Sets (Optional)15611.7.MDS Names (Required)15711.8.MPS Names&Options (Required)15711.9.MRP Names&Options (Required)15812.CST, Cost Management16012.1.System Profile Option (Required)16012.2.Function/Menu Exclusion (Optional)16012.3.Material Subelement (Optional)16112.4.Overhead Subelement (Optional)16112.5.Organization Cost Groups (Required)16212.6.Org Cost Group/Cost Type Association (Required)16312.7.Interface Managers (Required)16313.Open and Closed Issues for this Deliverable165Open Issues165Closed Issues165Open and Closed Issues for this Deliverable 165全模块设置详例File Ref: 1a9136914ba4b12b7deddae4468ec9b0.pdf (v. DRAFT 1A )Company Confidential - For internal use only1. 定义客户化应用建议每个实施项目都建立一个客户化应用，这个几分钟就可以做完的事，却可以受益无穷，说不定哪天就派上用场。所有客户化定义（Form/Function/Menu/Request Group/Responsibility/Execute/Program）都放在这个应用下，不要修改标准的东西，要改也要新拷贝一份来改。做客户化工作的时候要遵循基本的命名规范，这里我们假定客户化应为SCF，这样每个客户化的地方都要遵循一个最简单的规则，即名称前缀为SCF_。客户化应用，也可以用系统命令adsplice，下面的很多步骤都可以自动完成。1.1. 服务器端设置UNIX下，安装EBS会创建两个操作系统用户，一个是应用用户APPLMGR，一个是ORAMGR。不同环境的具体名字可能不同，如applprod和oraprod。Windows下，则一般用同一个操作系统用户。1.1.1. 文件系统（File System）文件系统（File System）参照Oracle标准结构。以Applmgr登录操作系统cd $APPL_TOP（Windows的变量格式为%APPL_TOP%）mkdir scfcd scfmkdir 1.0.0cd 1.0.0mkdir forms最后建成的目录结构为：scf 1.0.0 admin import sql-放类型为SQL*Plus 的Executable的脚本源文件 bin-放类型为SQL Loader 的Executable的控制文件 forms US-放编译过的fmx文件 lib log mesg patch reports US-放rpt文件，注意扩展名是小写 resource1.1.2. 注册环境变量注册环境变量以Applmgr登录操作系统cd $APPL_TOPvi PROD_huajhua.env SCF_TOP=/app/d01/oracle/prodappl/scf/1.0.0 -加在文件最后面，路径视具体情况而定Export SCF_TOP（Windows下，加入set SCF_TOP=E:oracleprodapplscf1.0.0即可）保存，请管理员重启应用，条件允许的话自己来cd $APPLCSF/scripts/PROD-这下面还有启停Apache、Concurrent -Manager、Form、Report、Metrix的脚本./adstpall.sh apps/apps./adstrtal.sh apps/apps注意：上面的步骤最好在_.xml（具体路径和文件名用echo $CONTEXT_FILE）里面加，然后运行adautocfg。Windows平台需要检查注册表是否自动添加了客户化TOP。1.2. 数据库端设置1.2.1. 创建表空间（Tablespace）创建表空间（Tablespace）以System用户连接数据库create tablespace scf datafile /appdata/data/proddata/scf_data01.dbf size 20M reuse autoextend on next 10M;注意：11.5.10之后，数据统一放在表空间APPS_TS_TX_DATA、索引统一放在APPS_TS_TX_IDX。1.2.2. 创建数据库用户（User）创建数据库用户（User）create user scf identified by scf default tablespace scf temporary tablespace temp;1.2.3. 授权授权grant connect,resource to scf;grant select any table to scf;grant select any sequence to scf;1.2.4. 创建Package从APPS下取得，编译在scf下APPS_DDL和APPS_ARRAY_DDL1.3. 应用设置1.3.1. 注册客户化应用（Register Application）注册客户化应用（Register Application）N: Application/RegisterApplicationShort NameBasepathDescriptionSCF Customized SystemSCFSCF_TOPSCF Customized System1.3.2. Register Oracle UserRegister Oracle UserN: Security/Oracle/RegisterDatabase User NamePasswordPrivilegeInstall GroupDescriptionSCFSCFEnabled1SCF Customized System1.3.3. Add Application To Standard Data GroupAdd Application To Standard Data Group数据组的功能是提供Application和Database的连接用户，即使用某个应用的时候，该使用哪个用户与数据库连接。标准是：Standard Data Group用APPS用户；Multiple Reporting Currencies用上面注册的Oracle User。N: Security/Oracle/Datagroup/Query Standard Data GroupApplicationOracle IDDescriptionSCF Customized SystemAPPSSCF Customized System1.3.4. Create Request Group For Customized ApplicationCreate Request Group For Customized Application请求组可理解为并发程序的集合，是并发程序和职责的桥梁。N: Security/Responsibility/RequestGroupApplicationSCF Customized ProgramSCF Customized SystemTypeNameApplicationApplicationApplication Object LibraryApplication Object LibraryApplicationGeneral LedgerGeneral LedgerApplicationAssetsAssetsApplicationPayablesPayablesApplicationPurchasingPurchasingApplicationReceivablesReceivablesApplicationInventoryInventoryApplicationOrder ManagementOrder ManagementApplicationBills of MaterialBills of MaterialApplicationWork in ProcessWork in ProcessApplicationCost ManagementCost ManagementApplicationHuman ResourcesHuman ResourcesApplicationAlertAlertApplicationAdvanced PricingAdvanced PricingApplicationManufacturingManufacturingApplicationXML PublisherXML PublisherApplicationXML GatewayXML GatewayApplicationWeb Applications Desktop IntegratorWeb Applications Desktop IntegratorApplicationCRM FoundationCRM FoundationApplicationMaster Scheduling/MRPMaster Scheduling/MRP为了测试方便，不妨把常用模块的并发程序以Application为单位都加进来，这样就不需要切换来切换去。1.3.5. Create Customized MenuCreate Customized Menu定义客户化菜单。N: Application/MenuMenuUser Menu NameSCF_SUPER_USERSCF Customized System Super UserSeqPromptSubmenu10General Ledger Super UserGL_SUPERUSER20Payables ManagerAP_NAVIGATE_GUI1230Receivables ManagerAR_NAVIGATE_GUI40Fixed Assets ManagerFA_MAIN50Cost ManagementCST_NAVIGATE60InventoryINV_NAVIGATE70Purchasing Super UserPurchasing SuperUser GUI80Order Management Super UserONT_SUPER_USER90Oracle Pricing ManagerQP_PRICING_MANAGER100Bills of MaterialBOM_NAVIGATE_GUI110Work In ProcessWIP_NAVIGATE_10G120Material PlannerMRP_NAVIGATE4.0130Global Super HRMS ManagerGLB SHRMS Navigator140CRM AdministratorCRM Administrator Main Menu170XML Publisher AdministratorXDO: Template Manager Root Menu180Alert ManagerALR_OAM_NAV GUI190Application DeveloperNavigator Menu - Application Developer GUI200System AdministratorNavigator Menu - System Administrator GUI为了测试方便，不妨把常用模块的顶层菜单都挂进来；这样就不需要切换来切换去，保存之后系统自动提交请求Compile Security编译菜单。1.3.6. Create Customized ResponsibilityCreate Customized ResponsibilityN: SYSADMIN/Security/Responsibility/DefineResponsibility NameApplicationResponsibility KeySCF Customized System Super UserSCF Customized SystemSCF_SUPER_USERData Group NameRequest Group NameStandardSCF Customized ProgramMenuSCF Customized System Super User为了使Tools菜单上的Close Other Form有效，需要加入一个Menu Exclusions。TypeNameFactionNavigator: Disable MultiformCreate UserN: SYSADMIN/Security/User/DefineUser NamePasswordHuajhuaHuajhua（输入两次）ResponsibilitySCF Customized System Super UserApplication DeveloperSystem AdministratorGeneral Ledger Super UserXML GatewayXML Publisher Administrator需要的职责1.3.7. 附：adsplice实现步骤：按照指定格式，准备newprods.txt、prod.txt、terr.txt三个文件，放到$APPL_TOP/admin下，运行adsplice，按照提示即可完成。唯一要注意的是目录结构还是要自己手工创建、prod.txt中的应用ID号最好是用fnd_application_s.nextval获得的。newprods.txt% Splicer control file format 11.5.A# $Header: newprods.txt 115.0 2006/06/10 01:46:19 applrt noship $# Section for Hand Extension Application product=handbase_product_top=*APPL_TOP*oracle_schema=handsizing_factor=100main_tspace=APPS_TS_TX_DATAindex_tspace=APPS_TS_TX_IDXtemp_tspace=TEMPdefault_tspace=APPS_TS_TX_DATA # end of Hand Extension Applicationhandprod.txt# +=+# | Copyrght (c) 2001 Oracle Corporation Redwood Shores, CA USA |# | All rights reserved. |# +=+# | FILENAME |# | handprod.txt |# | $Header: handprod.txt 115.1 2006/02/11 00:52:08 Hand China noship $ |# | |# | NOTES |# | All comment lines must begin with a #. |# | This file is changed with each release. |# +=+# # fi