Oracle EPM Cloud MCP Server

Name: Oracle EPM Cloud MCP Server
Author: fmepm

@fmepm

About Oracle EPM Cloud MCP Server

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

#oracle-epm #mcp-server #oracle-cloud #financial-planning #oracle-pbcs #ai-agent #rest-api #claude-ai #month-end-close #epm-automate #fpa

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "oracle-epm-cloud": {
      "command": "node",
      "args": [
        "/path/to/oracle-epm-mcp-server/index.js"
      ]
    }
  }
}

Tools

Test connectivity and discover API versions

List all EPM applications

Read current month, year, scenario variables

Execute a calc script or business rule

Poll whether a job completed or errored

Pull data from the cube by dimension members

Change a substitution variable value

Overview

What is Oracle EPM Cloud MCP Server?

The Oracle EPM Cloud MCP Server is a Model Context Protocol server that connects AI assistants like Claude to Oracle EPM Cloud via REST APIs, enabling natural language operations on EPM applications.

How to use Oracle EPM Cloud MCP Server?

Run the server with any MCP-compatible client. It includes a mock mode that works without an Oracle EPM environment, returning realistic sample data, allowing you to test the full workflow before connecting to a live system.

Key features of Oracle EPM Cloud MCP Server

Integrates with Oracle EPM Cloud through REST APIs
Enables natural language queries and commands via AI
Includes mock mode for testing without a live environment
Provides tools to list applications, run business rules, and more
Supports month-end close automation workflows

Use cases of Oracle EPM Cloud MCP Server

Automate month-end close by checking periods, running aggregations, and rolling forward
Query EPM applications and substitution variables through conversation
Execute business rules and data exports on demand
Validate job status and troubleshoot from an AI interface

FAQ from Oracle EPM Cloud MCP Server

What can the server do?

It connects AI clients to Oracle EPM Cloud, allowing users to perform operations like listing applications, running business rules, and exporting data using natural language.

Does it require a live Oracle EPM environment?

No. The server includes a mock mode that returns realistic sample data, so you can test the complete workflow without connecting to a production system.

Who built the server?

The server was built by Fred Mamadjanov, an Oracle ACE and EPM Solution Architect.

What tools are available?

Tools include get_api_version, list_applications, get_substitution_variables, run_business_rule, check_job_status, export_data_slice, and update_substitution_variable.