Keeping track of the last scheduled run for a BIP Scheduled Report

Question

Hi,

We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be fetching the delta of what happened after each run.

Kind regards,

Nick

gclampitt · Accepted Answer

hi just return data since the last run….something like…

AND creation_date  >=

(SELECT MAX (rh.scheduled)

FROM request_history rh,

fusion_ora_ess.request_property_view rpv

WHERE rh.requestid      = rpv.requestid

AND application       = 'FscmEss'

AND rpv.VALUE         = '/Custom/<report path>.xdo'