Oracle EPM Cloud MCP Server

Created By
fmepm2 months ago
Connect AI agents to Oracle EPM Cloud (Planning, PBCS, EPBCS) via REST APIs. Automate month-end close, run business rules, manage substitution variables, refresh databases, export data slices, and monitor job status through natural language. Supports mock mode for testing without an EPM environment. Built by Fred Mamadjanov, Oracle ACE and EPM Solution Architect.
Overview

Oracle EPM Cloud MCP Server

Connect Claude AI (or any MCP-compatible client) to Oracle EPM Cloud via REST APIs.

What You Can Do

Ask your AI agent to perform Oracle EPM operations in natural language:

  • "What applications are in my EPM environment?"
  • "Show me the current substitution variables"
  • "Run the Agg_AllData business rule"
  • "Export Q1 revenue data for North America"
  • "Roll the current month forward from Mar to Apr"

Available Tools

  • get_api_version — Test connectivity and discover API versions
  • list_applications — List all EPM applications
  • get_substitution_variables — Read current month, year, scenario variables
  • run_business_rule — Execute a calc script or business rule
  • check_job_status — Poll whether a job completed or errored
  • export_data_slice — Pull data from the cube by dimension members
  • update_substitution_variable — Change a substitution variable value

Use Case: Month-End Close Automation

The server enables AI-driven automation of the monthly close cycle — check the current period, run aggregation rules, validate data, roll the period forward, and confirm. The same workflow finance teams do manually each month, now executable through conversation.

Mock Mode

Runs out of the box without an Oracle EPM environment. Mock mode returns realistic sample data so you can test the full workflow before connecting to a live system.

Built By

Fred Mamadjanov — Oracle ACE, EPM Solution Architect | fmepm.com

Server Config

{
  "mcpServers": {
    "oracle-epm-cloud": {
      "command": "node",
      "args": [
        "/path/to/oracle-epm-mcp-server/index.js"
      ]
    }
  }
}
Project Info
Created At
2 months ago
Updated At
2 months ago
Author Name
fmepm
Star
-
Language
-
License
-
Category

Recommend Servers

View All
Bring your real authenticated browser session to AI coding agents. Local-first MCP server + Chrome MV3 extension. No cloud. No telemetry.
@Cubenest

peek records the user's actual logged-in browser (DOM via rrweb, console events, network metadata, optional response bodies via opt-in Deep capture) through a Chrome MV3 extension. The extension ships events through a native-messaging stdio bridge to a local MCP server (peek-mcp), which persists them to a SQLite database at ~/.peek/sessions.db. AI coding agents (Claude Code, Cursor, Cline, Windsurf) read sessions from the database via 10 MCP tools: Tool What it does list_recent_sessions List recently recorded sessions (id, origin, ts, event count). get_session_summary LLM-readable narrative summary of a session. get_session_console_errors Console errors recorded in a session. get_session_network_errors Failed/notable network requests in a session. get_user_action_before_error Last N user actions before a console error. generate_playwright_repro Generate a runnable Playwright test from a session. get_dom_snapshot Reconstruct the DOM at a given timestamp. query_dom_history Timeline of attribute/text changes for a selector. request_authorization Side-panel consent for write actions (Level 3). execute_action Dispatch a UI action (gated by permission level + destructive blocklist). Why local-first matters Every other "browser session for AI" tool ships to a vendor cloud. peek's SQLite + extension live on the user's machine — no remote endpoints, no telemetry. The privacy policy (docs/peek/PRIVACY_POLICY.md) is the source of truth. Install # 1. Add the MCP server to Claude Code claude mcp add peek -- npx -y @peekdev/mcp # 2. Install the Chrome extension from the Chrome Web Store # (link added once the CWS listing is approved)

6 hours ago
Tavily Mcp
@tavily-ai

JavaScript
a year ago