Currently in our Project reports are delivered through bursting process. So our requirement is to create a BIP report which having columns like
- Report Name, 2) Report Delivery Status ,3) If failed, How many reports are failed in number, 4)If Success, How many are successfully delivered in number, 5)Process Start date, 6)Process End date, 7)ESS Job ID, 8)Error details.
I have queried ess_request_property, ess_request_history, fusion_ora_ess.request_property_view, fusion_ora_ess.request_history_view these table but unable to find all the details mentioned above.