Oracle EBS Shipping(WSH)模块日志收集方法
程序员文章站
2024-01-17 11:11:22
...
Oracle EBS Shipping(WSH)模块日志收集方法
A. To generate a debug file from the Shipping Transaction or Quick Ship forms
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.B. To generate debug information for Pick Release :
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
C. To generate debug information for Interface Trip Stop - SRS:
OM: Debug Level - set to 5
INV: Debug Level - set to 10
WSH: Debug Enabled - set to Yes
WSH: Debug Level - set to Statement
D. To generate debug information for an APIs:
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
Code:
DECLARE l_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);上一篇: T-SQL 查询语句的执行顺序解析
下一篇: SQL优化建议备忘录_MySQL