Implementing Incremental Logic for Scheduled Blitz Reports

You can restrict the query to records modified since the previous scheduled request run by using a specific parameter SQL logic that references the concurrent request history. An example uses the request’s actual start date from the previous run.

A successful example uses a restriction like: `rctla.last_update_date >= (select fcr0.actual_start_date from fnd_concurrent_requests fcr, fnd_concurrent_requests fcr0 where fcr.request_id = fnd_global.conc_request_id and fcr.parent_request_id = fcr0.request_id)`.

By default, if a scheduled report retrieves zero data rows, Blitz Report suppresses the delivery of an empty output file. If you need empty files to be sent, you must set the profile option ‘Blitz Report Suppress Empty File Delivery’ to ‘No’.