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