Doc Ref: 信息技术最佳实践November 21, 2005信息技术最佳实践ORACLE核心应用技术E-Business Suite全模块设置详例Author:黄建华Creation Date:April 12, 2005Last Updated:February 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