ITPub博客

几个设置让UltraEdit更高效的使用PL/SQL(其他语言方法也是类似的)1.PL/SQL的高亮"%appdata%\IDMComp\UltraEdit"下在的模板文件WORDFILE.UEW中增加PL/SQL的高亮模板。PL/SQL的模板文件，可以从这个链接找到。2.增加自定义文件类型默认情况下，对于后缀为.sql的文件，就会使用pl/sql的模板打开了，但是pl/sql的文件类型还有很多种,比如后缀为pls,pld,pkg...，如果想让这些后缀的文件打开时自

上个财年FY12 Q3，获得了Oracle Asian R&D Center \'Spot Individual Award\'，这个财年FY13，我们的团队又获得了OARDC FY13 Q1"Outstanding Teams Award"。---Update 2013-04-28---今天得到消息，我们Team几个人又获得了OARDC FY13 Q3 Outstanding Team Award，FY13我们Team算是收获颇丰。

默认的Putty颜色非常难看，深蓝色，绿色，深红色...看着很不舒服，尤其是目录默认为深蓝色，不仔细看很难看清楚。这里有一个可以让putty展示更好看点的解决方案，先看效果图设置方法1.下载配置文件:igvita-desert.regPutty的配置文件实际上是一注册表文件，Putty会从注册表中读取配置。2.导入下载好的注册表文件 igvita-desert.reg这样在注册表[HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\Sessi

UOM Tables RelationshipUnits Of Measure FormForm: INVSDUOM.fmbTable: MTL_UNITS_OF_MEASUREMTL_UNITS_OF_MEASURE is the definition table for both the 25-character and the 3-character units of measure.The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class.Oracle Inventory uses this tabl

WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG Meaning N When WDD is created  P P is pending interfaced,updated just before inserting into MTI Y when INv trx mgr process MTI successfully ..

Below list of  log file locations could be helpful for your issue:Before start please notice PROD is my SID- Start/Stop script log files$COMMON_TOP/admin/log/SID_HOTSNAME/You can find below txt in this path:adadmat.txt adalnctl.txt adcmctl.txt adfmcctl.txt adupdbid.txtadadmprf.txt adapcctl.txt addisctl.txt adfmsctl.txt adupdlobs.txtFor to can check adstrtal.sh, adstpall.sh  scripts log file, you can use same path.For those sh, The log file creation sytax is:dd=`date ‘+%m%d%H%M

Below list of  log file locations could be helpful for your issue:- Apache, OC4J and OPMN:$LOG_HOME/ora/10.1.3/Apache$LOG_HOME/ora/10.1.3/j2ee$LOG_HOME/ora/10.1.3/opmn- Startup/Shutdown Log files:$INST_TOP/logs/appl/admin/log- Patch log:$APPL_TOP/admin/$SID/log/- Autoconfig log file:Apps:$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.logDb:$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/adconfig.log$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>/NetServiceHand

What\'s Cloning? - Cloning is the process of creating an identical copy of an already existing Oracle Applications system.FAQ:FAQ: Cloning Oracle Applications Release 11i [ID 216664.1]For cloning process please follow below references:Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]Cloning Oracle Applications Release 11i with Rapid Clone [ID 230672.1]Also check:Rapid Clone Documentation Resources, Release 11i and 12 [ID 799735.1]Descriptive Checklist for performing Rapid C

打完patch之后，重新登录Oracle EBS系统，报错 Exception Details:  oracle.apps.fnd.framework.OAException: Could not load application module \'oracle.apps.fnd.sso.login.server.MainLoginPageAM\'. ... ... ## Detail 0 ## oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: ICX_SESSION_FAILED. ... ... 解决方法： Restart Apps Server

《好妈妈胜过好老师》，非常棒的教育类书籍，行文、引用、还是作者亲身的教育经历，都可以真切的体会到作者对此书的付出。 之前已经买了实体书，但还是觉得用Kindle看书比较方便，所以还是找来电子版来看，中间用kindle也做了不少摘记。[书摘1] 我没让孩子承诺她一定不哭，我想，她能这样理解已很不容易，不需要给她任何压力，到时她万一哭了，也不用为自己违反了

The following commands can be issued in SQL*Plus (in addition to the standardSQL commands.) @pathname Run (START) an SQL Script @MyScript.sql parameter1 parameter2 parameter3 In the SQL-Script, refer to the parameters as &1, &2, and &3. @ScriptName.sql will call sub-scripts from the current working directory of SQL*Plus. @C:\work\oracle\ScriptName.sql will call a sub-script from a specific directory. @@pathnam

What is .trc file? Ans:Sql Trace Collection file What is .trm file? Ans:Trace map (.trm) file.Trace files(.trc) are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation. Doc ID 750982.1 explains this very well ------ (Doc ID 750982.1):TRM Trace Files Getting Generated in 11g Database From 11g onwards, all the trace files are found in ADR_HOME/trace directory. There is usual

微博上看到一图，很清晰。盘点那些年，被Oracle收购的公司，Oracle日益强大，都收购了哪些公司呢？别再以为只有Sun啦...看看你都知道哪些？ ps:Strategic Acquisitions:http://www.oracle.com/us/corporate/acquisitions/index.html#applications

每次打开Sql Plus都要设置环境变量，很麻烦，这里有个方法可以永久的保存你的环境变量的设置。 设置$ORACLE_HOME/sqlplus/admin/glogin.sql文件，在后边加上你自己的个性化设置。这样每次启动Sqlplus(不管是官方的sqlplus客户端，还是cmd命令行启动的sqlplus)，都会读取glogin.sql的设置。 下边是我glogin.sql里的设置: ------------------------------------------- prompt Loading PTIAN glogin.sql file... --提示

So far,Chrome browser is still not certified by Oracle Application, so you can not access Oracle Apps via Chrome.But you can install a chrome Extension to access Oracle Application(It works fine for 11i or R12 instance) Chrome Plugin:Oracle EBS R12 Enablement for Chrome You can use this Chrome Extension to log in Oracle E-Business R12 Form UI without FRM-92129(or FRM-92120) error which say the file Registry.dat lost. Plugin Author: zorrofox (see:http://www.itpub.net/forum.php?mod=v

The ASCII function returns the NUMBER code that represents the specified character.ASCII( single_character ) SELECT ASCII(\'A\') FROM dual; Output:A The CHR function is the opposite of the ascii function. It returns the character based on the NUMBER code. CHR( number_code ) SELECT CHR(9) FROM dual; Output:TAB 记录这个的原因是因为，遇到一客户问题，发现系统里的lot number中有空格似的字符，但是使用下边的query，又查不出

With prompt & accept, it is possible to interactively set a value for a user variable in SQL*Plus. Sample 1 set echo off; set serveroutput on size 999999; Prompt ptian test script prompt Please enter employee number?:; accept p_emp_no; declare val varchar2(30); begin select ENAME into val from emp where EMPNO = &p_emp_no and rownum = 1; dbms_output.put_line(\'Employee is \' || val); exception when others then dbms_output.put_line(\'Encounter a error,ORA ERR

source:http://www.orafaq.com/wiki/SQL*Plus_FAQ Contents  [hide]  1What is SQL*Plus and where does it come from?2How does one use the SQL*Plus utility?3What commands can be executed from SQL*Plus?4What are the basic SQL*Plus commands?5What is AFIEDT.BUF?6How does one enable the SQL*Plus HELP facility?7What is the difference between ? and HELP?8What is the difference between @ and @@?9What is the difference between & and &&?10What is the difference bet

SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string. * NORMAL - Indicates that the form is currently in normal processing mode. * ENTER-QUERY - Indicates that the form is currently in Enter Query mode. * QUERY - Indicates that the form is currently in fetch processing mode, meaning th 1.After pressing F11, Then system will switch to ENTER-QUERY mode. 2.If you hit Ctrl+F11, system will execute

Here I discuss how can we query a form by giving certain query condition like - Display only records where a particular column is null - Display only records where column is greater than or less than a certain value - Display only records where data is in certain range of value etc etc.... Press Function Key F11 to enter into query mode and Ctrl+F11 to run the query. Hash(#) is the magic key here Below are few examples with screenshots. As an example I have taken the FND_MESSAG