2012年10月_田攀

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月

原创 Windows 7下通过Excel2007连接Oracle数据库并对表查询

1. 环境变量的设置1.1 ORACLE_HOME环境变量的设置，我这里指向了我的Oracle 10g的客户端ORACLE_HOME=C:\oracle\product\10.2.0\client_21.2 TNS_ADMIN环境变量的设置,TNS_ADMIN目录下需有tnsnames.ora文件2.ODBC的连接我的OS为Windows7,控制面板>管理工具>数据源(ODBC),这个ODBC为

2012-10-31 19:01:53 28935 1

原创 ODBC连Oracle数据库报错,SQLState=IM004

Window7下使用ODBC连Oracle数据库(11g的)，然后报下边的错误:Unable to connectSQLState=IM004[Microsoft][ODBC 驱动程序管理器]驱动程序的 SQLAllocHandle on SQL_HANDLE_ENV 失败解决方法：原来是Oracle_Home指向错了，我连得是Oracle11g的数据库，但环境变量里指定的Oracle_Home为

2012-10-31 15:49:45 10525

原创 ODBC in Win7

Win 7下的ODBC不同bit所在路径名字取得实在令人发晕C:\Windows\System32\odbcad32.exe是64 bit ODBCC:\Windows\SysWOW64\odbcad32.exe则为32 bit ODBC应用通过ODBC连到Oracle数据库的路线图（refer:http://support.microsoft.com/kb/140548）

2012-10-30 12:44:49 5198 2

原创 OS & Oracle is 32-bit or 64-bit?

如何判断Oracle数据库是32位还是64位？Script 1:SELECT length(addr)*4 || '-bits' word_length FROM v$process where ROWNUM =1;Script 2:select * from v$version;output like:Oracle Database 11g Enterprise Edition Releas

2012-10-30 11:53:33 2519

原创 Script to compile invalid objects in DB

REM: Script to compile invalid objects in DB after refreshingREM:REM:*****************************************REM:REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE.REM: Author will not be responsible

2012-10-29 19:18:58 2154

原创 poplist

How to populate poplist item? Your client has a form that contains a product description. They don’t want that their data entry staffs to type a

2012-10-29 17:57:38 2547

原创 Period Table - org_acct_periods

ORG_ACCT_PERIODS holds the open and closed financial periods for organizations. When a period is opened, the period open form (INVTTGPO) pulls in the next available period from the GL table GL_PERIOD

2012-10-27 16:58:47 6560

原创 UltraEdit for PL/SQL

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

2012-10-26 11:48:50 6784

原创 Outstanding Teams Award

上个财年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，

2012-10-25 22:26:05 2380

原创 Putty的颜色

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

2012-10-25 16:17:26 21918 1

原创 Unit Of Measure(UOM) in Oracle Applications Inventory

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

2012-10-23 17:12:41 14524

原创 WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG

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 ..

2012-10-23 12:49:26 8094

转载 Log file location for Oracle E-Business Suite R11

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 thi

2012-10-23 12:31:53 2764

转载 Log file location for Oracle E-Business Suite R12

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:$INS

2012-10-23 12:29:41 2100

原创 Oracle E-Business Suite Clonning FAQ

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 proce

2012-10-23 11:29:10 2610

原创 OAException: Application: ICX, Message Name: ICX_SESSION_FAILED.

打完patch之后，重新登录Oracle EBS系统，报错Exception Details: oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.sso.login.server.MainLoginPageAM'.... ...## Detail

2012-10-19 13:29:51 6749

原创《好妈妈胜过好老师》书摘

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

2012-10-17 23:55:03 8190

转载 SQL*Plus commands

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

2012-10-12 11:42:45 2385

原创 .trc and .trm files in Oracle 11g

What is .trc file?Ans:Sql Trace Collection fileWhat is .trm file?Ans:Trace map (.trm) file.Trace files(.trc) are sometimes accompanied by corresponding trace map (.trm) files, which contain st

2012-10-12 11:33:05 8242

原创盘点那些年，被Oracle收购的公司

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

2012-10-11 13:37:41 6214 1

原创让Sql Plus环境变量的设置永久生效

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

2012-10-11 11:22:57 5452

原创 EBS 11i and 12.1 Support Timeline

E-Business Suite 11.5.10 Sustaining Support Exception & 12.1 Extended Support Now to Dec. 2018 (Note 1495337.1)EBS 11i and 12.1 Support Timeline ChangesRelated:Oracle产品支持的三个策略（Premier

2012-10-10 10:09:34 2542

原创 How to use Chrome to access Oracle Applications

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 1

2012-10-09 17:57:19 3629

原创 ASCII & CHR Function

The ASCII function returns the NUMBER code that represents the specified character.ASCII( single_character )SELECT ASCII('A') FROM dual;Output:AThe CHR function is the opposite of the asci

2012-10-09 17:11:55 1930

原创 Prompt & Accept in sqlplus

With prompt & accept, it is possible to interactively set a value for a user variable in SQL*Plus.Sample 1set echo off;set serveroutput on size 999999;Prompt ptian test scriptprompt Ple

2012-10-09 12:24:39 2611

转载 SQL*Plus FAQ

source:http://www.orafaq.com/wiki/SQL*Plus_FAQContents [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

2012-10-09 11:28:19 2329

原创 ENTER-QUERY Mode

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 process

2012-10-08 15:41:51 3932

转载 Hidden Methods to Query Oracle Apps Forms -- Very Useful

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 tha

2012-10-08 15:13:17 2742

原创 Oracle E-Business Suite On Demand

Oracle E-Business Suite On Demand(OOD)是指服务器在Oracle那边，由Oracle负责管理维护，客户通过公网（或VPN）来访问EBS系统。和传统的ERP系统（In-House）比，有好处也有麻烦的地方,Oracle E-Business Suite On Demand (OOD): Real Life Experiences对于OnDemond的好处和坏处

2012-10-08 11:51:54 2570