EPMONEBook a call

Insight · Public sector

Public sector budgeting on Oracle EPM Cloud: Planning, Narrative Reporting, and loads that run themselves.

Municipalities, universities, and other public bodies moving off Hyperion tend to ask which parts of the old system will come across. It is the wrong starting question. Whatever they ran before, the platform that serves them well afterwards looks the same: Planning for the budget, Narrative Reporting for the budget book and council or board reports, and data from the ERP that arrives on its own every night and on demand, logged and archived.

What that platform is, why each part matters to a public-sector finance team, and how to get there from Hyperion. By Neil Perejma, .

What the finance team needs

  • A budget built department by department, approved by council or the board, and reforecast through the year.
  • A budget book and council or board reports where the words and the numbers agree, every time they are reprinted.
  • Actuals from the ERP that are current when someone asks, not as of last month's upload.
  • An answer for the auditor about where every number came from.
  • All of it run by a small finance systems team, often one or two people.

The last point shapes the rest. A platform that needs someone to run loads by hand, rebuild reports for each reprint, or dig through folders when audit asks a question does not last with a team that size.

The platform, in three parts

  • Planning for the budget and forecast. Operating and capital budgets, forecasts, and the scenarios council asks for, built by departments in forms and Smart View and rolled up for finance. One application, designed for how the organization budgets now rather than how the old system was set up.
  • Narrative Reporting for the budget book and council reports. Oracle describes report packages as a way to structure a report, assign its sections to authors and reviewers, and manage the workflow that produces one document. Each department writes its own section; finance reviews; the package is signed off and published. The tables come from Planning, so the text and the numbers stay in step when the budget changes late.
  • Loads that run themselves. EPM Automate runs on a dedicated server, pulls actuals and other data live from the ERP, and pushes them through to Planning every night, with no one clicking anything. The same process runs on demand when finance needs fresh numbers during budget season. Every run is logged, every file is archived, and a failed load sends an alert in plain English before anyone opens a report.

Sources: Oracle, What is a Report Package?; Oracle, EPM Automate runIntegration.

Why the automation is what makes it last

Planning and Narrative Reporting are what people see. The loads underneath are what decide whether the platform is still trusted three budget cycles later.

Audit.When every run is logged and every file archived, the answer to “where did this number come from, and when?” is a lookup, not an investigation.

Budget season. Departments want current actuals in the week the budget is built. An on-demand run gives them that without anyone staying late to load files.

A small team. Nightly loads that check themselves and alert only on real problems free the one or two people who run the platform for the work finance actually needs. They also mean the platform keeps running when one of those people is on holiday or moves on.

Oracle’s monthly updates. Oracle updates the platform every month. Loads that report exactly what ran and what failed make it obvious when an update has changed something.

Getting there from Hyperion

Public Sector Planning and Budgeting can’t be migrated. Oracle lists it among the horizontal Planning modules its migration tools cannot move, alongside Workforce Planning and Capital Asset Planning. Public bodies that budgeted on it redesign the budget on Planning rather than copying it, and carry across the history they need as data.

FDMEE and batch scripts are replaced, not moved. The automation above takes their place: one set of loads, run from one server, logged the same way.

Financial Reporting goes too. Oracle removes Financial Reporting from Oracle EPM Cloud in the February 2027 update, so Hyperion reports go straight to Reports and the budget book to Narrative Reporting.

Time it around the budget. The move typically takes three to six months, depending on needs and requirements. Starting just after a budget is approved gives the most room, and old and new run side by side through a budget or forecast cycle before Hyperion is switched off.

Source: Oracle, Modules and Applications Not Supported. More detail in Hyperion to Oracle EPM Cloud migration: what it actually involves.

An example: the City of Regina

EPM ONE moved the City of Regina’s budgeting and planning from Hyperion to Oracle EPM Cloud, and has looked after the platform for several years since. A nightly process built around EPM Automate checks the jobs, data, and security that have failed before and alerts on real problems; valid intersections are kept clean across budget cycles; and the same people look after the platform from one cycle to the next. Council briefings go ahead without last-minute fixes.

Read the Regina case study.

If you’d like help

EPM ONE moves public-sector budgeting off Hyperion and onto Oracle EPM Cloud, builds the loads that run themselves, and looks after the platform afterwards.

Questions

Can Public Sector Planning and Budgeting be migrated to Oracle EPM Cloud?
No. Oracle lists Public Sector Planning and Budgeting among the horizontal Planning modules its migration tools cannot move to Oracle EPM Cloud. The budget is redesigned on Planning, and the history the finance team needs is carried across as data.
What replaces the budget book?
Narrative Reporting. A report package splits the budget book into sections, assigns each to its authors and reviewers, and takes it through review and sign-off to one published document, with the tables pulled from Planning.
What does hands-free loading mean in practice?
EPM Automate runs on a dedicated server and pulls data from the ERP into Oracle EPM Cloud every night and whenever finance asks, without anyone running it by hand. Every run is logged and every file archived, and a failure raises an alert before anyone uses the numbers.
How long does the move from Hyperion take?
Typically three to six months, depending on needs and requirements. The go-live is timed around the budget calendar so old and new can run side by side through a budget or forecast cycle.
Do finance users keep Smart View?
Yes. Smart View works with Oracle EPM Cloud, so departments and finance keep working in Excel.

Related