Query to fetch incremental data/delta data/ESS job last run date

 Query to fetch incremental data/delta data/ESS job last run date

WHERE last_update_date > (

select  

  max(R.COMPLETEDTIME)

from 

  (

    select 

      v1.requestid, 

      v1.value report_path 

    from 

      fusion.ess_request_property v1 

    where 

      1 = 1 

      AND v1.name LIKE 'report_url' 

      AND v1.value = '/Custom/Pavani/EFACost_Report.xdo' — replace report name 

  ) F1, 

  (

    select 

      v2.requestid, 

      v2.value job_name 

    from 

      fusion.ess_request_property v2 

    where 

      name = 'ujobname' 

      and value = 'FA' — replace your job name 

  ) F2 ,

  ess_request_history r 

where 

  F1.requestid = F2.requestid 

  AND F1.requestid = r.requestid

  AND EXECUTABLE_STATUS='SUCCEEDED'

  

  )