Forum Stats

  • 3,875,896 Users
  • 2,266,986 Discussions


How to fetch ESS Job Details as a BIP Report.

Currently in our Project reports are delivered through bursting process. So our requirement is to create a BIP report which having columns like

1) 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.