EPM Commander
The AI-powered command center for Oracle EPM Cloud — inside Excel. Administer, analyze and optimize your Planning and FCCS environments without leaving the tool your finance team already lives in.
EPM Commander turns a full Oracle EPM Cloud administration suite and an agentic AI assistant into one ribbon. Manage security, metadata, jobs, journals and integrations directly against the REST API — and let AI investigate performance issues, explain business rules, detect security drift, and answer questions about your data in plain language.
An agent that works where you already work.
Not a chatbot bolted onto a spreadsheet. The assistant calls real tools against your environment — and anything destructive stops for your approval first.
AI Assistant (Chat)
Floating, context-aware chat inside Excel, with a model picker in the header. Ask questions in natural language — the assistant fetches EPM data, runs variance analysis and forecasts, and writes results straight into new worksheets using native tool-calling. Any conversation exports as a PDF.
MCP Tool Integration
The assistant auto-discovers tools from connected MCP servers, so it extends to your own systems. Destructive or state-changing actions are classified automatically and gated behind human approval — nothing runs silently.
Right-Click, in the Grid
Three actions on the cell under the cursor. Inspect Member — metadata and where-used for that member, from the local snapshot. Security at This Intersection — which access rules govern the cell, and why a named user can or cannot write to it. Analyze with AI Assistant — send the selected range to the chat as context.
Bring Your Own LLM
Configure Claude, OpenAI or Gemini with your own API keys. Choose models per task, and track every token with the built-in AI Usage Monitor — total consumption plus full query history.
Captain’s Log — Diagnostic Agent
An AI agent that traverses your tool execution history to pinpoint the root cause when something goes wrong. Self-service supportability, without a ticket.
The real thing, not a mock-up.
Fifteen screens from a live environment — job runs, integrations, journals, rules, security and AI analysis. Drag, or use the arrows.
Job Monitor
Thirty days of runs in one view, with failures grouped by job and timing per job. You stop asking whether last night worked — you can see it, and you can prove it to an auditor.
Eight things SmartView, the web UI and EPMAutomate cannot do.
Everything else on the ribbon saves time. These change what the team is able to do at all.
Agentic AI, in the grid
Chat that calls the EPM REST API, runs the analysis and writes results into a worksheet.
Right-click intelligence
Inspect a member or audit security at an intersection — from the cell you are looking at.
Root-cause investigation
Activity Reports cross-referenced with Audit Records, Data Management logs, Job Console executions and Application Stats: this rule, this user, this window.
Security drift detection
Effective access and ACL hierarchies, with a plain-English account of what changed.
Neural Graph
Forms, rules and dimensions drawn as a dependency map before you change anything.
Rule Advisor
Calc Manager rules translated into plain English — and written, against the live outline.
Bring your own LLM
Your keys, your models, your data path — every token metered and logged.
MCP extensibility
The assistant discovers tools from your own systems, with approval gates on anything destructive.
Alongside SmartView — not instead of it.
SmartView retrieves the numbers. EPM Commander runs the application behind them. Different jobs, same Excel ribbon.
Smart View — data in and out of Excel via ad hoc grids, forms and submit. Keep it.
Web UI + EPMAutomate — administration, in a dozen browser tabs or a script someone maintains.
EPM Commander — administration and analysis from Excel. One ribbon, no scripting.
Both tabs sit on the same ribbon. SmartView keeps its job; EPM Commander does the work SmartView was never built for.
Thirty-plus tools. One ribbon.
Module-aware — controls appear according to the application type you're connected to.
Application Analysis
App Analysis ReportsAI — Eighteen application-aware report modules delivered as a branded PDF or to Excel — Full Report, Trends, Metadata, Configurations, Objects, Navigation Flows, Task Manager, Application Stats, App Diagnostics, Security, Audit Records, Artifact Change History, Integration Analysis and Job History, plus Approval Units for Planning and Close Cycle, Consolidation Design and Intercompany Matching for FCCS. Every AI-written narrative carries a mandatory disclosure stamp naming the model, the time and the environment.
Object Analysis — Trace application objects and their dependencies before you change anything.
Essbase Data Analysis (Block Analysis)AI-assisted — Scan BSO cubes for zero-value and empty blocks, browse an interactive POV block map with drillable hierarchies, and reclaim calculation performance.
Unused Metadata Analyzer — Identify unused and level-0 members in BSO cubes that bloat outlines and slow calcs.
Neural Graph — Interactive visualization of application objects and their relationships — see how forms, rules and dimensions connect.
IPM Insights AnalyzerAI-assisted — Parse application-generated IPM insights from snapshots, push any insight’s POV and metrics to a worksheet, and hand it to the AI agent to chase the root cause.
Release ReportAI — Oracle’s monthly What’s New fetched and each feature rated for its impact on this environment, with a portfolio overview across releases.
File Repository & Cloud Cleanup — Browse and manage stored files, and keep the cloud repository tidy with guided cleanup.
Operation Management
Performance InvestigatorAI — Root-cause analysis that cross-references Activity Reports with Audit Records, Data Management logs, Job Console executions and Application Stats, with an AI chat over the timeline, weekly digests and scheduled-job awareness — from “the app is slow” to “this rule, this user, this window.”
Performance Tracker — 120 metrics from Oracle’s own Activity Reports, charted over time with forecasts.
Rule AdvisorAI — Every Calc Manager rule listed and graded, translated into plain English — and new rules written against the live outline, diffable and exportable to Calculation Manager.
Job Monitor — How jobs actually ran over 7, 30 and 60 days, by rate: runs per day, success rate, failures grouped by job and time per job.
Job Orchestrator (Job Console) — Every job runnable from Excel or queued into an ordered sequence, with searchable member pickers for runtime prompts and last-used values remembered. Runs never freeze Excel.
Audit Log Analyzer — An incremental local audit history — delta sync fetches only what is missing — with record-field filters on the grid and a chat over the records.
Snapshot Manager & Restore — Browse, download and govern backups. Restore Environment is the product’s one destructive operation; its button stays disabled until the confirmation word is typed.
Substitution Variables Manager — View, edit and delete sub vars across the application.
Data & Integration
Data Load Mappings Manager — Manage EPM Data Management mappings directly from Excel, with versioned automatic backup. Syntax is validated against Oracle’s predefined rules, and a REPLACE shows what will be overwritten first.
Integration Pipeline Graph — Every pipeline visualized end to end — source system, location, import format and load rule on one screen. The funnel view shows mismatched records between source and target, so any “short load” is explained in seconds.
Integration AgentAI — Import, transform and export as a funnel with inline kickouts and a trend chart, a safe re-run of a load rule, and a chat over the Data Management logs — failures and anomalies surfaced before users report them.
System & Security
Security AgentAI — Detect and explain security drift: what changed in permissions over time, with history and related impact — audit reporting, simplified.
AI-Assisted ProvisioningAI — Ask the assistant to create the group and add the members — then validate the change before it runs.
Metadata Security Report — Object Access, Effective Access, Security Changes and Group Cleanup in one report, each exportable to Excel — with the Excel-based SEC editor sheet.
Group Cleanup — Which groups can safely be deleted, traced through membership, object ACLs, role assignments, approval units, navigation flows and Task Manager. Only SafeToDelete is actionable; a check that did not run says Unknown. It fails closed.
Submit SEC Sheet — Validate the SEC editor sheet and run Oracle’s Import Security job for rows marked Add / Update / Remove — provisioning at spreadsheet speed.
Bulk Security Assignment — Manage security assignments in bulk instead of one-by-one clicking.
License Auditor & Deprovisioning — Audit user licensing, review activity, and deprovision users from the application or the identity domain.
Enterprise Sign-In — OAuth, MFA and identity-domain login flows; encrypted local credential storage; multi-environment connection manager.
Planning Controls
Planning Approvals Manager — Approval units merged from the snapshot and live REST, so group-owned units the API alone will not return are shown. Status KPI cards and filters, the promotion path including group-owned nodes, comments attached to the action, and export to Excel as two filterable tables.
FCC Controls
Validate Metadata — Run FCCS metadata validation via REST and review results in place.
Manage Journal Periods — Open and close journal periods from a dashboard view.
E-Journal Details — Search, drill to the line, then submit, approve, post or unpost through the REST API — with POV fields backed by the application’s own metadata.
FCC Admin Console — Intercompany Matching Reports over a Year + Period range, consolidation runs, Clear / Copy Data profiles, and consolidation ruleset export and import.
Intercompany Matching Analysis — Gross and net imbalance per plug group, the entities and partners carrying it, unmatched pairs ranked largest first — one-sided breaks separated from genuine disagreements. Computed, not model-written: complete without an AI provider.
Integration Command Center
Every pipeline on one screen — managed before it breaks, not diagnosed after.
- Every Data Management integration on one screen: source system, location, import format and load rule
- The funnel view shows mismatched records between source and target — any “short load” is explained in seconds
- Mappings are managed from the grid, with versioned automatic backup
- The Integration Agent reads the integration logs and surfaces failures and anomalies before a user reports them
- Syntax is validated against Oracle’s predefined rules — and a REPLACE shows what will be overwritten first
Application Analysis Reports
Corporate branding outside, required evidence inside — application reviews you can hand to stakeholders, reviewers and auditors.
- AI-generated application reviews, scored against Oracle EPM Cloud design best-practice metrics and delivered as PDF
- Eighteen selectable, application-aware modules — from Application Stats, Security and Audit Records to Artifact Change History, Job History, Close Cycle and Intercompany Matching
- Branded templates to suit corporate format requirements
- Every AI-written narrative carries a disclosure stamp — which model wrote it, when, and from which environment. It cannot be switched off, which is exactly what reviewers demand
For IT — access you can defend.
- A local Excel VSTO (COM) add-in — no server component, no agents inside Oracle EPM Cloud
- Oracle EPM and LLM credentials stored encrypted in the local Windows profile
- No Captain-EPM telemetry: application data goes directly to your Oracle EPM environment, and AI traffic only to the provider you configure
- Talks to Oracle through the documented REST API as an ordinary client — nothing changes when Oracle applies its monthly patches
- Every mutating call — user- and AI-driven — is recorded automatically with the target, the outcome and the timestamp, filterable in Captain’s Log and exportable to Excel
- The add-in can do only what the signed-in EPM user can already do; AI write tools are gated behind explicit approval, and read-only mode withholds them from the model entirely
What does it give back?
Put your own headcount in. Every assumption behind the number is open and deliberately conservative — the full calculator lets you change all sixteen.
Supported versions & prerequisites
- Windows 10 or Windows 11, 64-bit
- Microsoft Excel 2016, 2019, 2021 or Microsoft 365 — Windows desktop edition (VSTO); not Excel for Mac or Excel on the web
- .NET Framework 4.8, the VSTO Runtime and the Microsoft Edge WebView2 runtime (preinstalled on Windows 11)
- Per-machine installer — administrator rights required; update notifications arrive in the ribbon
- Oracle EPM Cloud (Planning, FCCS) via the official REST APIs; Service Administrator recommended for the full toolset
- Zero external telemetry — your data stays in your environment
AI features use your own LLM API keys — your data is sent only to the provider you configure.
Ready to take command?
Request access, or book a demo and we'll walk your environment with you.