ONT-How to Create a Debug File in Shipping Execution (文档 ID 290432.1)

32 篇文章 1 订阅
9 篇文章 0 订阅

转自:https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=425753385590544&parent=DOCUMENT&sourceId=1338335.1&id=290432.1&_afrWindowMode=0&_adf.ctrl-state=1c8kev1z9c_621

转到底部转到底部

In this Document

Main Content
 Goal
 Solution


 FOR HTML SHIPPING USER INTERFACE FORMS ONLY for Version 12.2.X and above
 

Versions 11.5.9 to 12.x
     A. To generate a debug file from the Shipping Transaction or Quick Ship forms:
     B. To generate a debug for Pick Release:
     C. To generate a debug for Interface Trip Stop - SRS:
     D. To generate a debug for an API:
 Versions 11.5.2 to 11.5.8
     E. To generate a debug for Pick Release:
 
     F. To generate a debug for Interface Trip Stop - SRS:
    G. To generate a debug for an API:
 References

APPLIES TO:

Oracle Shipping Execution - Version 11.5.2 and later
Information in this document applies to any platform.
Oracle Shipping Delivery Based - Version: 11.5.2 to 12.1
***Checked for relevance on 18-Mar-2011***


MAIN CONTENT

Goal



Generate debug files to be used to analyze code and assist Support and Development in resolving Shipping application issues.

In addition please also provide the following required outputs :

  1. Output of the Oracle Order Management Sales Order Setup Test (Document 463673.1) or HTMomse12.sql output of (Document 133464.1),
  2. Output from either the ACT tool (Document 183274.1) or the Diagnostics Apps Check (Document 276207.1).

 

Solution


FOR HTML SHIPPING USER INTERFACE FORMS ONLY for Version 12.2.X and above

To generate a debug file from the HTML Shipping Transaction or Quick Ship forms:

For the HTML Shipping User Interface forms, the standard Logging mechanism provided by OAF is in use . This will be different from how “Shipping Debug Log” file is generated from Shipping Transaction form in Shipping Execution.

1) Enable FND logging as per MOS Note 433199.1 to get the debug log.

2) Set the following profile at User Level :

WSH: Debug Enabled - set to Yes
WSH: Debug Log Directory - This profile option may be set at the Site level to any valid directory path.
WSH: Debug Level - set to Statement
FND: Diagnostic to Yes
FND: Debug log enabled to Yes
FND: Debug log module to wsh%
FND: Debug log level to Statement.

3) Log message will get written to table FND_LOG_MESSAGE.

4) Just before the issue is reproducible , execute the following SQL statement:  
select max(log_sequence) from fnd_log_messages;
Note down the value as “Start Message Number”.

5) Then perform the reproducible steps. Once completed, again execute the above SQL statement and note down the value as “End Message Number”.

6) To get the log messages, execute the following SQL statement:
select module, message_text, log_sequence from fnd_log_messages where log_sequence between “Start Message Number” and “End Message Number”;



Versions 11.5.9 to 12.x

    A. To generate a debug file from the Shipping Transaction or Quick Ship forms:


Note: if executing Pick Release from this form, please refer to B. Pick Release below for additional settings and log file.

1. Please set the following Profile Options at the User level for your user_id.  These should be reset to previous values after you complete debugging.
      OM: Debug Level - set to 5
      WSH: Debug Enabled - set to Yes
2. The following Profile Option once set do not need to be changed.
      WSH: Debug Level - set to Statement
WSH: Debug Log Directory - This profile option may be set at the Site level to any valid directory path.
A valid path is any directory that can be written to by the database. To find available paths, run the following SQL statement:
select value from v$parameter where name = 'utl_file_dir'
3. In the Shipping form, go to Tools and check the Debug box. Please make a note of the file name displayed for later retrieval. 
4. Perform the action you wish to debug. 
5. Go to Tools and uncheck Debug. 
6. Provide the debug file from the directory specified in step 3. 
7. Reset profile options in Step 1. 
**If the profile option WSH:Debug Log Directory  is set to the same path as OM: Debug Log Directory profile option, the file may be retrieved using the Order Management concurrent request Diagnostic: OM Debug File Retrieval (Order Management responsibility, Reports,Requests > Request > Single Request). .
 
For a short video on creating and retrieving a Shipping Forms Debug, please refer to Document 1358154.1: Diagnostics: WSH Shipping Forms Debugging.

 

    B. To generate a debug for Pick Release:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5
     WSH: Debug Enabled - set to Yes
     INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement
     INV: Debug Level - set to 11 >
3. ONLY IF using Warehouse Management (WMS), set the following profile options:
     FND: Debug Log Enabled - set to Yes
     FND: Debug Log Level - set to Statement 
     FND: Debug Log Module - set to wms.plsql.%
4. In the Release Sales Order for Picking form go to Tools and check the Debug box. 
5. Submit the pick release. 
6. Provide the Pick Selection List Generation log file (View > Requests > Find the Pick Selection List Generation Log file > Click on View Log)
7. Reset profile options in Step 1 and if using WMS, Step 3. 

For a short video on creating and retrieving a Shipping Forms Debug, please refer to Document 1358164.1: Diagnostics: WSH Pick Release Debug.

 

    C. To generate a debug for Interface Trip Stop - SRS:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5  WSH: Debug Enabled - set to Yes  INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement 
     INV: Debug Level - set to 11 
3. Set the Debug Level parameter to 1 (Debugging ON) 
4. Submit the job. 
5. Provide the Interface Trip Stop log file (View > Requests > Find the Interface Trip Stop request -> click on view log)
6. Reset profile options in Step 1.  

For a short video on creating and retrieving a Shipping Forms Debug, please refer to Document 1358156.1: Diagnostics: WSH Interface Trip Stops Debug.

 

    D. To generate a debug for an API:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5
     WSH: Debug Enabled - set to Yes
     INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement
     INV: Debug Level - set to 11 
     WSH: Debug Log Directory - This profile option may be set at the Site level to any valid directory path. 
          A valid path is any directory that can be written to by the database.
          To find available paths, run the following SQL statement:
select value from v$parameter where name = 'utl_file_dir'
**If the profile option is set to the same path as OM: Debug Log Directory profile option, the file may be retrieved using the Order Management concurrent request Diagnostic: OM Debug File Retrieval (Order Management responsibility, Reports,Requests > Request > Single Request). .
3. Add the following line of code in the wrapper script which calls the API: 
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);
4. Submit the job. 
5. Provide the log file.
6. Reset profile options in Step 1. 

Versions 11.5.2 to 11.5.8

    E. To generate a debug for Pick Release:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5
     WSH: Debug Enabled - set to Yes
     INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement
     INV: Debug Level - set to 11 
3. In the Release Sales Order for Picking form go to Tools and check the Debug box. 
4. Submit the pick release. 
5. Provide the Pick Selection List Generation log file (View > Requests > Find > click on View Log... for the appropriate file), the file displayed in Step 3. 
6. Reset profile options in Step 1. 

    F. To generate a debug for Interface Trip Stop - SRS:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5
     WSH: Debug Enabled - set to Yes
     INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement
     INV: Debug Level - set to 11 
3. Set the Log Level parameter to 1 (Debugging ON) 
4. Submit the job. 
5. Provide the Interface Trip Stop log file (View > Requests > Find > click on View Log... for the appropriate file). 
6. Reset profile options in Step 1. 

   G. To generate a debug for an API:

1. Following Profile Options need to be set before each test case, then reset after completion:
     OM: Debug Level - set to 5
     WSH: Debug Enabled - set to Yes
     INV: Debug Trace - set to Yes 
2. The following Profile Option once set do not need to be changed.
     WSH: Debug Level - set to Statement
     INV: Debug Level - set to 11 
WSH: Debug Log Directory
select value from v$parameter where name = 'utl_file_dir'
3. Add the following line of code in the wrapper script which calls the API: 
oe_debug_pub.initialize; oe_debug_pub.SetDebugLevel(5); DBMS_OUTPUT.PUT_LINE('Debug File = ' ||OE_DEBUG_PUB.G_DIR||'/'||OE_DEBUG_PUB.G_FILE);
4. Submit the job. 
5. Provide the log file 
6. Reset profile options in Step 1.

REFERENCES

NOTE:183274.1 - 11i : Applications DBA RDA Data Collection Test
NOTE:276207.1 - Diagnostics : Apps Check [Video]
NOTE:463673.1 - R12.0.[3-4] : Oracle Order Management Sales Order Setup Test
NOTE:133464.1 - HTMOMSE Sales Order Diagnostic Script 
NOTE:1358154.1 - Diagnostics : WSH Shipping Forms Debugging [Video]
NOTE:1358164.1 - Diagnostics : WSH Pick Release Debug [Video]

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
In Android, Looper and Handler work together to execute tasks on a separate thread, also known as a background thread. A Looper is an object that allows a thread to handle incoming messages or tasks. It runs in an infinite loop, waiting for new tasks to arrive. When a new task arrives, the Looper dispatches it to the appropriate Handler for processing. A Handler is an object that receives tasks from the Looper and processes them. It is associated with a specific thread, and when a task is sent to a Handler, it is added to a message queue. The Handler processes the tasks one by one, in the order they were added to the queue. Together, the Looper and Handler allow us to perform time-consuming tasks on a separate thread, without blocking the main thread. The main thread is responsible for handling UI events, and if it is blocked by a long-running task, the user interface will become unresponsive. By using Looper and Handler, we can keep the main thread free to handle UI events while executing time-consuming tasks on a separate thread. Here is an example of how Looper and Handler work together: ``` public class MyThread extends Thread { public Handler handler; @Override public void run() { Looper.prepare(); handler = new Handler() { @Override public void handleMessage(Message msg) { // Process the task here } }; Looper.loop(); } } ``` In this example, we create a new thread called `MyThread`. In the `run()` method, we create a new `Looper` and call `prepare()` to initialize it. We then create a new `Handler` and associate it with the thread. Finally, we call `Looper.loop()` to start the infinite loop and wait for tasks to arrive. To send a task to `MyThread`, we can use the `handler` object: ``` MyThread myThread = new MyThread(); myThread.start(); Message msg = myThread.handler.obtainMessage(); msg.obj = "Hello"; myThread.handler.sendMessage(msg); ``` In this example, we create a new message and set its `obj` property to `"Hello"`. We then send the message to `MyThread` using its `handler` object. When the message arrives, the `handleMessage()` method of the `Handler` will be called, and we can process the task there.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值