Table of Contents
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 article we cover the standard exception reporting method from the Blitz Report team at Enginatics.
If you would like to try any of the steps below, login to our live demo instance and use the developer login.
Blitz Report also perfectly compliments the need for Excel output related to Oracle Enterprise Command Centers, we have an environment available on the same demo link above but instead use the login credentials of ecc/blitz
Blitz Report – FND Concurrent Requests
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.
Alert - Concurrent Requests - Parameters
Parameter | Multi-Select | Explanation / examples |
Concurrent Program Name | * | Autoinvoice Master Program;Planning Data Pull |
Concurrent Progr. (all languages) | ||
Concurrent Program Short Name | short name selection | |
Request Id | ||
Requested By | ||
Started within Days | 3 | |
Scheduled or Running | Set this to Yes to get a list of all currently scheduled or running requests | |
Waiting for x Minutes | use this for long waiting requests | |
Running longer than x Minutes | use this for long running requests | |
Phase | Completed, etc | |
Status | * | Error;Warning, etc |
Show Parameters Display Values | Shows parameter names and translated display values of request's parameter values. Please note that a setting to 'Yes' could slow down report execution significantly. | |
Show BI Pub & Delivery Options | Shows BI publisher and delivery options information such as the publisher template and output file, post processor result, delivery email or ftp information | |
Show active session SQL Text | Include an additional column with the SQL text. this might slow down the execution. The ID can be analysed by the a number of Blitz Reports such as DBA AWR SQL Execution Plan History | |
Parameter Text contains | allows selection of requests based on parameter text | |
Request Set Name | Use this if the request has a set name | |
Execution Method | e.g. submission methods such as Immediate, PL/SQL Stored Procedure, Java Concurrent Program, etc | |
Executable Short Name | ||
Running from Timestamp | Allows selection from a specific date - timestamp | |
Running to Timestamp | Allows selection unto a specific date - timestamp | |
Requested Start Date From | ||
Requested Start Date To | ||
Node | allows selection of the specific nodes that ran the requests | |
Manager Name | ||
Operating Unit | ||
Exclude Conc Program Name | exclusion list of programs | |
Incremental Alert Mode | Only show requests since the last scheduled report run |
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 repeat requests will not be reported every time the alert runs, instead the report will list only the latest problematic requests since the latest run.
There are a number of FND and DBA monitor requests that are seeded with the Blitz Report available in our library.
The report screen shots can be reviewed below, or you can review the actual file here:
Evaluation of Blitz Report
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.
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 enginatics.com