How to get the Diagnostic data and debug file of Sales Order pick release

来源:互联网 发布:东海舰队 知乎 编辑:程序博客网 时间:2024/06/06 08:19
Refer to Note 133464.1--HTMOMSE Sales Order Diagnostic Script.
1). Download the sql file containing the script.
There are two versions of this script:
HTMomse11i.sql for Release 11i.
HTMomse12.sql for Release 12.


2). Run the script from SQL*Plus connected as APPS user as follows:


If your environment is R11i:
sqlplus apps/apps @HTMomse11i.sql


If your environment is R12:
sqlplus apps/apps @HTMomse12.sql


3). The output file will be located on the DB Server in the 'utl_file_dir' directory. 


2.1). Set the following profile options at the User Level:
OM: Debug Level - set to 5
INV: Debug Level - set to 10
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.
0 0
原创粉丝点击