JDE F0911 Table Growth Forecast Calculator
F0911 is the Account Ledger in JD Edwards, and for most customers it is among the largest tables because every posted journal line lands there. This forecast tells you when it will outgrow its storage so archive and purge work can be planned, not rushed.
Your numbers
Each line is one F0911 row.
Assumed figure. Get yours from the DBA: table size divided by row count.
Total segment size including indexes divided by data size.
Your results
Sizing estimate in GB (decimal). Row size varies with description and remark fields, so calibrate with your own database statistics.
Projected F0911 size vs years
Sweeps Forecast horizon from 1 to 10, holding your other inputs fixed.
Archive strategy outline
Optional: get a short outline for archiving and purging high-growth JDE tables.
Optional. The tool and every export work without this. No spam.
How to use it
Count journal documents per day from the Account Ledger by document type or from posting statistics, and enter average lines per document. Take row size from database statistics rather than guessing. Set annual growth from the past two years of row counts. The chart shows the projected total for each horizon so you can pick the year you cross capacity.
The method
Year one rows are documents times lines times days. Bytes are rows times row size times the index multiplier. Later years grow by the volume percentage, so total added over N years is the first-year amount times the geometric sum. Add that to current size to get the projection.
- Include indexes; they can rival the data itself.
- Add related tables such as F0902 separately.
- Remember database logs and backups scale with it.
Reading the result
If headroom turns negative inside three years, start the archive design now. Archiving needs agreement on retention with finance and audit before anyone deletes rows. Also plan for what reports still need prior-year detail, because purging without checking those reports is how month-end surprises happen.
Frequently Asked Questions
Does F0911 include all my GL activity?
It holds the detail transaction lines. Balances live in other tables such as F0902, which you should size separately because their growth pattern differs.
How do I find my row size?
Ask your DBA for the table's allocated size and row count, then divide. Include index segments separately to derive your own multiplier.
Can I just archive old years?
Often yes, but only after finance, audit and reporting owners agree on retention and you confirm no report depends on the archived rows.
Is growth really geometric?
It is a reasonable approximation when volume grows by a steady percentage. Acquisitions or new modules cause steps that this model will not predict.
Netray can help scope archive and purge options and the reports that depend on historical ledger rows.
Related Tools
JDE UBE Batch Window Calculator
Model UBE elapsed time against your batch window as you add parallel queue slots, including a contention penalty for each extra slot.
ERP Migration & SelectionJDE Cutover Data Load Time Calculator
Build the cutover weekend timeline: load hours from row counts and streams, plus index rebuild, validation and a contingency buffer.
OracleJDE HTML Web Server JVM Sizing Calculator
First-pass sizing of JDE web server JVM count from logged-in users, memory per session and heap, with an N+1 spare.
OracleJDE UBE Runtime Baseline Log Worksheet
An editable log of UBE runs with computed throughput, so you can compare before and after a tools release, database or hardware change.
More Oracle tools
See all- JD Edwards Document Types Reference (OP, SO, OV, PV)
- JD Edwards UBE Job Scheduling Worksheet
- JD Edwards Table Reference (F4211, F4311, F0101, F4101, F4102)
- JD Edwards Tools Release Upgrade Checklist
- JD Edwards Orchestrator Design Template
- JD Edwards Security Workbench Worksheet
- JD Edwards Environment Refresh Runbook Template
- JD Edwards UBE Runtime Log Worksheet
- JD Edwards Next Numbers Capacity Worksheet
New to JD Edwards EnterpriseOne? Start with the JD Edwards EnterpriseOne guide and toolkit, or plan with Training Path Builder, Upgrade Path Planner, ERP Table and Field Explorer.
Keep exploring
Free tools
- JD Edwards F0911 General Ledger SQL GeneratorFill in schema, company, ledger type and a Julian date range to get ready-to-run SQL for F0911 detail and an account summary.
- JD Edwards Batch Window Runtime CalculatorEstimate how long a JDE UBE will take from record volume, throughput and parallel runs, and test whether growth will break the batch window.
- Oracle EBS Database Growth Forecast CalculatorProject EBS database size from monthly growth and a one-time purge, and see how many months of storage headroom remain.
ERP fixes and how-tos
- JD Edwards GL Post: Batch in Error or Out of BalanceFix a JD Edwards batch that will not post: read the R09801 post report, check batch status in P0011, correct F0911 rows, and reset a batch stuck in posting.
- JD Edwards Supplier Scheduling: Setting Up and Releasing Supplier SchedulesHow supplier scheduling works in JD Edwards: blanket orders, MRP-driven schedules, releasing forecasts to suppliers and the setup needed, with common pitfalls.
- JD Edwards table conversion: how it works and how to run oneWhat a JD Edwards table conversion does to a JDE table's structure and data, when it runs in a package build, and how to run or design one manually.
Runs with your ERP
- Oracle CPQ and JD Edwards EnterpriseOne: quote to sales orderHow Oracle CPQ integrates with JD Edwards EnterpriseOne: customer data into quotes, sales orders created from quotes, and status back, with setup and pitfalls.
- Vertex Tax Connectors with JD Edwards EnterpriseOneHow Vertex calculates sales, use and VAT tax for JD Edwards EnterpriseOne and World, plus Oracle EBS and Cloud ERP: integration model, flows, setup, pitfalls.
- Prometheus Planning & Scheduling with JD Edwards EnterpriseOne maintenanceHow Prometheus Group's planning and scheduling tool works with JD Edwards EnterpriseOne maintenance: Gantt scheduling, time confirmation, setup and pitfalls.
AI on your ERP
- AI for JD Edwards Inventory Management and Shop Floor ManufacturingAI on JD Edwards EnterpriseOne inventory and manufacturing: item ledger, work orders, MRP messages and cost variances, answered in plain English on your own servers.
- AI for JD Edwards EnterpriseOne, Built on Orchestrator and AISAdd AI to JD Edwards E1 9.2 using Orchestrator, AIS, and BSSV rather than screen-scraping. Ground a private LLM on F4211, F4111, and F0411 data.
Integrations
- How to use ChatGPT with JD Edwards EnterpriseOneHow to use ChatGPT with JD Edwards EnterpriseOne: custom GPT actions over AIS, exports versus live access, enterprise data controls, and private alternatives.
- How to add AI agents to JD Edwards EnterpriseOneHow to add AI agents to JD Edwards EnterpriseOne: Orchestrator and AIS as the tool layer, read-only first, human approval on writes, on-prem models.