Oracle E-Business Suite – Concurrent Request Monitoring and Alert Reporting

Customer November 16, 2023 at 5:48 pm

We need to automate the distribution of sensitive operational reports generated nightly to various stakeholders via email or FTP. How can we configure automated delivery options, similar to BI Publisher, when running custom SQL reports via Blitz Report?

Viewing 10 reply threads

Author
Replies
- Support November 18, 2023 at 6:35 am
  When configuring your reports to run as concurrent requests, Blitz Report supports delivery options via its integration layer. For diagnostic visibility, the Concurrent Request Monitoring report specifically includes a parameter to Show BI Pub & Delivery Options.
- Customer November 18, 2023 at 6:39 pm
  What specific delivery details can be configured and monitored through this functionality?
- Support November 20, 2023 at 5:12 am
  When monitoring delivery options, you can view details such as the BI Publisher template used, the final output file name, the post-processor result, and crucial delivery details like the email or FTP information designated for distribution.
- Customer November 20, 2023 at 9:33 am
  If we set up automated email delivery for a report, and the email fails to send, how do we quickly identify and troubleshoot that failure?
- Support November 21, 2023 at 9:43 am
  The Concurrent Request Monitoring report allows you to filter requests by `Status` (Error or Warning) and check the `Phase`. If the delivery fails, the `Post Processor Result` and `Status` information contained within the delivery options details will indicate the failure reason, allowing the operations team to take immediate action.
- Support November 22, 2023 at 4:07 pm
  Blitz Report is recognized for delivering high-quality output. It generates reports that result in perfectly formatted Oracle EBS Excel reports , ensuring professional quality even for reports generated and sent automatically via email delivery.
- Customer November 24, 2023 at 10:59 am
  We need to ensure that the Excel reports sent via email are properly formatted and professional.
- Support November 25, 2023 at 7:48 pm
  Yes, while the primary focus is Excel, Blitz Report includes functionality to Generate PDF of Blitz Report™ output, often achieved via a post-processing step, which can then be included in the automated delivery options.
- Customer November 27, 2023 at 4:55 pm
  We are looking at pushing these reports to external cloud storage like SharePoint. Can the delivery options handle this directly, or does it require scripting?
- Support November 27, 2023 at 8:09 pm
  Standard delivery options generally focus on email or FTP. For transfer to external cloud platforms like SharePoint Online from the Linux server, the typically recommended technical approach is using a custom Python script for automation.
- Customer November 29, 2023 at 2:13 pm
  Does Blitz Report support PDF delivery for reports that require fixed, non-editable formats?
Author
Replies