【正文】 TX_DATA、索引統(tǒng)一放在APPS_TS_TX_IDX。. 授權(quán)授權(quán)grant connect,resource to scf。grant select any sequence to scf。標(biāo)準(zhǔn)是：Standard Data Group用APPS用戶；Multiple Reporting Currencies用上面注冊(cè)的Oracle User。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為了測(cè)試方便，不妨把常用模塊的并發(fā)程序以Application為單位都加進(jìn)來(lái)，這樣就不需要切換來(lái)切換去。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 Planner130Global 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為了測(cè)試方便，不妨把常用模塊的頂層菜單都掛進(jìn)來(lái)；這樣就不需要切換來(lái)切換去，保存之后系統(tǒng)自動(dòng)提交請(qǐng)求Compile Security編譯菜單。TypeNameFactionNavigator: Disable MultiformCreate UserN: SYSADMIN/Security/User/DefineUser NamePasswordHuajhuaHuajhua（輸入兩次）ResponsibilitySCF Customized System Super UserApplication DeveloperSystem AdministratorGeneral Ledger Super UserXML GatewayXML Publisher Administrator…需要的職責(zé). 附：adsplice實(shí)現(xiàn)步驟：按照指定格式，、APP、APP，放到$APPL_TOP/admin下，運(yùn)行adsplice，按照提示即可完成。%%% Splicer control file format $Header: 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 Application +=======================================================================+ | Copyrght (c) 2001 Oracle Corporation Redwood Shores, CA USA | | All rights reserved. | +=======================================================================+ | FILENAME | | | | $Header: 2006/02/11 00:52:08 Hand China noship $ | | | | NOTES | | All ment lines must begin with a . | | This file is changed with each release. | +=======================================================================+ file format id (should begin with 39。) %%% Singleproduct product data file format LIST OF PRODUCT ABBREVIATIONS and the corresponding application ids. This list lets you forwardreference the abbreviations of shared products. This list should match the official correspondence between id and abbreviation, given for each product in the Product List. hand 100000END_OF_PRODUCT_ABBREVIATIONS 999 START OF PRODUCT LIST (languageindependent information about the products) Hand Extension Application application id, abbreviation, shortname, prefix100000 hand HAND APP multiple product installations for msob, 39。, shared only optional fourth field is stub product. default is NoNo No No No multilingual, has Yes Yes install oracle id, default ORACLE username, default ORACLE password100000 hand HAND concurrent conflict set id logical database id0 minimum version you can upgrade from, for shared and for fullyinstalled shared products。make f product.mk all39。s name in American English You do not need to include records for other languages unless you need to specify the product39。N: SYS/Profile/System 平時(shí)看有些人操作這個(gè)界面很別扭。其二，點(diǎn)擊Find之后，如果沒有查到想要的記錄，要點(diǎn)擊工具欄上的Find按鈕，這樣上次輸入的查詢條件還在，這個(gè)是Oracle的基本操作。一些有用的Profilefnd_concurrent_debug_infoProfile Name說(shuō)明設(shè)置建議FND: Enable Cancel Query當(dāng)執(zhí)行一個(gè)超長(zhǎng)時(shí)間的查詢時(shí)，會(huì)出現(xiàn)一個(gè)Cancel窗口，允許用戶取消。YesFND: NATIVE CLIENT ENCODING客戶端字符集，設(shè)置不當(dāng)報(bào)表導(dǎo)出可能亂碼同DBICX: Client IANA EncodingClient IANA Encoding used for setting up charset in HTTP response同DBUtilities:Diagnostics控制Help/Diagnostics/Examine是否需要輸入APPS密碼，Yes不需要，No需要NoJava Look and Feel設(shè)置界面風(fēng)格，Oracle就是默認(rèn)的藍(lán)色調(diào)，Generic就是傳統(tǒng)Windows風(fēng)格。 end。如果是User那么只有運(yùn)行該報(bào)表的用戶可以查看Output，不管他切換到哪個(gè)職責(zé)。UserSelf Service Personal Home Page mode登錄之后的主頁(yè)模式，需重啟ApacheFramework only：職責(zé)+職責(zé)菜單Personal Home Page：點(diǎn)職責(zé)直接進(jìn)入P