Oracle Fusion ERP Architecture for Utilities
A finance architecture for energy and water utilities on Oracle Fusion ERP: separating corporate and regulatory reporting, handling capital projects at scale, and turning high-volume billing data into clean accounting.
Oracle ERP for Utilities · free
Why utilities need a different finance design
Two characteristics make utility accounting unusually demanding. First, utilities are asset intensive: networks and plants have lifecycles measured in decades, construction work in progress (CWIP) runs at large scale, and depreciation schedules are high volume. Second, they process very large transaction volumes from customer information systems (CIS), which have to be condensed into accounting journals without bloating the general ledger.
Dual ledgers: corporate and regulatory
Oracle Fusion's multi-ledger architecture lets a utility keep corporate and regulatory views of the same transactions:
- Primary ledger for corporate reporting under IFRS or US GAAP.
- Secondary ledger for regulatory reporting (such as FERC in the US) and tax books.
- Legal entities mapped to each operating utility company for statutory separation.
Chart of accounts design
| Segment | Purpose |
|---|---|
| Entity / company | The legal utility company, with its own balance sheet |
| Cost centre / department | Separates generation, transmission and distribution |
| Natural account | Aligned to the FERC Uniform System of Accounts for regulatory filing |
| Intercompany | Automated eliminations in multi-utility groups |
| Geography | Revenue and maintenance spend by service territory |
Aligning the natural account segment with the regulator's chart is the decision that makes regulatory reporting largely automatic later, because every balance in a filing can be traced straight back to source transactions.
Core subledgers
- Fixed Assets – acquisition to retirement, including the units-of-production depreciation common in heavy infrastructure.
- Project Portfolio Management (PPM) – tracks large capital work in progress and capitalises project costs directly into Fixed Assets.
- Procurement – spare parts and external maintenance services, with automated matching.
Financial Accounting Hub: from billing events to journals
For utilities, the Financial Accounting Hub (FAH) is the critical bridge between operational billing events and the general ledger. It ingests daily transaction files from the CIS, applies utility-specific accounting rules, and keeps full drill-back from the ledger balance to the original billing record. This is what lets the ledger stay summarised while the detail remains auditable.
Integration matrix
| Source system | Receiving module | Method | Purpose |
|---|---|---|---|
| Customer information (CIS) | Financial Accounting Hub | REST API / batch | Billing revenue transformation |
| Work & asset management | Procurement / Payables | Web services | Maintenance spend control |
| Meter data management | Receivables | Oracle Integration Cloud | Receivables posting |
| Project management | PPM Cloud | Native | Capital expenditure tracking |
A 15-month roadmap
- Design (months 1–3) – chart of accounts and enterprise structure.
- Build (months 4–8) – core financials and Subledger Accounting configuration.
- Integrate (months 9–12) – Financial Accounting Hub setup and CIS connectivity.
- Deploy (months 13–15) – user acceptance testing, training and go-live.
13 pages from our consulting practice.
Working on a project like this?
Vantage Finance & Tech helps companies across Italy and Europe with Oracle Fusion Cloud ERP Finance, SAP FI and S/4HANA Finance, and PMO support, from design through configuration and go-live.
Get in touch