Oracle EBS Shipping(WSH)模块日志收集方法

deci

　　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:
  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);
  
• Submit the job.
  
• Provide the log file.