ITPub博客

Your organization likely has IT standards and policies relating to authentication. For instance, your network login may require a password value longer than 5 characters, or your network account may be locked after three failed login attempts. The E-Business suite finally offers some of these same controls (although not until the later versions of 11i and Release 12). These controls are established within the E-Business Suite by setting system profile values. The following E-Business Su

Goal How to setup Password Security? Solution These profiles should only be set at Site level, but can be set at other levels, such as User or Responsibility. However, when logging in there is no User context, so if a User is prompted to change their password at log in, the profiles are only evaluated at site level. Once logged in and resetting passwords using Preferences->Change Password, or the Security ->User->Define form these other levels will have effect and will

Basics Of Oracle Apps Training Material (Step by Step Learning of Oracle Apps) What happens when you login to Oracle Apps Why is it called apps What is a profile option? What is org_id. Why is it important. Relationship between Applications and Modules Where to find/deploy the code (Forms tier/Middle tier or DB Tier) The testing cycle in Oracle Apps Difference between forms and form functions and menu What is a Concurrent Program What is concurrent Manager What is a Value s

Oracle Workflow Training Lesson 1 Oracle Workflows Training Lesson 2  Oracle Workflows Training Lesson 3  Workflows [Business Events] Training Lesson 4  Date Item Title Author Hits Thursday, 27 March 2008 Troubleshoot Business Event Subscription Processing Anil Passi 10166 Wednesday, 30 January 2008 How to send HTML Based Notification by a mere PL/SQL Call? Anil Passi 15543 Wednesday, 30 January 2008 Open Source in Oracl

Workflow Save as to Database时，报两个错误 Error1: 220: Unable to set NLS_LANGUAGE Error2: 1004: Language is not enabled, please refers to Workflow documentation for steps on enabling a language. 原因： 环境变量NLS_LANG设置不正确，正确应为AMERICAN_AMERICA.AL32UTF8，但之前设置成了‘SIMPLIFIED CHINESE_CHINA.AL32UTF8’， 设置完之后，重启workflow builder，重新拉‘Standard’模板workflow，重新设置workflow，再save as就没问

使用Workflow Builder打开数据库的时候报"Unable to set NLS_LANGUAGE"的错误Error:220: Unable to set NLS_LANGUAGE.210: Oracle Error: ORA-01403: 未找到任何数据.  SQL text: SELECT NLS_LANGUAGE FROM WF_LANGUAGES WHERE :l IN (NLS_LANGUAGE, CODE)解决方法：参考：https://forums.oracle.com/forums/thread.jspa?threadID=842655Set NLS_LANG as an operating system environment variable:   1. Select Start - Control Panel - System   2. Select Environment &nbsp

EBS中部分工作流的应用 下面的SQL可以查当前系统中所有的工作流: SELECT b.NAME, t.display_name, t.description FROM wf_item_types b, wf_item_types_tl t WHERE b.NAME = t.NAME AND t.LANGUAGE = \'US\' ORDER BY 1 Sample Output(Inventory Workflow) NAME DISPLAY_NAME INVADJTO Inventory Adjustment XML Outbound INVCDNTF Consigned Inventory Diagnostics INVDATNT Inventory Date Notification INVFLXWF Inventory Cost of Goods Sold Accoun

Oracle Workflow Server/Client Downloads http://www.oracle.com/technetwork/database/options/index-092347.html Oracle Workflow Server Downloads     Oracle Workflow Server Release 10.1.0.3 for Apple Mac OS X Oracle Workflow Server Release 10.1.0.3 for Linux x86-64 Oracle Workflow Server Release 10.1.0.3 for Linux x86 Oracle Workflow Server Release 10.1.0.3 for z/Linux Oracle Workflow Server Release 10.1.0.3 for Solaris x86 Orac

Oracle EBS的基础架构技术,这个列表基本上这些就是EBS开发所需要的技术 摘自<<深入浅出Oracle_EBS之Workflow实例详解.pdf>>

How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution file name SELECT fcp.concurrent_program_name,fcpt.user_concurrent_program_name,fcp.EXECUTION_METHOD_CODE,flv.meaning FROM FND_CONCURRENT_PROGRAMS fcp,FND_CONCURRENT_PROGRAMS_TL fcpt,fnd_lookup_values flv WHERE fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID AND flv.lookup_type = \'CP_EXECUTION_METHOD_CODE\' AND fcp.EXECUTION_METHOD_CODE = flv.lookup_code AND fcpt.LANGUAGE = \'

How to use script to get all Oracle EBS Form name and corresponding fmb file name SELECT fff.function_name, ff.form_name, ffft.user_function_name, fff.function_id, ff.form_id, fff.application_id FROM fnd_form ff, fnd_form_functions fff, fnd_form_functions_tl ffft WHERE ff.form_id = fff.form_id AND fff.function_id = ffft.function_id AND ffft.language = \'US\' AND fff.application_id = 401 --Inventory Module OR

Flexfields:Validate On Server Flexfield server-side validation is supplied with the base 10.7 install and as part of a 10SC patch for 10.6 releases.This profile option is set to "Yes" to enable server side, PL/SQL flexfields validation for Key Flexfields.This improves performance when using Key Flexfields over a wide area network by reducing the number of network round trips needed to validate the entered segment combinations.With this profile set to \'Y\', the validation request wil

不知道怎么搞得，Oracle EBS主界面上方的‘Favorites’下拉列表消失了，取而代之这个列表跑到了页面下方，很容易就忽略掉了 解决方法： 主界面 -> Preferences ，不知道谁把Accessibility Features设置成Screen Reader Optimized模式了，改回成None，然后返回主界面就能看到Favorites列表了

ICX:Session Timeout - This profile option determines the length of time (in minutes) of inactivity in a user\'s form session before the session is disabled.  Note that disabled does not mean terminated or killed.  The user is provided the opportunity to re-authenticate and re-enable their timed-out session. If the re-authentication is successful, the disabled session is re-enabled and no work is lost. Otherwise, the session is terminated without saving pending work.  This functi

查询所有ICX相关Profile的SQLset pages 100 set line 120 column "Option" format 99999999 column "Profile Name" format A35 column "Profile Value" format A55 spool support_profile_value.txt select a.PROFILE_OPTION_ID "Option" ,a.PROFILE_OPTION_NAME "Profile Name" ,b.PROFILE_OPTION_VALUE "Profile Value" from fnd_profile_options a ,fnd_profile_option_values b where a.PROFILE_OPTION_ID = b.PROFILE_OPTION_

来看看Oralce ERP顾问在国外的价码吧,基本上国外顾问干一个半小时的费用就等于国内顾问干一天的了 Oracle Applications Consulting Prices 包括EBS的patching,11i upgrades以及flex-field的客户化等等 On-Site Oracle Applications Consulting  Rate  Per Diem  Starting at $315 / hour (1999RMB/Hour)  Remote Oracle Applications Consulting  Rate  Per Diem  Star

Accessibility Standard Accessibility - Renders the pages accessible for users using assistive technology, but ensures that pages are formatted correctly for sighted users. Screen Reader Optimized - Optimizes the pages for screen readers. This may degrade the output for sighted users. None - This mode removes markup that is only needed by assistive technology users, such as table summary information, to make the page smaller and faster. The resultant pages may include behaviors that

打开Oracle Apps的主页，报下面的错误 Error Page   You have encountered an unexpected error. Please contact the System Administrator for assistance.   Click here for exception details.   点击Details，看到以下错误堆栈 Exception Details.    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.     at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageError

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)* For transactions stuck in MMTTupdate mtl_material_transactions_tempset process_flag = \'Y\',lock_flag = NULL ,Transaction_mode = 3  ,Error_code = NULL ,Error_explanation = NULLwhere transaction_header_id = &transaction_header_idand error_code is not NULL; *For transactions stuck in MTIupdate mtl_transactions_interfaceset process_flag =  1,lock_flag = NULL ,Tran