# Oracle EBS Concurrent Program Load Planner Worksheet > Source: https://netray.co/tools/oracle-ebs-concurrent-program-load-planner-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List your scheduled concurrent programs with runtime and frequency, then see total busy minutes and the processes needed to carry the load. ## Category oracle ## Erp Oracle E-Business Suite ## Audience - EBS DBA - Batch scheduler - Oracle applications administrator ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Concurrent program **Key:** program **Type:** text #### Manager queue **Key:** manager **Type:** text #### Owner **Key:** owner **Type:** text #### Avg runtime **Key:** runtime_min **Type:** number **Unit:** min #### Runs per day **Key:** runs_per_day **Type:** number #### Busy minutes per day **Key:** daily_min **Type:** number **Expr:** runtime_min * runs_per_day **Format:** number #### Avg busy processes **Key:** avg_procs **Type:** number **Expr:** runtime_min * runs_per_day / 1440 **Format:** decimal **Rows:** **Program:** Import Journals **Manager:** Standard Manager **Owner:** GL **Runtime min:** 12 **Runs per day:** 6 **Program:** Autoinvoice Master Program **Manager:** Standard Manager **Owner:** AR **Runtime min:** 25 **Runs per day:** 4 **Program:** Payables Open Interface Import **Manager:** Standard Manager **Owner:** AP **Runtime min:** 18 **Runs per day:** 8 **Program:** Create Accounting **Manager:** Standard Manager **Owner:** SLA **Runtime min:** 40 **Runs per day:** 3 **Program:** Workflow Background Process **Manager:** Workflow Agent Manager **Owner:** Technical **Runtime min:** 5 **Runs per day:** 96 **Program:** Gather Schema Statistics **Manager:** Standard Manager **Owner:** DBA **Runtime min:** 180 **Runs per day:** 1 **Totals:** #### Total busy minutes per day **Key:** daily_min **Agg:** sum **Format:** number #### Total average busy processes **Key:** avg_procs **Agg:** sum **Format:** decimal **Summary:** #### Processes for 70% utilization **Key:** suggested **Expr:** ceil(sum_avg_procs / 0.7) **Format:** integer **Primary:** true **Description:** Average load only. Peaks need more. #### Processes with 3x peak factor **Key:** peak_factor **Expr:** ceil(sum_avg_procs * 3 / 0.7) **Format:** integer **Description:** Rough allowance if work clusters into a third of the day. **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use it **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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. **Bullets:** - Retire schedules that no one reads output from. - Spread top-of-the-hour jobs across minutes. - Review after every quarter-end. **Cta:** 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. **Faq:** #### Where do I get the list of scheduled programs? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms concurrent program schedule template, oracle ebs batch schedule worksheet, oracle ebs concurrent program list excel, concurrent processing capacity planning, ebs batch window planning, oracle apps scheduled requests inventory, concurrent manager workload planning --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json