Oracle E-Business Suite - Concurrent Request Monitoring and Alert Reporting
Concurrent Request Management
Critical concurrent requests should be monitored at all times to prevent problems in downstream processes. The standard method is to use Oracle Alert and email the output to the support or database teams. Other techniques involve running SQL with time based schedules handled by Cron.
The alert method is somewhat out-dated, emails are in text format and Excel exception files cannot be sent.
In this video blog tutorial we cover the standard exception reporting method from the Blitz Report team at Enginatics. Blitz Report is seeded with several database and system administrator reports that facilitate monitoring and performance tuning of Oracle E-Business Suite applications.
The parameters of the report have been developed to pinpoint problematic concurrent requests, allowing inclusion and exclusion of specific programs with the output Excel file emailed to the relevant teams in order to take expatiate actions.
Blitz Report Output and Scheduling
Once the report is run, it will be submitted via the concurrent manager and the Excel report will open immediately. Since the Blitz Report is a standard concurrent request program it is available for scheduling submission. For tracking of failing requests, we would advocate sending the request output to the supporting teams on a schedule that befits the programs that you need to monitor.
Utilization of the incremental parameter will ensure that the repeat requests will only report problematic requests since the last run of the Blitz Report - FND Concurrent Requests. There are a number of FND and DBA monitor requests that are seeded with the Blitz Report. These can be found in our library here:
Evaluation
To evaluate any of the above reports:-
Download and install the free version of Blitz Report. We think the best way to find out what Blitz Report can do for your business is a live demonstration available: https://www.enginatics.com/request-demo/.
Depending on your location we can schedule an onsite appointment or a remote video call. Or in the meantime, you can review the short video overview below.
The Blitz Report™ software is free to use for your first 30 reports, you can plan a 30 minutes guided installation with the team at www.enginatics.com
The Oracle E-Business Suite - Concurrent Request Monitoring and Alert Reporting blog is available here: https://www.enginatics.com/blog/oracl...
