![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle EBS Debug
文章平均质量分 72
田攀
tian.pan@qq.com
展开
-
启用OAF页面个性化三个配置(Profiles)
启用OAF页面个性化三个配置(Profiles)FND:诊断英文为FND: Diagnostics,用于设置是否显示“关于此页”个性化自助定义英文为Personalize Self-Service Defn,用户设置在登录后,OAF页面是否显示“个性化页”FND:已启用“个性化区域”链接英文为FND: Personalization Region Link Enabled,三个可选值:最小、是、否。是,会显示所有区域链接;最小,最低限度的显示区域链接。原创 2015-07-06 17:54:11 · 6275 阅读 · 0 评论 -
Using Profile "Initialization SQL Statement - Custom" to collect sql trace
"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 TR原创 2012-09-24 16:36:03 · 3578 阅读 · 0 评论 -
$PROFILES$ in Examine
$PROFILES$.AFLOG_ENABLEDSpecifies if logging is enabled or not. The default value is NULL (False).$PROFILES$.AFLOG_FILENAMESpecifies the file where middle-tier log messages are written.$PROFILES$.AFLO原创 2013-03-06 12:07:42 · 4717 阅读 · 0 评论 -
Some more useful information from 'Diagnostics: Apps Check'
User can follow Note:276207.1 to collect 'Diagnostics: Apps Check' output,It will provide diagnostic information related the module.Except Files Version information, There are many other useful inform原创 2013-01-19 16:04:48 · 2918 阅读 · 0 评论 -
How to Bounce Apache or OC4J for OAF Development
login to your instance with putty or any other software cd $ADMIN_SCRIPTS_HOMER12adoacorectl.sh stop adoacorectl.sh startadoacorectl.sh status(optional)11ish $COMMON_TOP/admin/scripts/adapcctl.sh stop原创 2012-11-01 11:33:12 · 4028 阅读 · 0 评论 -
Onhand Qty(Tree) Diagnostics Scripts
Diagnostics script qtytree_r12.sql is intended to collect quantity tree debug log and data dump from key tables related to quantity eg.MOQD,MR,MMTT etc.qtytree_r12.sqlSET SERVEROUTPUT ON SIZE 1000000原创 2013-01-16 09:58:11 · 4640 阅读 · 0 评论 -
How to Check Debug Log on OAF Pages
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3.In li原创 2013-01-30 12:29:16 · 5684 阅读 · 0 评论 -
How to Generate SQL Trace In OAF
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3. Sele原创 2013-01-30 11:45:55 · 3852 阅读 · 0 评论 -
Test your own form/library from a specific directory
As product analysts, part of your job is to test new functionality and bug fixes. You frequently encounter situations where the code is fixed but will not be rolled into a standard testing environmen原创 2013-01-15 12:20:39 · 2466 阅读 · 0 评论 -
Oracle MSCA(Mobile Supply Chain Application) Debug Log & SQL Trace
MSCA Debug Log1. 找到mwa.cfg配置文件In 11i: $MWA_TOP/secure/In R12: $INST_TOP/admin/install/2. 设置mwa.cfg trace level: mwa.LogLevel=TRACE'mwa.logdir' 为日志输出路径,R12下,mobile日志会写到$INST_TOP/logs下注:mwa.LogLevel可以设置原创 2012-06-25 00:20:40 · 3589 阅读 · 0 评论 -
LAST_QUERY in Form and OAF Page
1.Form里查看Last_QuerySYSTEM.LAST_QUERYRepresents the query SELECT statement that Oracle Forms most recently used to populate a block during the current Run form session. The value is always a character原创 2012-08-22 11:12:33 · 3669 阅读 · 0 评论 -
RDA(Remote Diagnostic Agent) Report for Oracle E-Business Suite
一个RDA报表能收集目标模块许多关键数据,比如目标模块的各个文件版本,JDBC版本,索引情况,Profile配置,系统版本,DB版本...一个Report在手,系统的配置信息你也基本就拿全了。使用方法:Start Oracle E-Business SuiteConnect to responsibility Application Diagnostics原创 2013-04-25 00:12:02 · 2893 阅读 · 0 评论 -
如何查找OAF页面所对应的表?
如何查找OAF页面所对应的表在Oracle EBS Form界面,你可以通过Diagnostics或Record History来找到(或猜到)界面所对应的表,那在OAF Web页面我们如何知道此页面在后台对应的表呢?方法:A1: Please follow the following steps to get the Supplier related table information:> Na原创 2014-08-12 10:36:09 · 3526 阅读 · 0 评论 -
在Procedure中增加自己的Debug Log
如何在Oracle EBS的PL/SQL Procedure中增加自己的Debug Log,并且不希望这些Log不要跟系统的日志混在一起,可以考虑用下边这个方法create sequence pt_debug_sequenceINCREMENT BY 1 -- 每次加几个START WITH 1 -- 从1开始计数NOMAXVALUE -- 不设置最大值NOCYCLE -- 一直累加,不原创 2012-04-06 16:55:25 · 2963 阅读 · 0 评论 -
Form Level Debug (FRD Debug Small Tips)
This tips is used to add your debug msg into form and Nomsg popup while testing the issueIntroduce a parameter into your debug form,eg. PT_DEBUG Add your debug message into form/pld like:copy('Go into原创 2012-04-06 12:22:41 · 2829 阅读 · 0 评论 -
How to generate an GL debug log file
Detail Log for GL programsUsed for concurrent request problems where we need to know what sql was used in key areas or we need to retain temporary tables. Note: Be aware that temp tables are never dr原创 2013-05-13 16:41:45 · 4049 阅读 · 0 评论 -
How to generate an AP debug log file
FND: Debug Log Enabled YesFND: Debug Log Filename FND: Debug Log Level STATEMENTFND: Debug Log Mode Asynchronous with Cross-Tier SequencingFND: Debug Log Module % or AP%No need to stop and restart E-B原创 2013-05-13 16:36:00 · 3292 阅读 · 0 评论 -
Oracle EBS各个模块日志收集的方法[Index]
Inventory模块日志的收集refer:http://blog.csdn.net/pan_tian/article/details/7688395Order Management模块日志收集方法Refer:http://blog.csdn.net/pan_tian/article/details/7688426Shipping(WSH)模块日志收集方法Refer:http://blog.csd原创 2012-06-24 15:00:00 · 3154 阅读 · 0 评论 -
How to generate an AR debug log file
1) Check value of profile option :AR: Enable Debug Message Output, it should be set to Yes 2) Run the following select statement to determine where the log will write to : select value from v$param原创 2013-05-13 16:27:06 · 2869 阅读 · 0 评论 -
Debug log of Cost Management
1.Make sure to set the following profile optionsMRP:Debug Mode = yesMRP:Trace Mode = yesCST: Cost update debug level = Full2.Resubmit the error transactions for costing.Uncosted/Failed transactions ca原创 2013-04-28 18:29:18 · 3238 阅读 · 0 评论 -
How to check backend SQL query from a OAF pages
In a OAF Page, Click 'About this Page''Business Component References Details' AreaDrill Down,You will see View Objects(VO),click any VO you want, you will see detailed SQL Query which is associated to原创 2013-01-14 15:31:56 · 3136 阅读 · 0 评论 -
How to debug stored procedure/function in TOAD
研究了下在Toad是下如何调试Stored procedure或者function,之前都是看到Toad下有相应的菜单,但一直不知道怎么使用。具体可以参考文章:Debugging PL/SQL, now available for everyone!这里就通过我的一个case来说明具体怎么样在Toad中调试的:这个Case的测试代码:CREATE OR REPLACE PROCEDURE APPS原创 2013-01-06 17:58:49 · 4173 阅读 · 0 评论 -
Oracle EBS RCV模块日志收集方法
Collecting RCV Debug files & logs in IMMEDIATE mode1. Set the following profiles at the user level before proceeding further.Profile Value CommentsRCV:Debug Mode Yes RCV:Proces原创 2012-06-25 00:09:17 · 4363 阅读 · 0 评论 -
Oracle EBS Inventory模块日志的收集
Profile的设置INV: Debug Trace: YesINV:Debug Level: 10(也可以大于10,小于15,级别越高,日志的详细程度越高)INV: Debug file: /usr/tmp/invdebug.log注:INV: Debug file所指定的路径必须是下边value中的select valuefrom v$parameterwhere原创 2012-06-24 23:33:05 · 3896 阅读 · 2 评论 -
How to run debug SQL with in front end(EBS)?
Somtimes, we will need to debug some SQLs and try to run them within environment parameters.It will be complex to debug in PL/SQL by setting fnd_client_infor or else. Following is the way to ru转载 2012-04-06 17:01:33 · 2311 阅读 · 0 评论 -
Oracle EBS WIP模块Debug Log收集方法
How to generate WIP debug log files in ONLINE cases? For 11.5.10 and above, the WIP debug log files will be created if 1. FND: Debug Log Filename = (Make sure this is null) 2. FND: Debug L原创 2012-06-25 00:04:03 · 3196 阅读 · 0 评论 -
Oracle EBS Shipping(WSH)模块日志收集方法
A. To generate a debug file from the Shipping Transaction or Quick Ship formsSet the following profile options:OM: Debug Level - set to 5WSH: Debug Enabled - set to YesWSH: Debug Level - set原创 2012-06-25 00:01:25 · 3223 阅读 · 0 评论 -
Oracle EBS SQL Trace日志收集的方法
Raw Trace的收集方法1. 打开Trace,Help > Diagnostics > Trace > Trace > Trace with Binds and WaitsTrace项代表的意思No Trace – turns trace off.Regular Trace – generates a regular SQL trace by performin原创 2012-06-19 17:22:48 · 5102 阅读 · 0 评论 -
EBS FRD(Forms Runtime Diagnostics) Log的收集方法
什么是EBS FRD?Forms Runtime Diagnostics,用于记录Form级别日志,例如,Form Build_In的调用,Form Error(FRM-xxx),Message,Exception怎样收集FRD日志1.以系统管理员登陆Append the user value of ICX: Forms Launcher with the Form原创 2012-04-06 17:59:25 · 3686 阅读 · 0 评论 -
EBS 'Application Diagnostics' responsibility
Oracle E-Business Suite Application Diagnostics is a free, easy to use, tool provided by Oracle to ease the gathering and analyzing of information from your E-Business Suite, specific to an existing i原创 2012-05-15 12:32:44 · 2717 阅读 · 0 评论 -
Oracle SQL Trace
SQL Trace收集方法Current Session Level1.Enable Sql Tracealter session set sql_trace = true;alter session set statistics_level = ALL;alter session set timed_statistics = true;alter session set原创 2012-09-28 13:52:55 · 3759 阅读 · 0 评论 -
Oracle EBS OM(Order Management)模块日志收集方法
遇到Sales Order或者相关业务流程(eg.pending demand, workflow status, etc.)的问题的时候,可以收集OM模块的日志再进行分析。收集方法:ProfileOM: Debug Level = 5(If it is zero then debug is off. All of the debug messages are displayed if this原创 2012-06-24 23:49:36 · 2959 阅读 · 0 评论 -
PL/SQL Profiler - DBMS_PROFILER
之前写过EBS下的PL/SQL Profiling 调试的文章,PL/SQL Profiling用于调试EBS下PL/SQL(如:Procedure,Function)的性能情况。今天抛开EBS这个特定的产品,写一下如何使用DBMS_PROFILER这个Package,如何获取PL/SQL中各段代码的执行时间。DBMS_PROFILER的官方介绍:http://docs.oracle.com/cd原创 2012-12-03 12:37:02 · 4527 阅读 · 0 评论 -
PL/SQL Profiling
Oracle EBS下如何使用PL/SQL Profiling1. Help -> Diagnostics -> Trace ->选上PL/SQL Profiling的check box2. Perform your transaction3. Uncheck ‘PL/SQL Profiling’4. Logout EBS. 系统会弹出一个Message告诉你 “Concurrent reques原创 2012-06-25 19:23:33 · 3211 阅读 · 0 评论 -
How to get runtime LOV query script
Get SID in your formIn the form, Help > About, to check this form Session SID.NOTE: In different form, Session SID is different.Then open LOV to trigger sql query, eg. open Subinv LOV in this misc txn原创 2012-06-14 14:15:44 · 2670 阅读 · 0 评论 -
Oracle Events & Level Dictionary
Sample:alter session set events '10046 trace name context forever, level 12';Event #Level Description8186-ALTER SESSION SET EVENTS '8186 trace name context OFF' - VER原创 2012-09-24 16:21:03 · 2392 阅读 · 0 评论 -
SQL Trace - TRACEFILE_IDENTIFIER
sql trace默认生成到user_dump_dest下,这个目录有可能存在很多sql trace,所以要找到你的trace文件有时候要费一些功夫。Oracle提供了一个有用的参数,可以让你快速的找到你的trace文件--TRACEFILE_IDENTIFIEROracle SQL Trace收集方法:1. Set the tracefile identifier as you want原创 2012-09-24 16:16:43 · 3601 阅读 · 0 评论 -
如何收集Concurrent Request的SQL Trace
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原创 2012-09-24 15:30:33 · 3433 阅读 · 0 评论 -
[Oracle]如何查看SQL的执行计划 - DBMS_XPLAN Package
查看执行计划除了AUTOTRACE的方法外,还可以使用DBMS_XPLAN Package来查看1.执行"explain Plan"语法:SQL> Explain plan forTry this command:SQL> explain plan for select * from mtl_system_items_b where inventory_item_i原创 2012-09-28 14:18:46 · 4157 阅读 · 0 评论 -
Flexfields FNDSQF Debugger
Flexfields FNDSQF DebuggerThe global variable GLOBAL.FND_FLEX_FNDSQF_DEBUG takes one of the following values: ’OFF’, ’EXCEPTION’, ’FAILURE’, ’DEBUG’.You set GLOBAL.FND_FLEX_FNDSQF_DEBUG through th原创 2012-04-06 15:56:03 · 2387 阅读 · 0 评论