ITPub博客

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 dropped so leaving this on will create a build up of many temporary tables throughout GL, like gl_posting_interim_nnnnn1. Set GL: Debug Mode profile option to Yes, run the program and provide the program log.Note: This profile option introduced in GL 11i FP.D initially allowed 5 main GL concurr

一个RDA报表能收集目标模块许多关键数据，比如目标模块的各个文件版本，JDBC版本，索引情况，Profile配置，系统版本，DB版本...一个Report在手，系统的配置信息你也基本就拿全了。使用方法：Start Oracle E-Business SuiteConnect to responsibility Application Diagnostics Select the Diagnose menu optionClick button Select Application and select an appropriate ApplicationScroll down to group "System Sna

$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$.AFLOG_LEVELSpecifies the logging level. The default value is NULL (Log.UNEXPECTED).$PROFILES$.AFLOG_MODULESpecifies which modules are logged. The default value is NULL (%).Refer:http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T359300.htm$PROFILES$.APPLWRK= Profile: FND: Override DirectoryThe

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 list box, Choose \'Show Log on Screen\',and Select Statement4.Once this is done , when you go to any page you would be able to see log at the bottom of the page .----------------------------------------------------------------------------------------------------------------------------------

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. Select \'Set Trace Level\' and click Go4. Select the desired trace level and click Save5. Write down the trace id number(s).6. Perform the activity that you want to trace7. Return to the \'Diagnostics\' page.8. Select `Set Trace Level\' and click Go9. Select \'Disable Trace\' and click Go.10. Wr

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 -- DESCRIPTION: -- ============ -- Script qtytree12.sql is intended to collect quantity tree debug log and data dump from key tables related to quantity eg.MOQD,MR,MMTT etc. -- qtytree12.sql is only used For EBS R12 or higher version. -- -- <<OUTPUT FILE>> -- path:utl_file_dir -- file

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 environment until some future date.  Test your FormMenu:Help-->Diagnostics-->ExamineBlock : $PROFILESField : APPLWRKValue : <your directory in linux> e.g /home/ptian/temp/Test your Library(pld) changes: (in R12)Menu:Help-->Diagnostics-->ExamineBlock : $ENVIRONMENTField : FORMS_PA

研究了下在Toad是下如何调试Stored procedure或者function，之前都是看到Toad下有相应的菜单，但一直不知道怎么使用。具体可以参考文章：Debugging PL/SQL, now available for everyone!这里就通过我的一个case来说明具体怎么样在Toad中调试的：这个Case的测试代码：CREATE OR REPLACE PROCEDURE APPS.swapn (num_one IN OUT NUMBER, num_two IN OUT NUMBER) IStemp_num NUMBER;BEGINtemp_num := num_one;num_one := num_two;num_two := temp_num ;END

"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

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

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 string.从上面的Last_Query定义的解读：1.SYSTEM.LAST_QUERY返回的只能是查询(Select)的SQL语句，不会有Update,Insert,Delete SQL语句;2."The current Run form session"说明不同的Form，SYSTEM.LAST_QUERY可以有不同的值的，不会混淆;3."Used to po

之前每个模块记录日志的方式都不同，都会把日志写到不同的文件中，对于User来说很麻烦，需要记住很多的配置，现在越来越多的模块使用FND Logging来存储日志，比如WIP，RCV,OAF...FND Debug Log会把Apps的日志输出到FND_LOG_MESSAGES表里。 怎样收集FND的日志 Step 1 profile设置(user级) FND: Debug Log Level,这个level，可以设置为Unexpected，Error，Exception，Event，Procedure或者Statement，一般情况下

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可以设置为: Fatal, Error, Warning, Debug, and Trace.Fatal只有在出现错误的情况才会记录日志. Trace会打出所有日志。因为性能原因，一般情况下不要设置logLevel到TRACE3. 重启mobile Server4. 业务处理, 在日志

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 Log Enabled = Yes     3. FND: Debug Log Level = Statement     4. FND: Debug Log Module = WIP% To get the log file, run the following SQL script. This will create an output called MoveON.txt        

A. To generate a debug file from the Shipping Transaction or Quick Ship forms Set the following profile options: OM: Debug Level - set to 5 WSH: Debug Enabled - set to Yes WSH: Debug Level - set to Statement WSH: Debug Log Directory - any directory that can be written to by the database To check, run the following SQL statement: Code: select value from v$parameter where name = \'utl_file_dir\' Set profile option WSH: Debug Log Directory at the Site & Application Level.In

遇到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 profile is equal to 5)OM: Debug Log Directory =  /usr/tmp/debug.log路径必须为select value from v$parameter where name = \'utl_file_dir\'中的值，并且用户有对于目录的写权限。转载请注明出处：

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.csdn.net/pan_tian/article/details/7688443FND Debug Log(FND_LOG_MESSAGES)及Concurrent Request日志的收集方法refer:http://blog.csdn.net/pan_tian/article/details/7688987WIP模块日志收集方法Refer:http://blog.csdn.net/pan_tian/article/details/768

Raw Trace的收集方法 1. 打开Trace，Help > Diagnostics > Trace > Trace > Trace with Binds and Waits Trace项代表的意思 No Trace – turns trace off. Regular Trace – generates a regular SQL trace by performing the following statement:                                ALTER SESSION SET SQL_TRACE = TRUE; Tr

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 form.2. Get LOV SQLGet prev_sql_addr, sid is the Form Session SID value which we get in step 1SELECT s.prev_sql_addr,s.sql_address FROM v$session s WHERE s.sid = 741;Then execute below query, you will get LOV query, t.address is PREV_SQL_ADDR.SELECT sql_text FROM v$sqltext_with_newlines t

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 run debug SQL quickly within the right environgment you want:   (1) Login any application or form to the situation you want to chek SQL data (e.g. Enter \'Inventory\' resp, change organization to M1 and open Receiving Transaction form and go on with following steps) (2) Click menu \'H