当前位置:Gxlcms > mysql > OracleEBSShipping(WSH)模块日志收集方法

OracleEBSShipping(WSH)模块日志收集方法

时间:2021-07-01 10:21:17 帮助过:46人阅读

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

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.
  • linux

    人气教程排行