HAND-深入浅出Oracle EBS之全模块设置详例

OracleERP最佳技术实践E-BUSINESSSUITEBR100–全模块设置详例ISMFGAuthor:黄建华Jianhua.HuangMSN:huajhua@CreationDate:April12,2005LastUpdated:December12,2006DocumentRef:<DocumentReferenceNumber>Version:DRAFT1Aals <Approver <Approver2>CopyNumber_____OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,20067DateDateAuthorVersionChangeReference12-Apr-05Jianhua.HuangDraft1aNoPreviousDocumentNameitionCopyNo.NameLocation1LibraryMasterProjectLibrary2ProjectManager34Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.FIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyDocumentControliiOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,2006tents 1.1.服务器端设置 11.1.1.文件系统(FileSystem) 11.1.2.注册环境变量 21.2.数据库端设置 21.2.1.创建表空间(Tablespace) 21.2.2.创建数据库用户(User) 2权 31.2.4.创建Package 31.3.应用设置 31.3.1.注册客户化应用(RegisterApplication) 31.3.2.RegisterOracleUser 31.3.3.AddApplicationToStandardDataGroup 41.3.4.CreateRequestGroupForCustomizedApplication 41.3.5.CreateCustomizedMenu 51.3.6.CreateCustomizedResponsibility 62.SystemAdministrator 92.1.Profiles 9 3.GL,GeneralLedgerSetup 113.1.组织结构规划 113.2.账户结构(COA，ChartOfAccount)规划 113.3.AccountingFlexfieldValueSets(Required) 113.4.AccountingFlexfieldStructure(Required) 143.5.AccountingFlexfieldRollupGroups(Optional) 163.6.AccountingFlexfieldSegmentValues(Required) 163.7.AccountingFlexfieldSecurityRules(Dependent) 183.8.AccountingFlexfieldCross-ValidationRules(Optional) 193.9.NewPeriodTypes(Dependent) 213.10.AccountingCalendar(Required) 213.11.EnableCurrency(Required) 233.12.SetOfBooks(Required) 233.13.SystemProfileOption(Required) 243.14.Locations(Required) 243.15.BusinessGroup(Optional) 253.16.OrganizationandOrganizationRelationships(Required) 263.17.Responsibility(Required) 273.18.SystemProfileOption(Required) 27FIN/DIS/MFG应用模块DocumentControliiiFileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,20063.19.ConverttoMultipleOrganizationArchitecture(Required) 283.20.InventoryOrganizationSecurity(Optional) 293.21.CurrencyConversionRateType(Optional) 293.22.HistoricalRates(Optional) 303.23.AdditionalJournalSourcesandCategories(Optional) 303.24.SummaryAccounts(Optional) 313.25.AutoReverse(Optional) 323.26.AutoPost(Optional) 323.27.EncumbranceTypes(Optional) 323.28.ConcurrentProgramControls(Optional) 333.29.RuntheMultiOrgSetupValidationReport(Required) 333.30.SetTopReportingLevelProfileOption(optional) 333.31.OpenAccountingPeriod(Required) 344.INV,InventorySetup 354.1.SystemItemFlexfieldStructure(Required) 354.2.ItemCatalogsFlexfieldStructure(Required) 354.3.StockLocatorsFlexfieldStructure(Optional) 364.4.AccountAliasesFlexfieldStructure(Optional) 364.5.SalesOrdersFlexfieldStructure(Required) 364.6.ItemCategoriesFlexfieldValueSets(Required) 374.7.ItemCategoriesFlexfieldStructure(Required) 384.8.ItemCategoriesFlexfieldSegmentValues(Required) 38LocationsRequired 394.10.MFGWorkdaysCalendar(Required) 404.11.AttributeControls(Required) 404.12.InventoryOrganization(Required) 414.13.InventoryOrganizationParameter(Required) 424.14.ReceivingParameter(Required) 444.15.UnitOfMeasure(Required) 454.16.ItemCategories(Required) 464.17.CategorySet(Required) 474.18.DefaultCategorySets(RequiredWithDefault) 494.19.SubInventory(Required) 49atorOptional 4.21.AccountAliases(Optional) 514.22.TransactionSources,Types(Optional) 524.23.TransactionReasons(Optional) 534.24.OrganizationAccess(Optional) 544.25.ItemTypeQuickCodes(Optional) 54ItemTemplates(Optional) 554.27.SystemProfileOption(Required) 564.28.OpenInventoryAccountingPeriod(Required) 565.AP,AccountsPayablesSetup 585.1.ChooseSOB(Required) 585.2.PaymentTerms(Required) 585.3.InvoiceTolerances(Optional) 595.4.InvoiceHoldandReleaseName(RequiredwithDefault) 605.5.LookupCodes(RequiredwithDefault) 615.6.ExpenseReportTemplates(Optional) 615.7.MasterInventoryOrganization(Required) 625.8.FinancialsOptions(Required) 625.9.PayableOptions(Required) 635.10.TaxCodes(Dependent) 655.11.PaymentPrograms(Optional) 66FIN/DIS/MFG应用模块DocumentControlivFileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,20065.12.PaymentFormats(Optional) 665.13.BankandBankAccounts(Required) 675.14.OpenPayablesAccountingPeriod(Required) 695.15.AgingPeriods(Optional) 706.PO,PurchaseOrderSetup 716.1.SystemProfileOption(Required) 716.2.NeededInventorySetups(Required) 726.3.JobFlexfieldValueSets(Required) 726.4.JobFlexfieldStructure(Required) 726.5.JobFlexfieldSegmentValues(Required) 736.6.PositionFlexfieldValueSets(Required) 736.7.PositionFlexfieldStructure(Required) 746.8.PositionFlexfieldSegmentValues(Required) 746.9.PeopleGroupFlexfieldValueSets(Required) 746.10.PeopleGroupFlexfieldStructure(Required) 756.11.PeopleGroupFlexfieldSegmentValues(Required) 756.12.Jobs(Required) 756.13.Position(Required) 766.14.Employees(Required) 776.15.PositionHierarchy(Required) 796.16.FillEmployeeHierarchy(Required) 816.17.ApprovalGroups(Required) 816.18.ApprovalAssignments(Required) 826.19.LookupCodes(Required) 836.20.PurchasingOptions(Required) 856.21.DocumentTypes(Required) 86Buyers(Required) 876.23.Suppliers(Required) 88LineTypesOptional 896.25.OpenPurchasingPeriods(Required) 896.26.ConcurrentProgram:PurchasingDatabaseAdministration(Optional).907.AR,AccountReceivables 917.1.AccountGenerator(Optional) 917.2.DescriptiveFlexfields(Optional) 917.3.SystemProfileOption(Required) 927.4.TerritoryFlexfieldValueSets(Optional) 937.5.TerritoryFlexfieldStructure(Optional) 937.6.TerritoryFlexfieldSegmentValues(Optional) 947.7.Territories(Optional) 947.8.SalesTaxLocationFlexfieldStructure(Optional) 957.9.AutoCashRuleSets(Optional) 957.10.LookupCodes(Optional) 967.11.DemandClasses(Optional) 967.12.AutoInvoiceLineOrderingRules(Optional) 967.13.AutoInvoiceGroupingRules(Optional) 977.14.ApplicationRuleSets(RequiredWithDefaultValue) 987.15.SystemOptions(Required) 997.16.CountriesandTerritories(Optional) 1017.17.PaymentTerms(RequiredwithDefault) 1017.18.AccountingRules(Required) 1027.19.AutoAccounting(Required) 1037.20.TransactionTypes(Required) 1047.21.TransactionSources(Required) 1057.22.Collectors(Required) 107FIN/DIS/MFG应用模块DocumentControlvFileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,20067.23.ApprovalLimits(Optional) 1077.24.DistributionSets(Optional) 1087.25.ReceivableActivities(Required) 1097.26.Banks(Required) 1107.27.ReceiptClasses(Required) 1107.28.ReceiptSources(Required) 1117.29.AgingBuckets(Optional) 1127.30.StatementCycles(Optional) 1137.31.StandardMessages/DunningLetters/DunningLetterSets(Optional)1147.32.Salespersons(Required) 1147.33.CustomerProfileClasses(Required) 1157.34.Customers(Required) 1167.35.Remit-toAddresses(Required) 1187.36.Lockboxes/TransmissionFormats/FormatPrograms(Optional) 1197.37.StandardMemoLines(Optional) 1197.38.CrossCurrencyReceipts(Optional) 1197.39.Taxes(Optional) 1208.OM,OrderManagement 1218.1.DescriptiveFlexfields(Optional) 1218.2.SystemProfileOption(Required) 1218.3.OMSystemParameter(Required) 1228.4.LookupCodes(RequiredwithDefault) 1238.5.Sales 1238.6.Workflow 1238.7.FreightCarriers(Required) 1238.8.PriceList(Required) 1248.9.Modifiers(Required) 1258.10.TransactionTypes(Required) 1268.11.DocumentSequences(Required) 1298.12.SequenceAssignments(Required) 1308.13.PickingRules(Optional) 1308.14.DocumentSets(Optional) 1308.15.ShippingDocumentCategories(Required) 1318.16.ShippingParameter(Required) 1318.17.ShippingExecutionRole(Required) 1328.18.ShippingExecutionGrants(Required) 1338.19.Defaulting(Required) 1348.20.RunReport:BuildAttributeMappingRules(Required) 1369.BOM,BillsofMaterial 1379.1.SystemProfileOption(Required) 1379.2.Parameters(Required) 1389.3.Alternates(Required) 1399.4.Calendars(Required) 1399.5.Resources(Required) 1409.6.SimulationSets(Required) 1419.7.ResourceGroups(Required) 1429.8.DepartmentClasses(Required) 1439.9.Departments(Required) 1439.10.Overhead(Required) 14410.WIP,WorkinProcess 14610.1.SystemProfileOption(Required) 14610.2.Parameters(Required) 14610.3.AccountingClasses(Required) 147FIN/DIS/MFG应用模块DocumentControlviFileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>DecemberOracleERP最佳技术实践11.MRP,ManufacturingResourcePlanning 14911.1.SystemProfileOption(Required) 14911.2.Planners(Required) 15011.3.Parameters(Required) 15011.4.PlanningManager(Required) 15111.5.DemandClass(Optional) 15111.6.ForecastSets(Optional) 15211.7.MDSNames(Required) 15311.8.MPSNames&Options(Required) 15311.9.MRPNames&Options(Required) 15412.CST,CostManagement 15612.1.SystemProfileOption(Required) 15612.2.Function/MenuExclusion(Optional) 15612.3.MaterialSubelement(Optional) 15712.4.OverheadSubelement(Optional) 15712.5.OrganizationCostGroups(Required) 15812.6.OrgCostGroup/CostTypeAssociation(Required) 15912.7.InterfaceManagers(Required) 15913.OpenandClosedIssuesforthisDeliverable 161OpenIssues 161ClosedIssues 161FIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyDocumentControlvii1.定义客户化应用建议每个实施项目都建立一个客户化应用，这个几分钟就可以做完的事，却可以受益无穷，说不定哪天就派上用场。所有客户化定义(Form/Function/Menu/RequestGroup/Responsibility/Execute/Program)都放在这个应用下，不要修改标准的东做客户化工作的时候要遵循基本的命名规范，这里我们假定客户化应为SCF，这样每个客户化的地方都要遵循一个最简单的规则，即名称前缀为SCF_。adsplice动完成。具体参考Arone的handappins.sh。1.1.服务器端设置UNIX下，安装EBS会创建两个操作系统用户，一个是应用用户APPLMGR，一个是ORAMGR。不同环境的具体名字可能不同，如applprod和oraprod。Windows下，则一般用同一个操作系统用户。1.1.1.文件系统(FileSystem)文件系统(FileSystem)以Applmgr登录操作系统cd$APPL_TOP(Windows的变量格式为%APPL_TOP%)mkdirscfcdscfmkdir1.0.0cd1.0.0mkdirforms……cf1.0.0adminimportsqlbinformsUSiblogmesgpatchreportsUSresource--放类型为SQL*Plus的Executable的脚本源文件--放类型为SQLLoader的Executable的控制文件--放编译过的fmx文件rpt，注意扩展名是小写OracleERP最佳技术实践1.1.2.注册环境变量注册环境变量DocRef:<DocumentReferenceNumber>December12,2006以Applmgr登录操作系统cd$APPL_TOPviPROD.env--名字不一定是PROD，但差不多，下同SCF_TOP="/app/d01/oracle/prodappl/scf/1.0.0"后面，路径视具体情况而定ExportSCF_TOP(Windows下，加入setSCF_TOP=E:\oracle\prodappl\scf\1.0.0即可)保存，请管理员重启应用，条件允许的话自己来cd$APPLCSF/scripts/PROD./adstpall.shapps/apps./adstrtal.shapps/appsheConcurrent注意：上面的步骤最好在$APPL_TOP/admin/PROD_<Host_Name>.xml里面加，然后运行adautocfg。Windows平台需要检查注册表是否自动添加了客户化TOP。1.2.数据库端设置1.2.1.创建表空间(Tablespace)创建表空间(Tablespace)以System用户连接数据库createtablespacescfdatafile'/appdata/data/proddata/scf_data01.dbf'size20Mreuseautoextendonnext10M;注意：11.5.10之后，数据统一放在表空间APPS_TS_TX_DATA、索引统一放在APPS_TS_TX_IDX。1.2.2.创建数据库用户(User)创建数据库用户(User)createuserscfidentifiedbyscfdefaulttablespacescftemporarytablespacetemp;FIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-Forinternaluseonly定义客户化应用2of168FIN/DIS/MFG应用模块FileFIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践1.2.3.授权DocRef:<DocumentReferenceNumber>December12,2006grantconnect,resourcetoscf;grantselectanytabletoscf;grantselectanysequencetoscf;1.2.4.创建Package从APPS下取得，编译在scf下APPS_DDL和APPS_ARRAY_DDL1.3.应用设置1.3.1.注册客户化应用(RegisterApplication)注册客户化应用(RegisterApplication)N:Application/RegisterApplicationShortNameBasepathDescriptionSCFCustomizedSystemSCFSCF_TOPSCFCustomizedSystemN:Security/Oracle/RegisterDatabaseUserNamePasswordPrivilegeInstallGroupDescriptionSCFSCFEnabled1SCFCustomizedSystemFIN/DIS/MFG应用模块FileFIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyOracleERP最佳技术实践DocRef:<DocumentReferenceNumber>DecemberOracleERP最佳技术实践1.3.3.AddApplicationToStandardDataGroup数据组的功能是提供Application和Database的连接用户，即使用某个应用的时候，该ReportingCurrencies用上面注册的OracleUser。N:Security/Oracle/Datagroup/QueryStandardDataGroupApplicationOracleIDDescriptionSCFCustomizedSystemAPPSSCFCustomizedSystem的桥梁。N:Security/Responsibility/RequestGroupApplicationSCFCustomizedProgramSCFCustomizedSystemTypeNameApplicationApplicationApplicationObjectLibraryApplicationObjectLibraryApplicationGeneralLedgerGeneralLedgerApplicationAssetsAssetsApplicationPayablesPayablesApplicationPurchasingPurchasingOracleERP最佳技术实践PromptSubmenuSeqDocRef:<DocumentReferenceNumber>DecemberOracleERP最佳技术实践PromptSubmenuSeqGroupApplicationApplication Receivables ReceivablesApplicationInventoryInventoryApplicationOrderManagementOrderManagementApplicationBillsofMaterialBillsofMaterialApplicationWorkinProcessWorkinProcessApplicationCostManagementCostManagementApplicationHumanResourcesHumanResourcesApplicationAlertAlertApplicationAdvancedPricingAdvancedPricingApplicationManufacturingManufacturingApplicationXMLPublisherXMLPublisherApplicationXMLGatewayXMLGatewayApplicationWebApplicationsDesktopIntegratorWebApplicationsDesktopIntegratorApplicationCRMFoundationCRMFoundationApplicationMasterScheduling/MRPMasterScheduling/MRP为了测试方便，不妨把常用模块的并发程序以Application为单位都加进来，这样就不tomizedMenuN:Application/MenuMenuUserMenuNameSCF_SUPER_USERSCFCustomizedSystemSuperUserFIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-Forinternaluseonly定义客户化应用5of168OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,OracleERP最佳技术实践MenuUserMenuName10 GeneralLedgerSuperUser GL_SUPERUSERPayablesManagerAP_NAVIGATE_GUI120ReceivablesManagerAR_NAVIGATE_GUIFixedAssetsManagerFA_MAINCostManagementCST_NAVIGATEInventoryINV_NAVIGATEPurchasingSuperUserPurchasingSuperUserGUIOrderManagementSuperUserONT_SUPER_USEROraclePricingManagerQP_PRICING_MANAGER100BillsofMaterialBOM_NAVIGATE_GUI110WorkInProcessWIP_NAVIGATE_10G120MaterialPlannerMRP_NAVIGATE4.0130GlobalSuperHRMSManagerGLBSHRMSNavigator140CRMAdministratorCRMAdministratorMainMenu170XMLPublisherAdministratorXDO:TemplateManagerRootMenu180AlertManagerALR_OAM_NAVGUI190ApplicationDeveloperNavigatorMenu-ApplicationDeveloperGUISystemAdministratorNavigatorMenu-SystemAdministratorGUI保存之后系统自动提交请求CompileSecurity编译菜单。N:SYSADMIN/Security/Responsibility/DefineResponsibilityResponsibilityNameApplicatioApplicationResponsibilityResponsibilityKeyFIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-Forinternaluseonly定义客户化应用6of168OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,2006ResponsibilityNameApplicationResponsibilityKeySCFCustomizedSystemSuperUserSCFCustomizedSystemSCF_SUPER_USERDataGroupNameRequestGroupNameStandardSCFCustomizedProgramMenuSCFCustomizedSystemSuperUser为了使Tools菜单上的CloseOtherForm有效，需要加入一个MenuExclusions。TypeNameFactionNavigator:DisableMultiformN:SYSADMIN/Security/User/DefineUserNamePasswordHuajhuaHuajhua(输入两次)ResponsibilitySCFCustomizedSystemSuperUserApplicationDeveloperSystemAdministratorGeneralLedgerSuperUserXMLGatewayXMLPublisherAdministratorFIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-Forinternaluseonly定义客户化应用7of168OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>DecemberOracleERP最佳技术实践FIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-Forinternaluseonly定义客户化应用8of168OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,20062.SystemAdministrator2.1.Profiles这里讲的Profile一般是全局性的，所以如果不特别说明，一般指SystemProfile，并且设置在SiteLevel；和功能模块相关的Profile，将在下面的章节说明。N:SYS/Profile/System都有空格，导致有些人查了半天说没有这个Profile；如果我们无法确切知道要设置的Profile名称，那么可以多加几个统配符，如上面的FND%:%ENABLECAN%。其二，点击Find之后，如果没有查到想要的记录，要点击工具栏上的Find按钮，这样上次输入的查询条件还在，这个是Oracle的基本操作。有些人习惯性的关掉窗口，然fnd_concurrent_debug_infoProfileName说明设置建议FIN/DIS/MFG应用模块FileRef:深入浅出OracleEBS之全模块设置详例.doc(v.DRAFT1A)CompanyConfidential-ForinternaluseonlySystemAdministrator9of168OracleERP最佳技术实践DocRef:<DocumentReferenceNumber>December12,2006ProfileNameFND:EnableCancelQuery当执行一个超长时间的查询时，会出现一个Cancel窗口，允许用户取消。比如我们在SO界面没有输入条件就来个Ctrl+F11，由于SO，半天出不来，又不能取消，只好关掉YesUtilities:Diagnostics控制Help/Diagnostics/Examine是否需要输NoJavaLookandFeel设置界面风格，Oracle就是默认的蓝色调，Generic就是传统Windows风格。acleJavaColorSchemenullInitializationSQLStatement-Custom设置每个人登录EBS的时候需要执行的PL/SQL代码，这个可以用来启动Trace等，都行Beginend;null;ICX:SessionTimeoutApplication用户Session在多少分钟内没有数据库操作(在Form上点来点去不一定有数据库操作)就算超时；这个和Zone.Properties配置文件中的session.timeout(单位是秒)要置在用户层测试环境30，