Query to Get ESS Job history in Oracle Fusion Cloud - Orapoint

In this article, we’re going to discuss Oracle fusion tables. We can see the past of the old ESS workers from the Fusion application with the aid of this table. It is the same thing as the Find Concurrent requests table to find the user’s requested history of Concurrent Programs. The Oracle fusion Ess tables sql Query and Information Summary are below.

Important ESS Job Table in Oracle Fusion Cloud Application

ESS_REQUEST_HISTORY

ESS_REQUEST_PROPERTY

Query to Get ESS Job history in Oracle Fusion Cloud Application

SELECT r.requestid,
       username,
       processstart,
       processend,
       executable_status,
       v.name,
       v.value
FROM   fusion. ess_request_history r,
       fusion.ess_request_property v
WHERE  1=1
       AND r.requestid = v.requestid
       AND v.name LIKE 'submit.argument%'
ORDER  BY r.requestid,
          v.name;