*/筱信息技术最佳实践ORACLE核心应用技术E-BusinessSuite全模块设置详例Author:黄建华CreationDate:createdate\@"MMMMd,yyyy"April12,2005LastUpdated:savedate\@"MMMMd,yyyy"February19,2009DocumentRef:
Version:DRAFT1AApprovals:autotext"PICOracleLogo"\*Mergeformatautotext"PICOracleLogo"\*Mergeformatautotext"PICOracleLogo"\*MergeformatCopyNumber_____DocumentControlChangeRecordSECTIONPAGES\*MERGEFORMAT7DateAuthorVersionChangeReferenceCREATEDATE\@"d-MMM-yy"12-Apr-05Jianhua.HuangDraft1aNoPreviousDocumentReviewersNamePositionDistributionCopyNo.NameLocationLibraryMasterProjectLibraryProjectManagerNoteToHolders:Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.ContentsTOC\o"2-3"DocumentControlPAGEREF_Toc206425558\hii1.定义客户化应用PAGEREF_Toc206425559\h21.1.服务器端设置PAGEREF_Toc206425560\h21.1.1.文件系统（FileSystem）PAGEREF_Toc206425561\h21.1.2.注册环境变量PAGEREF_Toc206425562\h31.2.数据库端设置PAGEREF_Toc206425563\h31.2.1.创建表空间（Tablespace）PAGEREF_Toc206425564\h31.2.2.创建数据库用户（User）PAGEREF_Toc206425565\h31.2.3.授权PAGEREF_Toc206425566\h41.2.4.创建PackagePAGEREF_Toc206425567\h41.3.应用设置PAGEREF_Toc206425568\h41.3.1.注册客户化应用（RegisterApplication）PAGEREF_Toc206425569\h41.3.2.RegisterOracleUserPAGEREF_Toc206425570\h41.3.3.AddApplicationToStandardDataGroupPAGEREF_Toc206425571\h51.3.4.CreateRequestGroupForCustomizedApplicationPAGEREF_Toc206425572\h51.3.5.CreateCustomizedMenuPAGEREF_Toc206425573\h61.3.6.CreateCustomizedResponsibilityPAGEREF_Toc206425574\h71.3.7.附：adsplicePAGEREF_Toc206425575\h92.SystemAdministratorPAGEREF_Toc206425576\h132.1.ProfilesPAGEREF_Toc206425577\h132.2.未完待续PAGEREF_Toc206425578\h143.GL,GeneralLedgerSetupPAGEREF_Toc206425579\h153.1.组织结构规划PAGEREF_Toc206425580\h153.2.账户结构（COA，ChartOfAccount）规划PAGEREF_Toc206425581\h153.3.AccountingFlexfieldValueSets(Required)PAGEREF_Toc206425582\h153.4.AccountingFlexfieldStructure(Required)PAGEREF_Toc206425583\h183.5.AccountingFlexfieldRollupGroups(Optional)PAGEREF_Toc206425584\h203.6.AccountingFlexfieldSegmentValues(Required)PAGEREF_Toc206425585\h203.7.AccountingFlexfieldSecurityRules(Dependent)PAGEREF_Toc206425586\h223.8.AccountingFlexfieldCross-ValidationRules(Optional)PAGEREF_Toc206425587\h233.9.NewPeriodTypes(Dependent)PAGEREF_Toc206425588\h253.10.AccountingCalendar(Required)PAGEREF_Toc206425589\h253.11.EnableCurrency(Required)PAGEREF_Toc206425590\h273.12.SetOfBooks(Required)PAGEREF_Toc206425591\h273.13.SystemProfileOption(Required)PAGEREF_Toc206425592\h283.14.Locations(Required)PAGEREF_Toc206425593\h283.15.BusinessGroup(Optional)PAGEREF_Toc206425594\h293.16.OrganizationandOrganizationRelationships(Required)PAGEREF_Toc206425595\h303.17.Responsibility(Required)PAGEREF_Toc206425596\h313.18.SystemProfileOption(Required)PAGEREF_Toc206425597\h313.19.ConverttoMultipleOrganizationArchitecture(Required)PAGEREF_Toc206425598\h323.20.InventoryOrganizationSecurity(Optional)PAGEREF_Toc206425599\h333.21.CurrencyConversionRateType(Optional)PAGEREF_Toc206425600\h333.22.HistoricalRates(Optional)PAGEREF_Toc206425601\h343.23.AdditionalJournalSourcesandCategories(Optional)PAGEREF_Toc206425602\h343.24.SummaryAccounts(Optional)PAGEREF_Toc206425603\h353.25.AutoReverse(Optional)PAGEREF_Toc206425604\h363.26.AutoPost(Optional)PAGEREF_Toc206425605\h363.27.EncumbranceTypes(Optional)PAGEREF_Toc206425606\h363.28.ConcurrentProgramControls(Optional)PAGEREF_Toc206425607\h373.29.RuntheMultiOrgSetupValidationReport(Required)PAGEREF_Toc206425608\h373.30.SetTopReportingLevelProfileOption(optional)PAGEREF_Toc206425609\h373.31.OpenAccountingPeriod(Required)PAGEREF_Toc206425610\h384.INV,InventorySetupPAGEREF_Toc206425611\h394.1.SystemItemFlexfieldStructure(Required)PAGEREF_Toc206425612\h394.2.ItemCatalogsFlexfieldStructure(Required)PAGEREF_Toc206425613\h394.3.StockLocatorsFlexfieldStructure(Optional)PAGEREF_Toc206425614\h404.4.AccountAliasesFlexfieldStructure(Optional)PAGEREF_Toc206425615\h404.5.SalesOrdersFlexfieldStructure(Required)PAGEREF_Toc206425616\h404.6.ItemCategoriesFlexfieldValueSets(Required)PAGEREF_Toc206425617\h414.7.ItemCategoriesFlexfieldStructure(Required)PAGEREF_Toc206425618\h424.8.ItemCategoriesFlexfieldSegmentValues(Required)PAGEREF_Toc206425619\h424.9.Locations(Required)PAGEREF_Toc206425620\h434.10.MFGWorkdaysCalendar(Required)PAGEREF_Toc206425621\h444.11.AttributeControls(Required)PAGEREF_Toc206425622\h444.12.InventoryOrganization(Required)PAGEREF_Toc206425623\h454.13.InventoryOrganizationParameter(Required)PAGEREF_Toc206425624\h464.14.ReceivingParameter(Required)PAGEREF_Toc206425625\h484.15.UnitOfMeasure(Required)PAGEREF_Toc206425626\h494.16.ItemCategories(Required)PAGEREF_Toc206425627\h504.17.CategorySet(Required)PAGEREF_Toc206425628\h514.18.DefaultCategorySets(RequiredWithDefault)PAGEREF_Toc206425629\h534.19.SubInventory(Required)PAGEREF_Toc206425630\h534.20.Locator(Optional)PAGEREF_Toc206425631\h544.21.AccountAliases(Optional)PAGEREF_Toc206425632\h554.22.TransactionSources,Types(Optional)PAGEREF_Toc206425633\h564.23.TransactionReasons(Optional)PAGEREF_Toc206425634\h574.24.OrganizationAccess(Optional)PAGEREF_Toc206425635\h584.25.ItemTypeQuickCodes(Optional)PAGEREF_Toc206425636\h584.26.ItemTemplates(Optional)PAGEREF_Toc206425637\h594.27.SystemProfileOption(Required)PAGEREF_Toc206425638\h604.28.OpenInventoryAccountingPeriod(Required)PAGEREF_Toc206425639\h605.AP,AccountsPayablesSetupPAGEREF_Toc206425640\h625.1.ChooseSOB(Required)PAGEREF_Toc206425641\h625.2.PaymentTerms(Required)PAGEREF_Toc206425642\h625.3.InvoiceTolerances(Optional)PAGEREF_Toc206425643\h635.4.InvoiceHoldandReleaseName(RequiredwithDefault)PAGEREF_Toc206425644\h645.5.LookupCodes(RequiredwithDefault)PAGEREF_Toc206425645\h655.6.ExpenseReportTemplates(Optional)PAGEREF_Toc206425646\h655.7.MasterInventoryOrganization(Required)PAGEREF_Toc206425647\h665.8.FinancialsOptions(Required)PAGEREF_Toc206425648\h665.9.PayableOptions(Required)PAGEREF_Toc206425649\h675.10.TaxCodes(Dependent)PAGEREF_Toc206425650\h695.11.PaymentPrograms(Optional)PAGEREF_Toc206425651\h705.12.PaymentFormats(Optional)PAGEREF_Toc206425652\h705.13.BankandBankAccounts(Required)PAGEREF_Toc206425653\h715.14.OpenPayablesAccountingPeriod(Required)PAGEREF_Toc206425654\h735.15.AgingPeriods(Optional)PAGEREF_Toc206425655\h746.PO,PurchaseOrderSetupPAGEREF_Toc206425656\h756.1.SystemProfileOption(Required)PAGEREF_Toc206425657\h756.2.NeededInventorySetups(Required)PAGEREF_Toc206425658\h766.3.JobFlexfieldValueSets(Required)PAGEREF_Toc206425659\h766.4.JobFlexfieldStructure(Required)PAGEREF_Toc206425660\h766.5.JobFlexfieldSegmentValues(Required)PAGEREF_Toc206425661\h776.6.PositionFlexfieldValueSets(Required)PAGEREF_Toc206425662\h776.7.PositionFlexfieldStructure(Required)PAGEREF_Toc206425663\h786.8.PositionFlexfieldSegmentValues(Required)PAGEREF_Toc206425664\h786.9.PeopleGroupFlexfieldValueSets(Required)PAGEREF_Toc206425665\h786.10.PeopleGroupFlexfieldStructure(Required)PAGEREF_Toc206425666\h796.11.PeopleGroupFlexfieldSegmentValues(Required)PAGEREF_Toc206425667\h796.12.Jobs(Required)PAGEREF_Toc206425668\h796.13.Position(Required)PAGEREF_Toc206425669\h806.14.Employees(Required)PAGEREF_Toc206425670\h816.15.PositionHierarchy(Required)PAGEREF_Toc206425671\h836.16.FillEmployeeHierarchy(Required)PAGEREF_Toc206425672\h856.17.ApprovalGroups(Required)PAGEREF_Toc206425673\h856.18.ApprovalAssignments(Required)PAGEREF_Toc206425674\h866.19.LookupCodes(Required)PAGEREF_Toc206425675\h876.20.PurchasingOptions(Required)PAGEREF_Toc206425676\h896.21.DocumentTypes(Required)PAGEREF_Toc206425677\h906.22.Buyers(Required)PAGEREF_Toc206425678\h916.23.Suppliers(Required)PAGEREF_Toc206425679\h926.24.LineTypes(Optional)PAGEREF_Toc206425680\h936.25.OpenPurchasingPeriods(Required)PAGEREF_Toc206425681\h936.26.ConcurrentProgram:PurchasingDatabaseAdministration(Optional)PAGEREF_Toc206425682\h947.AR,AccountReceivablesPAGEREF_Toc206425683\h957.1.AccountGenerator(Optional)PAGEREF_Toc206425684\h957.2.DescriptiveFlexfields(Optional)PAGEREF_Toc206425685\h957.3.SystemProfileOption(Required)PAGEREF_Toc206425686\h967.4.TerritoryFlexfieldValueSets(Optional)PAGEREF_Toc206425687\h977.5.TerritoryFlexfieldStructure(Optional)PAGEREF_Toc206425688\h977.6.TerritoryFlexfieldSegmentValues(Optional)PAGEREF_Toc206425689\h987.7.Territories(Optional)PAGEREF_Toc206425690\h987.8.SalesTaxLocationFlexfieldStructure(Optional)PAGEREF_Toc206425691\h997.9.AutoCashRuleSets(Optional)PAGEREF_Toc206425692\h997.10.LookupCodes(Optional)PAGEREF_Toc206425693\h1007.11.DemandClasses(Optional)PAGEREF_Toc206425694\h1007.12.AutoInvoiceLineOrderingRules(Optional)PAGEREF_Toc206425695\h1007.13.AutoInvoiceGroupingRules(Optional)PAGEREF_Toc206425696\h1017.14.ApplicationRuleSets(RequiredWithDefaultValue)PAGEREF_Toc206425697\h1027.15.SystemOptions(Required)PAGEREF_Toc206425698\h1037.16.CountriesandTerritories(Optional)PAGEREF_Toc206425699\h1057.17.PaymentTerms(RequiredwithDefault)PAGEREF_Toc206425700\h1057.18.AccountingRules(Required)PAGEREF_Toc206425701\h1067.19.AutoAccounting(Required)PAGEREF_Toc206425702\h1077.20.TransactionTypes(Required)PAGEREF_Toc206425703\h1087.21.TransactionSources(Required)PAGEREF_Toc206425704\h1097.22.Collectors(Required)PAGEREF_Toc206425705\h1117.23.ApprovalLimits(Optional)PAGEREF_Toc206425706\h1117.24.DistributionSets(Optional)PAGEREF_Toc206425707\h1127.25.ReceivableActivities(Required)PAGEREF_Toc206425708\h1137.26.Banks(Required)PAGEREF_Toc206425709\h1147.27.ReceiptClasses(Required)PAGEREF_Toc206425710\h1147.28.ReceiptSources(Required)PAGEREF_Toc206425711\h1157.29.AgingBuckets(Optional)PAGEREF_Toc206425712\h1167.30.StatementCycles(Optional)PAGEREF_Toc206425713\h1177.31.StandardMessages/DunningLetters/DunningLetterSets(Optional)PAGEREF_Toc206425714\h1187.32.Salespersons(Required)PAGEREF_Toc206425715\h1187.33.CustomerProfileClasses(Required)PAGEREF_Toc206425716\h1197.34.Customers(Required)PAGEREF_Toc206425717\h1207.35.Remit-toAddresses(Required)PAGEREF_Toc206425718\h1227.36.Lockboxes/TransmissionFormats/FormatPrograms(Optional)PAGEREF_Toc206425719\h1237.37.StandardMemoLines(Optional)PAGEREF_Toc206425720\h1237.38.CrossCurrencyReceipts(Optional)PAGEREF_Toc206425721\h1237.39.Taxes(Optional)PAGEREF_Toc206425722\h1248.OM,OrderManagementPAGEREF_Toc206425723\h1258.1.DescriptiveFlexfields(Optional)PAGEREF_Toc206425724\h1258.2.SystemProfileOption(Required)PAGEREF_Toc206425725\h1258.2.1.OMSystemParameter(Required)PAGEREF_Toc206425726\h1268.3.LookupCodes(RequiredwithDefault)PAGEREF_Toc206425727\h1278.4.SalesPAGEREF_Toc206425728\h1278.5.WorkflowPAGEREF_Toc206425729\h1278.6.FreightCarriers(Required)PAGEREF_Toc206425730\h1278.7.PriceList(Required)PAGEREF_Toc206425731\h1288.8.Modifiers(Required)PAGEREF_Toc206425732\h1298.9.TransactionTypes(Required)PAGEREF_Toc206425733\h1308.10.DocumentSequences(Required)PAGEREF_Toc206425734\h1338.11.SequenceAssignments(Required)PAGEREF_Toc206425735\h1348.12.PickingRules(Optional)PAGEREF_Toc206425736\h1348.13.DocumentSets(Optional)PAGEREF_Toc206425737\h1348.14.ShippingDocumentCategories(Required)PAGEREF_Toc206425738\h1358.15.ShippingParameter(Required)PAGEREF_Toc206425739\h1358.16.ShippingExecutionRole(Required)PAGEREF_Toc206425740\h1368.17.ShippingExecutionGrants(Required)PAGEREF_Toc206425741\h1378.18.Defaulting(Required)PAGEREF_Toc206425742\h1388.19.RunReport:BuildAttributeMappingRules(Required)PAGEREF_Toc206425743\h1409.BOM,BillsofMaterialPAGEREF_Toc206425744\h1419.1.SystemProfileOption(Required)PAGEREF_Toc206425745\h1419.2.Parameters(Required)PAGEREF_Toc206425746\h1429.3.Alternates(Required)PAGEREF_Toc206425747\h1439.4.Calendars(Required)PAGEREF_Toc206425748\h1439.5.Resources(Required)PAGEREF_Toc206425749\h1449.6.SimulationSets(Required)PAGEREF_Toc206425750\h1459.7.ResourceGroups(Required)PAGEREF_Toc206425751\h1469.8.DepartmentClasses(Required)PAGEREF_Toc206425752\h1479.9.Departments(Required)PAGEREF_Toc206425753\h1479.10.Overhead(Required)PAGEREF_Toc206425754\h14810.WIP,WorkinProcessPAGEREF_Toc206425755\h15010.1.SystemProfileOption(Required)PAGEREF_Toc206425756\h15010.2.Parameters(Required)PAGEREF_Toc206425757\h15010.3.AccountingClasses(Required)PAGEREF_Toc206425758\h15111.MRP,ManufacturingResourcePlanningPAGEREF_Toc206425759\h15311.1.SystemProfileOption(Required)PAGEREF_Toc206425760\h15311.2.Planners(Required)PAGEREF_Toc206425761\h15411.3.Parameters(Required)PAGEREF_Toc206425762\h15411.4.PlanningManager(Required)PAGEREF_Toc206425763\h15511.5.DemandClass(Optional)PAGEREF_Toc206425764\h15511.6.ForecastSets(Optional)PAGEREF_Toc206425765\h15611.7.MDSNames(Required)PAGEREF_Toc206425766\h15711.8.MPSNames&Options(Required)PAGEREF_Toc206425767\h15711.9.MRPNames&Options(Required)PAGEREF_Toc206425768\h15812.CST,CostManagementPAGEREF_Toc206425769\h16012.1.SystemProfileOption(Required)PAGEREF_Toc206425770\h16012.2.Function/MenuExclusion(Optional)PAGEREF_Toc206425771\h16012.3.MaterialSubelement(Optional)PAGEREF_Toc206425772\h16112.4.OverheadSubelement(Optional)PAGEREF_Toc206425773\h16112.5.OrganizationCostGroups(Required)PAGEREF_Toc206425774\h16212.6.OrgCostGroup/CostTypeAssociation(Required)PAGEREF_Toc206425775\h16312.7.InterfaceManagers(Required)PAGEREF_Toc206425776\h16313.OpenandClosedIssuesforthisDeliverablePAGEREF_Toc206425777\h165OpenIssuesPAGEREF_Toc206425778\h165ClosedIssuesPAGEREF_Toc206425779\h165*PAGE10/筱定义客户化应用建议每个实施项目都建立一个客户化应用，这个几分钟就可以做完的事，却可以受益无穷，说不定哪天就派上用场。所有客户化定义（Form/Function/Menu/RequestGroup/Responsibility/Execute/Program）都放在这个应用下，不要修改
标准
excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载
的东西，要改也要新拷贝一份来改。做客户化工作的时候要遵循基本的命名
规范
编程规范下载gsp规范下载钢格栅规范下载警徽规范下载建设厅规范下载
，这里我们假定客户化应为SCF，这样每个客户化的地方都要遵循一个最简单的
规则
编码规则下载淘宝规则下载天猫规则下载麻将竞赛规则pdf麻将竞赛规则pdf
，即名称前缀为SCF_。客户化应用，也可以用系统命令adsplice，下面的很多步骤都可以自动完成。服务器端设置UNIX下，安装EBS会创建两个操作系统用户，一个是应用用户APPLMGR，一个是ORAMGR。不同环境的具体名字可能不同，如applprod和oraprod。Windows下，则一般用同一个操作系统用户。文件系统（FileSystem）文件系统（FileSystem）参照Oracle标准结构。以Applmgr登录操作系统cd$APPL_TOP（Windows的变量格式为%APPL_TOP%）mkdirscfcdscfmkdircdmkdirforms……最后建成的目录结构为：scfadminimportsql--放类型为SQL*Plus的Executable的脚本源文件bin--放类型为SQLLoader的Executable的控制文件formsUS--放编译过的fmx文件liblogmesgpatchreportsUS--放rpt文件，注意扩展名是小写resource注册环境变量注册环境变量以Applmgr登录操作系统cd$APPL_TOPviPROD_huajhua.envSCF_TOP="/app/d01/oracle/prodappl/scf/1.0.0"--加在文件最后面，路径视具体情况而定ExportSCF_TOP（Windows下，加入即可）保存，请管理员重启应用，条件允许的话自己来cd$APPLCSF/scripts/PROD--这下面还有启停Apache、Concurrent--Manager、Form、Report、Metrix的脚本./adstpall.shapps/apps./adstrtal.shapps/apps注意：上面的步骤最好在_.xml（具体路径和文件名用echo$CONTEXT_FILE）里面加，然后运行adautocfg。Windows平台需要检查注册表是否自动添加了客户化TOP。数据库端设置创建表空间（Tablespace）创建表空间（Tablespace）以System用户连接数据库createtablespacescfdatafile'/appdata/data/proddata/scf_data01.dbf'size20Mreuseautoextendonnext10M;注意：11.5.10之后，数据统一放在表空间APPS_TS_TX_DATA、索引统一放在APPS_TS_TX_IDX。创建数据库用户（User）创建数据库用户（User）createuserscfidentifiedbyscfdefaulttablespacescftemporarytablespacetemp;授权授权grantconnect,resourcetoscf;grantselectanytabletoscf;grantselectanysequencetoscf;创建Package从APPS下取得，编译在scf下APPS_DDL和APPS_ARRAY_DDL应用设置注册客户化应用（RegisterApplication）注册客户化应用（RegisterApplication）N:Application/RegisterApplicationShortNameBasepathDescriptionSCFCustomizedSystemSCFSCF_TOPSCFCustomizedSystemRegisterOracleUserRegisterOracleUserN:Security/Oracle/RegisterDatabaseUserNamePasswordPrivilegeInstallGroupDescriptionSCFSCFEnabled1SCFCustomizedSystemAddApplicationToStandardDataGroupAddApplicationToStandardDataGroup数据组的功能是提供Application和Database的连接用户，即使用某个应用的时候，该使用哪个用户与数据库连接。标准是：StandardDataGroup用APPS用户；MultipleReportingCurrencies用上面注册的OracleUser。N:Security/Oracle/Datagroup/QueryStandardDataGroupApplicationOracleIDDescriptionSCFCustomizedSystemAPPSSCFCustomizedSystemCreateRequestGroupForCustomizedApplicationCreateRequestGroupForCustomizedApplication请求组可理解为并发程序的集合，是并发程序和
职责
岗位职责下载项目部各岗位职责下载项目部各岗位职责下载建筑公司岗位职责下载社工督导职责.docx
的桥梁。N:Security/Responsibility/RequestGroupApplicationSCFCustomizedProgramSCFCustomizedSystemTypeNameApplicationApplicationApplicationObjectLibraryApplicationObjectLibraryApplicationGeneralLedgerGeneralLedgerApplicationAssetsAssetsApplicationPayablesPayablesApplicationPurchasingPurchasingApplicationReceivablesReceivablesApplicationInventoryInventoryApplicationOrderManagementOrderManagementApplicationBillsofMaterialBillsofMaterialApplicationWorkinProcessWorkinProcessApplicationCostManagementCostManagementApplicationHumanResourcesHumanResourcesApplicationAlertAlertApplicationAdvancedPricingAdvancedPricingApplicationManufacturingManufacturingApplicationXMLPublisherXMLPublisherApplicationXMLGatewayXMLGatewayApplicationWebApplicationsDesktopIntegratorWebApplicationsDesktopIntegratorApplicationCRMFoundationCRMFoundationApplicationMasterScheduling/MRPMasterScheduling/MRP为了测试方便，不妨把常用模块的并发程序以Application为单位都加进来，这样就不需要切换来切换去。CreateCustomizedMenuCreateCustomizedMenu定义客户化
菜单
餐厅复工更换新菜单通知电子菜单怎么做可以自己制作的电子菜单如何制作电子菜单电子菜单制作
。N:Application/MenuMenuUserMenuNameSCF_SUPER_USERSCFCustomizedSystemSuperUserSeqPromptSubmenu10GeneralLedgerSuperUserGL_SUPERUSER20PayablesManagerAP_NAVIGATE_GUI1230ReceivablesManagerAR_NAVIGATE_GUI40FixedAssetsManagerFA_MAIN50CostManagementCST_NAVIGATE60InventoryINV_NAVIGATE70PurchasingSuperUserPurchasingSuperUserGUI80OrderManagementSuperUserONT_SUPER_USER90OraclePricingManagerQP_PRICING_MANAGER100BillsofMaterialBOM_NAVIGATE_GUI110WorkInProcessWIP_NAVIGATE_10G120MaterialPlannerMRP_NAVIGATE4.0130GlobalSuperHRMSManagerGLBSHRMSNavigator140CRMAdministratorCRMAdministratorMainMenu170XMLPublisherAdministratorXDO:TemplateManagerRootMenu180AlertManagerALR_OAM_NAVGUI190ApplicationDeveloperNavigatorMenu-ApplicationDeveloperGUI200SystemAdministratorNavigatorMenu-SystemAdministratorGUI为了测试方便，不妨把常用模块的顶层菜单都挂进来；这样就不需要切换来切换去，保存之后系统自动提交请求CompileSecurity编译菜单。CreateCustomizedResponsibilityCreateCustomizedResponsibilityN:SYSADMIN/Security/Responsibility/DefineResponsibilityNameApplicationResponsibilityKeySCFCustomizedSystemSuperUserSCFCustomizedSystemSCF_SUPER_USERDataGroupNameRequestGroupNameStandardSCFCustomizedProgramMenuSCFCustomizedSystemSuperUser为了使Tools菜单上的CloseOtherForm有效，需要加入一个MenuExclusions。TypeNameFactionNavigator:DisableMultiformCreateUserN:SYSADMIN/Security/User/DefineUserNamePasswordHuajhuaHuajhua（输入两次）ResponsibilitySCFCustomizedSystemSuperUserApplicationDeveloperSystemAdministratorGeneralLedgerSuperUserXMLGatewayXMLPublisherAdministrator…需要的职责附：adsplice实现步骤：按照指定格式，准备newprods.txt、prod.txt、terr.txt三个文件，放到$APPL_TOP/admin下，运行adsplice，按照提示即可完成。唯一要注意的是目录结构还是要自己手工创建、prod.txt中的应用ID号最好是用fnd_application_s.nextval获得的。newprods.txt%%%Splicercontrolfileformat11.5.A#$Header:newprods.txt115.02006/06/1001:46:19applrtnoship$#SectionforHandExtensionApplicationproduct=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#endofHandExtensionApplicationhandprod.txt#+=======================================================================+#|Copyrght(c)2001OracleCorporationRedwoodShores,CAUSA|#|Allrightsreserved.|#+=======================================================================+#|FILENAME|#|handprod.txt|#|$Header:handprod.txt115.12006/02/1100:52:08HandChinanoship$|#||#|NOTES|#|Allcommentlinesmustbeginwitha#.|#|Thisfileischangedwitheachrelease.|#+========
浙公网安备 33021202002483