ITPub博客

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的好处和坏处做了罗列，可作参考（评论中也有亮点） ===Good Things Regarding Oracle On Demand=== * Three instances are provided (Development, Test and Production.) *

查看执行计划除了AUTOTRACE的方法外，还可以使用DBMS_XPLAN Package来查看 1.执行"explain Plan" 语法: SQL> Explain plan for Try this command: SQL> explain plan for select * from mtl_system_items_b where inventory_item_id = 149 and organization_id = 207; Explained 这个命令会产生执行计划，并把执行计划保存到"PLAN_TABLE"中。 2.查看执行计划 SQL> select * from table(dbms_xplan.display); (dbms_xplan.di

SQL Trace收集方法 Current Session Level 1.Enable Sql Trace alter session set sql_trace = true; alter session set statistics_level = ALL; alter session set timed_statistics = true; alter session set max_dump_file_size = unlimited; alter session set tracefile_identifier = ptian123; 蓝色部分，非必须执行的脚本；tracefile_identifier为trace标识符，用于快速找到sqltrace文件； 2.set TRACING LEVELS --Setting level 12 trace to get bind values and wait state

Oracle Apps DBA可以从System Administrator >> Concurrent : Manager >> Administer里查看所有Concurrent Manager运行的状态,其实如果仅仅是查看的话，也可以通过下边这个脚本来查看. SELECT DECODE(CONCURRENT_QUEUE_NAME,\'FNDICM\',\'Internal Manager\',\'FNDCRM\',\'Conflict Resolution Manager\',\'AMSDMIN\',\'Marketing Data Mining Manager\',\'C_AQCT_SVC\',\'C AQCART Service\',\'FFTM\',\'FastFormula Transaction Manager\',\'FNDCPOPP\',\'Output Post Processor\',\'FNDSCH\',\'Schedul

SQL> SET AUTOTRACE ON SQL> SELECT SYSDATE FROM DUAL; SYSDATE -------------- 26-9月 -12 执行计划 ---------------------------------------------------------- ERROR: an uncaught error in function display has happened; please contact Oracle support Please provide also a DMP file of the used plan table PLAN_TABLE ORA-00904: "OTHER_TAG": 标识符无效 统计信息 ---------------------------------------------------------- 0 recursive calls

执行下边的脚本 CREATE TABLE MYEMP  ( EMP_ID        NUMBER,    EMP_NAME      VARCHAR2(10),    SAL           NUMBER,    Joined_date   DATE,    DEPT_NO       NUMBER); INSERT INTO MYEMP VALUES (3, \'THREE\', 1500, To_Date(\'01-MON-2007\',\'DD-MON-YYYY\'), 10); 报:ORA-01843: 无效的月份

Introduction I wrote this document because so many people in the Oracle Technology Network (OTN) Forms Forum have asked “How do I run a form from the Forms Builder?” or “I just installed Forms 10g and all I get is a blank browser window when I run a form.” After I responded to numerous posts (always writing the instructions from scratch) I decided to write this document. As they say, “It is always better to reuse then to recreate!” Disclaimer First and foremost, this doc

1. set up FORMS_PATH(in 11i,it is FORMS60_PATH), make this env parameter point to directory where pll location FORMS_PATH is used by Forms Builder to record the location of attached libraries (.pll) and subclassed objects (such as items from a Template.fmb or Object Library [.olb]). 2.In your pld file header, write .attach LIBRARY library_name END NOCONFIRM 3.Then in your new pld file, you can invoke procedure/function from attached Libary. .pld file structure see below example:

2011财报金蝶用友营业收入20.2249亿人民币（同比增长40.8%）41.22亿人民币（同比增长38.4%）净利润1.45亿(同比减少46.6%)5.37亿元(同比增长61.7%)每股基本盈利0.0577元（减少约47.2%）0.66元（增长61.7%）金蝶：市值100亿用友软件： 市值167.9亿元金蝶2011年度财报source:http://it.sohu.com/20120327/n339068866.shtml金蝶国际发布了经过审核的截止至2011年12月31日年度全年业绩公告。公告显示，金蝶国际去

source:http://apacmediacentre.oracle.com/Content/Detail.aspx?ReleaseID=5734&NewsAreaID=2&ClientID=5   甲骨文第一财季GAAP每股收益增长15%达41美分，非GAAP每股收益增长11%达53美分 甲骨文2013财年第一财季GAAP和非GAAP总收入为82亿美元，净利润为20.34亿美元，比去年同期增长了11%。甲骨文总裁Mark Hurd表示：Exadata、Exalogic、Exalytics及甲骨文其他一体化集成系统在第一财季增长超过了100%

启动SQL Tools尝试连接Oracle数据库，报ORA-12557: TNS:protocol adapter not loadable的错. 解决方法： 把C:\oracle\product\10.2.0\client_2\BIN目录加到环境变量Path中，再重启SQLTools，就解决问题了。

Oracle EBS中,"About Oracle Application"里的信息不全,Help > About Oracle Application,发现"Database Server","Forms Server"以及"Forms Server Environment Variables"的很多信息都没有打印全，比如Database Server PID,Session SID,SERIAL#,Forms Process ID... Oracle Applications Copyright (c) 2004 Oracle Corporation, Redwood Shores, California. All Rights Reserved. ---------------------------------------- Database Server --

"Initialization SQL Statement - Custom"常用于Concurrent Request的Sql Trace1.查询Profile:"Initialization SQL Statement - Custom"，值设置为Begin fnd_ctl.fnd_sess_ctl(\'\',\'\',\'TRUE\',\'TRUE\',\'LOG\',\'ALTER SESSION SET TRACEFILE_IDENTIFIER=\'||\'\'\'\'||\'ptian123\'||\'\'\'\'||\' EVENTS=\'||\'\'\'\'||\'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12\'||\'\'\'\');End;Note:ptian123为sql trace一个标示，可以自行定义2.运行Concurrent Request3.查找user_dump_destselect name, valuefrom v$param

Sample: alter session set events \'10046 trace name context forever, level 12\'; Event # Level  Description 8186 - ALTER SESSION SET EVENTS \'8186 trace name context OFF\' - VERSIONS BETWEEN query 10013 1 Monitor Transaction Recovery 10015 1 Dump Undo Segment Headers 10015 3 Identify corrupt undo segments 10032 4 Dump Sort Statistics 10031   Sort Debug Events 10032 10 Dump Sort Statistics 10033 4 Dump Sor

sql trace默认生成到user_dump_dest下，这个目录有可能存在很多sql trace，所以要找到你的trace文件有时候要费一些功夫。Oracle提供了一个有用的参数，可以让你快速的找到你的trace文件--TRACEFILE_IDENTIFIER Oracle SQL Trace收集方法: 1. Set the tracefile identifier as you want, this will be appended to trace file name. alter session set tracefile_identifier=\'ptian_sql_trace\'; 2. Enable your session level tracing alter session set sq

1. System Administrator > Concurrent > Program > Define 注意：如果仅仅是"Enable Trace",收集到的Sql Trace并不包含binds and waits (Checking the Trace Check box on the Concurrent Program gives an Event 10046 Level 8 trace. So even if the trace is set for Binds and Waits on the Submission form once the concurrent program is encountered in the trace it will reset to level 8 so no binds will be present in the trace after that point.) 2.Concurrent: Allo

Oracle EBS中做业务的时候报ORA-01653: unable to extend table FND_CONCURRENT_REQUESTS by 16 in tablespace APPS_TS_TX_DATA解决方法：应该是表空间不够引起的，可以通过Script – Tablespace Information里的脚本查看下。使用下边Query查看TablespcaceSELECT * FROM dba_data_files WHERE tablespace_name=\'APPS_TS_TX_DATA\'使用下边SQL增加一个数据文件到Tablespace中ALTER tablespace APPS_TS_TX_DATAADD datafile \'/u01/oracle/mc3yd213/db/apps_st/data/tx_data54.d

Locator Level是一个自上而下控制的，Order:Org locator Control  > Subinv  locator Control > Item  locator Control   Org Level Locator Control None: Inventorytransactions within this organization do not require locator information. Prespecified only: Inventory transactions within this organization require a valid, predefinedlocator for each item. Dynamic entry allowed: Inventory transactions within this organization require a locator for eachitem. Yo

以Vision Demo库的Assembly Item:75100021为例(这个Item为摩托车组装成品物料) Query1:Sql query to print BOM hierarchy for a given assembly item select level,bill_item_name,assembly_item_id,component_item_name, component_item_id from apps.bomfg_bom_components start with bill_item_name = \'75100021\' --Replace your assembly_item_id to here connect by prior component_item_name = bill_item_name; Output: LEVEL BILL_ITEM_NAME ASSEMBLY_ITEM_ID COMPONENT_ITEM_NA

Win7下，启动SQLTools，报:OCI8: Cannot allocate OCI handle详细错误：Please make a post about this problem in the forum:    http://www.sqltools.net/cgi-bin/yabb25/YaBB.plWe need the stack trace (see below) and short descriptionwhat were you doing when this problem occurred (desirable but optional).OCI8: Cannot allocate OCI handle.See http://sqltools.net/cgi-bin/yabb2/YaBB.pl?board=sqlt_faqProgram: SQLTools 1.6 Beta build 15Location: .\SQLTools.cpp(272).Platform:  P