Oracle EBS Concurrent Program Load Planner Worksheet
Batch schedules in EBS grow by accretion: one more scheduled request here, another there. This worksheet lists them with runtime and frequency so you can see total load and how many concurrent processes it takes.
| Concurrent program | Manager queue | Owner | Avg runtime (min) | Runs per day | Busy minutes per day | Avg busy processes | |
|---|---|---|---|---|---|---|---|
72 | 0.05 | ||||||
100 | 0.0694 | ||||||
144 | 0.1 | ||||||
120 | 0.0833 | ||||||
480 | 0.3333 | ||||||
180 | 0.125 |
Replace the sample rows with your own programs. Pull runtimes from FND_CONCURRENT_REQUESTS history. The averages assume load is spread across 24 hours, so use the peak factor row for batch windows.
Batch schedule review
Optionally send your schedule export and we will point out overlap and clustering.
Optional. The tool and every export work without this. No spam.
How to use it
Add one row per scheduled program, including the manager queue it runs in. Enter average runtime in minutes and runs per day. The sheet calculates busy minutes per day and the average number of processes that program keeps busy, which is busy minutes divided by 1,440. Totals show the whole schedule. The summary row gives a process count for 70% utilization, plus a version that allows for the work clustering into a shorter batch window.
- Include recurring workflow and interface jobs, not only reports.
- Group by manager queue to size specialized managers.
- Export to Excel to share with functional owners.
Method
Average busy processes equals runtime times runs per day, divided by the minutes in a day. Because 24 hour averages hide peaks, the worksheet scales by a peak factor. If most batch work lands in an 8 hour window, the factor is 3. Dividing by a target utilization of 0.7 leaves room for bursts and for ad-hoc user requests. This is a first-pass sizing, and the queue wait calculator in this series refines it for a single queue.
Using the result
Compare the suggested process count with the sum of target processes across your managers. If the batch window needs more than you have, look first at whether jobs can be moved earlier or later, whether incompatibilities force serial execution, and whether runtimes can be tuned. Raising target processes without checking database CPU and memory only moves the bottleneck. Keep this sheet current, and re-run it after each new module or interface goes live.
- Retire schedules that no one reads output from.
- Spread top-of-the-hour jobs across minutes.
- Review after every quarter-end.
Frequently Asked Questions
Where do I get the list of scheduled programs?
Query FND_CONCURRENT_REQUESTS for phase_code of P (pending) with a resubmit interval or a future start date, joined to FND_CONCURRENT_PROGRAMS_TL for names. The View Requests form also shows scheduled requests.
Why 70 percent utilization?
Queues lose responsiveness quickly above roughly 80 percent. Seventy percent leaves headroom for bursts and ad-hoc submissions. Change the value if your service-level goals differ.
Does this include user-submitted reports?
Only if you add them. Many sites keep a separate row for an estimated average of ad-hoc requests per day by manager to avoid undersizing the Standard Manager.
Can I export the worksheet?
Yes. Every worksheet exports to Excel, PDF and CSV from the page, so you can share it with application owners and attach it to a change request.
If you want your real schedule and runtimes pulled from EBS automatically and flagged for clustering and overlap, we can build that read-only over your own database.
Related Tools
Oracle EBS Concurrent Manager Queue Wait Calculator
Model average queue wait and utilization for a concurrent manager queue as you change the number of target processes.
OracleOracle EBS Database Growth Forecast Calculator
Project EBS database size from monthly growth and a one-time purge, and see how many months of storage headroom remain.
OracleOracle EBS Maintenance Window and Backup Time Calculator
Work out how long the outage needs to be, including a backup, the work itself, validation and a contingency buffer, and how long a rollback restore would take.
OracleOracle EBS AP Invoices on Hold SQL Generator
Fill in operating unit, lookback days and optional hold code to get ready-to-run SQL for unreleased holds in Oracle Payables.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS Concurrent Program Registration Request TemplateA request form that captures everything an EBS developer needs to register a custom concurrent program: executable, execution method, parameters, request group and incompatibilities.
- Oracle EBS Cycle Count Program Workload PlannerPlan ABC cycle counting: how many counts per year, per day and how many hours of counter time your frequency choices need.
- Oracle EBS Concurrent Program Parameters and Responsibility SQL GeneratorThree SQL queries for any concurrent program: definition and executable, parameters in order with value sets and defaults, and the request groups and responsibilities that can submit it.
ERP fixes and how-tos
- How to Register a Custom Concurrent Program in Oracle EBSRegister a custom Oracle EBS concurrent program end to end: build the executable, define the program and parameters, and add it to a request group so users can run it.
- Concurrent request completes with Warning and an FDPSTP messageFix Oracle EBS concurrent requests completing with warning and the FDPSTP post-processing message - check the request log for the real underlying program error before treating this as a display or printing issue.
- How to purge concurrent requests and manager data in Oracle EBSHow to schedule Purge Concurrent Request and/or Manager Data in Oracle EBS: the parameters, what is deleted, what else to purge, and mistakes that slow the system.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- BarTender and Oracle E-Business Suite: Label Printing from OracleHow BarTender prints labels from Oracle EBS using Oracle XML print requests and Integration Builder: methods, data flows, setup steps, pitfalls and AI help.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to connect Claude to Oracle E-Business SuiteConnect Claude to Oracle E-Business Suite via MCP, the Anthropic API, AWS Bedrock or Vertex, and know when an on-prem open-weight model is the better fit.