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 the Shipping form go to Tools and check the Debug box. This will print out a file name - NOTE down this file name.
- Perform the action you wish to debug.
- Go to Tools and uncheck Debug.
- After you have completed generating the debug file, please set thevalue of the profile OM: Debug Level back to 0 and WSH: Debug Enabledset to No, otherwise there will be some performance impact. Retrievethe debug file from the directory specified in step 1.
B. To generate debug information for Pick Release :- Set the following profile options:
OM: Debug Level - set to 5
INV: Debug Trace - set to Yes
INV: Debug Level - set to 11
FND: Debug Log Enabled - set to Yes
FND: Debug Log Level - set to Statement
FND: Debug Log Module = set to wms.plsql.%
WSH: Debug Enabled - set to Yes
WSH: Debug Level - set to Statement - In the Release Sales Order for Picking form go to Tools and check the Debug box.
- Submit the pick release.
- Provide the Pick Selection List Generation log file.
C. To generate debug information for Interface Trip Stop - SRS:- Set the following profile options:
OM: Debug Level - set to 5
INV: Debug Level - set to 10
WSH: Debug Enabled - set to Yes
WSH: Debug Level - set to Statement - Set the Debug Level parameter to 1 (Debugging ON) .
- Submit the job.
- Provide the log file.
D. To generate debug information for an APIs:- Set the following profile options:
OM: Debug Level - set to 5
INV: Debug Level - set to 10
WSH: Debug Enabled - set to Yes
WSH: Debug Level - set to Statement
WSH: Debug Log Directory - set to a valid writeable directory path - Add the following line of code in the wrapper script which calls the API:
Code:DECLAREl_file_name VARCHAR2(32767); l_return_status VARCHAR2(32767); l_msg_data VARCHAR2(32767);l_msg_count NUMBER;BEGIN fnd_profile.put("WSH_DEBUG_MODULE","%"); fnd_profile.put("WSH_DEBUG_LEVEL",WSH_DEBUG_SV.C_STMT_LEVEL);wsh_debug_sv.start_debugger(l_file_name,l_return_status,l_msg_data,l_msg_count); - Submit the job.
- Provide the log file.
Oracle EBS WIP模块Debug Log收集方法Oracle EBS OM(Order Management)模块日志收集方法相关资讯 Oracle高级培训
- delete表的数据后恢复 (08/30/2012 08:59:58)
- 使用ASH信息,发现高CPUsession (08/14/2012 07:21:32)
- 如何阅读Oracle Errorstack Output (08/14/2012 07:15:47)
| - Oracle Apps Patching:adpatch( (08/16/2012 15:41:37)
- 话说V$SQL_MONITOR (08/14/2012 07:19:54)
- Oracle Apps DBA工具:ADADMIN使用 (08/14/2012 07:00:09)
|
本文评论 查看全部评论 (0)