Introduction
This Post Provides the SQL Query to get Last Run Parameter Value in BI Report
Query
SELECT TO_DATE (SUBSTR (rpj.VALUE, INSTR (rpj.VALUE, ‘”}’) – 10, 10), ‘MM-DD-YYYY’) eff_date
FROM fusion_ora_ess.request_property rpu,
fusion_ora_ess.request_history rh,
fusion_ora_ess.request_property rpj
WHERE rpj.NAME = ‘report_params’
AND rpj.VALUE IS NOT NULL
AND rpu.VALUE = ‘/Custom/Human Capital Management/ReportName.xdo’
AND rh.executable_status = ‘SUCCEEDED’
AND rpu.requestid = rh.requestid
AND rpj.requestid = rh.requestid
AND rh.processstart =
(SELECT MAX (rh2.processstart)
FROM fusion_ora_ess.request_property rpu2,
fusion_ora_ess.request_history rh2,
fusion_ora_ess.request_property rpj2
WHERE rpj2.NAME = ‘report_params’
AND rpj2.VALUE IS NOT NULL
AND rpu2.VALUE =
‘/Custom/Human Capital Management/ReportName.xdo’
AND rh2.executable_status = ‘SUCCEEDED’
AND rpu2.requestid = rh2.requestid
AND rpj2.requestid = rh2.requestid)
To Know More about Post
Email : Doyen.ebiz@gmail.com
