http://systemadministratorsys.blogspot.com/2016/12/fsg-report-last-run-date.html
FSG Report Last run date
select * from fnd_concurrent_requests bb, fnd_concurrent_programs_vl jj, RG_REPORTS_V cc
where bb.CONCURRENT_PROGRAM_ID = jj.CONCURRENT_PROGRAM_ID
and cc.REPORT_ID = bb.ARGUMENT7
and jj.USER_CONCURRENT_PROGRAM_NAME = 'HUBCO Program - Publish FSG Report'
order by bb.REQUEST_ID desc
FSG Report Last run date
select * from fnd_concurrent_requests bb, fnd_concurrent_programs_vl jj, RG_REPORTS_V cc
where bb.CONCURRENT_PROGRAM_ID = jj.CONCURRENT_PROGRAM_ID
and cc.REPORT_ID = bb.ARGUMENT7
and jj.USER_CONCURRENT_PROGRAM_NAME = 'HUBCO Program - Publish FSG Report'
order by bb.REQUEST_ID desc
No comments:
Post a Comment