Creating a custom concurrent manager in Oracle EBS

Customer July 29, 2024 at 3:22 pm

We need to create a dedicated custom concurrent manager in Oracle EBS to handle specific, high-priority reports and processes, isolating their workload from the standard managers. Where can we find comprehensive guidance on the necessary steps to set this up?

Viewing 10 reply threads

Author
Replies
- Support July 31, 2024 at 2:07 am
  The process for Creating a custom concurrent manager in Oracle EBS is a standard DBA task. This involves defining the new Concurrent Manager, assigning it a Service Instance, setting up its Workshifts, and associating specific Concurrent Programs with it to control workload execution.
- Customer July 31, 2024 at 7:27 pm
  After implementation, how can we efficiently monitor the workload and queue status of this new custom manager, specifically looking for backlog or long-running requests?
- Support August 1, 2024 at 3:40 am
  You should utilize the Oracle E-Business Suite – Concurrent Request Monitoring and Alert Reporting tool provided by Blitz Report. This diagnostic report allows filtering by the specific Manager Name.
- Customer August 3, 2024 at 1:01 am
  What technical parameters can we monitor using the Blitz Report tool to assess the health of the custom manager’s workload?
- Support August 3, 2024 at 10:27 pm
  The report parameters are granular. You can monitor key metrics such as `Scheduled or Running` requests, and filter based on elapsed time criteria like `Waiting for x Minutes` or `Running longer than x Minutes` to identify bottlenecks within the new manager’s workload and clear any potential backlog.
- Customer August 5, 2024 at 1:43 am
  We need the monitoring report to capture the parameters passed to the concurrent programs to troubleshoot failures.
- Support August 5, 2024 at 12:00 pm
  You can enable the `Show Parameters Display Values` setting in the alert report. However, note that setting this option to ‘Yes’ could significantly slow down the report execution, so use it judiciously for critical debugging rather than routine monitoring.
- Customer August 7, 2024 at 6:15 am
  If we discover an issue, can the tool also output the BI Publisher template or delivery options used by the failed request?
- Support August 8, 2024 at 10:43 am
  Yes, the report includes a parameter to Show BI Pub & Delivery Options. When enabled, this shows information such as the publisher template, output file, post-processor result, and delivery details (email or FTP information).
- Customer August 8, 2024 at 8:42 pm
  We need to ensure that the managers are correctly defined in the database before starting the custom service. What tables should a DBA confirm?
- Support August 10, 2024 at 6:00 am
  The DBA would typically query standard FND tables to verify the setup. For instance, diagnostic queries confirming the configuration of nodes and managers rely on details from tables accessed via the APPS user (e.g., querying `apps.fnd_nodes`) to confirm service mappings and node information.
Author
Replies