ITPub博客

zz:http://www.oracleappshub.com/api/oracle-api-availability-profile/ In oracle user Profile functionality is provided in the FND_PROFILE package and the FNDSQF library. What is inside this API: Retrieve user profile values for the current run-time environmentSet user profile values for the current run-time environment There are various Objects that can be used with this API\'s. These are discussed below: 1. Put :This can be used to put a value to the specified user profi

su 切换到另一用户whoami(or who am i)显示当前用户who查看当前在线上的用户man  查看其它命令的用法cp -rf src desc 目录拷贝rm -rf src 目录删除mkdir -m777 oralce/apps –p创建多层目录emacs  启动emacs编辑器netstat  显示网络状态vmstat  显示虚拟内存状态iostat  显示输入/输出状态echo  将字符串写入到标准输出ping测试网络，ping不仅仅是windows下的命令，在unix和linux下也有这个

Signon Password Failure Limit The Signon Password Failure Limit profile option determines the maximum number of login attempts before the user\'s account is disabled. Users cannot see or update this profile option. The internal name for this profile option is SIGNON_PASSWORD_FAILURE_LIMIT. Signon Password Hard to Guess The Signon Password Hard to Guess profile option sets rules for choosing passwords to ensure that they will be "hard to guess." A password is considered har

Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1) Recommended Browsers for Oracle E-Business Suite 11i (Doc ID 285218.1)

Object Name Function of the object E.g. _ALL Underlying table with all the values PO_DISTRIBUTIONS_ALL _B Base of underlying table, same as _ALL MTL_SYSTEM_ITEMS_B _TL Language translation table with translation of descriptive fields in different languages FND_RESPONSIBILITY_TL _VL View based on translation table,are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USER

转自：http://heliosguneserol.wordpress.com/2010/05/06/how-to-apply-patches-in-e-business-suite/ In this article i try to expalin how we can apply patches in our E-Business Suite instance 1. Download the patch from Metalink (You can find all patches under Patches&Updates tab) 2. Copy the patch file to any directory (Let us say  /data/metalink_patches) 3. Stop all application services (If we dont want to close application services, we have hot patch option.For more details

rem ----------------------------------------------------------------------- rem Filename: appinfo.sql rem Purpose: Script to display status of all the Concurrent Managers rem Author: Anonymous rem ----------------------------------------------------------------------- set head on column OsId format A10 justify left column CpId format 999999 column Opid format 999 column Manager format A30 column Status format A20 column Started_At format A30 column Cpid

AD_APPLIED_PATCHES contains the list of patches that were directly applied.AD_BUGS contains the list of all the patches that were directly applied or were contained in the patches that were directly applied.For example, if you are trying to find out if a certain pre-requisite patch has been applied, query AD_BUGS. If you are trying to find out patches applied in a date range, query AD_APPLIED_PATCHES.SELECT * FROM ad_bugs WHERE bug_number = \'patch_number\'; SELECT * FROM ad_ap

全文阅读见PL/SQL FAQ How can one see if somebody modified any code? The source code for stored procedures, functions and packages are stored in the Oracle Data Dictionary. One can detect code changes by looking at the TIMESTAMP and LAST_DDL_TIME column in the USER_OBJECTS dictionary view. Example: SELECT OBJECT_NAME, TO_CHAR(CREATED, \'DD-Mon-RR HH24:MI\') CREATE_TIME, TO_CHAR(LAST_DDL_TIME, \'DD-Mon-RR HH24:MI\') MOD_TIME, STATUS FROM USER_OBJECTS WHERE L

Cursor Loop   Explicitly declared cursor and record CREATE OR REPLACE PROCEDURE <procedure_name> IS CURSOR <cursor_name> IS <SQL statement> <record_name> <cursor_name>%ROWTYPE; BEGIN   OPEN <cursor_name>   LOOP     FETCH <cursor_name> INTO <record_name>;     EXIT WHEN <cursor_name>%NOTFOUND;     <other code>   END LOOP;  

Oracle提供三种样式的Loop结构 1. The Basic Loop The BASIC loop repeats until a condition is met. Because the condition is tested at the end of the loop, the BASIC loop will always execute at least once. A simple loop runs until you explicitly end the loop. The syntax for a simple loop is as follows: LOOP [Sequence of statements] EXIT [condition] END LOOP; To end the loop, you use either an EXIT or EXIT WHEN statement. The EXIT statement ends a loop immediately.

Gartner发布的各大ERP顾问公司的情况维度表 Deloitte Touche Tohmatsu Limited is pleased to announce that its China member firm is positioned in the Leaders quadrant of Gartner’s Magic Quadrant for ERP Service Providers, China. Gartner has published its inaugural Magic Quadrant for ERP Service Providers in China, which presents the vendor landscape for 16 companies considered for ERP implementation initiatives. The vendors are evaluated against the Gartner criteria of

把Form转换成TXT格式的文件 命令：frmcmp_batch INVIDITM.fmb apps/apps@md0yd201 Compile_All=yes Forms_Doc=yes Form格式的文件可以转换成TXT，转换后可读性其实并不好，只不过在某些特别的情况有点用，比如一个Form内容发生了变化，因为Form不好比对，可以考虑转换成TXT的格式再进行比对 转换后的文件内容类似于 * Name ENTRY_STATE - Item

关于FND_MESSAGE的详细用法可以参见 http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462354.htm 这里只列出几个常用的Example,方便查用 FND_MESSAGE.SET_NAME Retrieves your message from Message Dictionary and sets it on the message stack. You call FND_MESSAGE.SET_NAME once for each message you use in your client-side PL/SQL procedure. You must call FND_MESSAGE.SET_NAME before you call FND_MESSAGE.SET_TOKEN. Example 1 /* Display a warning, asking OK/Cance

Open Form fileR12frmbld.sh INVTOMAI.fmb11if60desm XXX.fmbCompiling formR12frmcmp.sh module=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form compile_all=special(Batch Mode)frmcmp.sh module=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form batch=yes compile_all=special(Non-GUI Mode)frmcmp_batch module=ABCDEFG.fmb userid=apps/apps@instance output_file=ABCDEFG.fmx11if60genm module=INVKBPSQ.fmb userid=apps/apps@lvis115pCompiling Library fileR12.Generate a pllfrmcmp.sh Module=INVSLENT.p

Symptoms While book sales order,encounter error "Salesperson is required on a booked order." Solution Specify a Salesperson in SO header

Oracle Asian R&D Center(OARDC) FY12 Q3 Award Announcement的评选结果出来了，获得了Spot Individual Award，特此记录,Keep up with good work

Below is a list of some of the key Profile Options in various modules.Profile Options - INVENTORYINV:Accounting Category Set Indicates the default category set for defining category account. This profile option references the \'Product Line Accounting\' function area to retrieve the category set.This profile is updateable only at the Site level.INV:Allow Expense to Asset Transaction Indicates whether you can transfer an item from an expensed subinventory to an asset location.This profile is up

Move this content to http://blog.csdn.net/pan_tian/article/details/7472310Metalinkhttps://support.oracle.com/ (Old Link ishttps://metalink.oracle.com/)EBS R12 User Guidehttp://docs.oracle.com/cd/B53825_08/current/html/docset.htmlEBS 11i User Guidehttp://docs.oracle.com/cd/B25516_18/current/html/docset.htmlOracle Applications Libraryhttp://docs.oracle.com/cd/A60725_05/html/comnls/us/index.htmeTRM(Electronic Technical Reference Manual)http://etrm.oracle.com/pls/etrm/etrm_search.searchUse to chec

1: When exiting form, Check the form status. 2: If the status is changed, then display the customized alert.in a KEY-EXIT trigger at form level, enter the following code: declare button_val number; begin -- Perform validation at item level to update :SYSTEM.FORM_STATUS. validate(ITEM_SCOPE); -- Check the record status if(:SYSTEM.FORM_STATUS = \'CHANGED\') then button_val := show_alert(\'ask_commit\'); if button_val = ALERT_BUTTON1 then -- If user chooses to commit changes...