Monday, October 23, 2017

Query to Get Concurrent Program Execution Time Details

SELECT actual_start_date, actual_completion_date,
       (NVL (actual_completion_date, SYSDATE) - actual_start_date) * 24 * 60
  FROM fnd_concurrent_requests
 WHERE request_id = 108341096--Concurrent Request ID

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...