Oracle EPM Cloud MCP Server

@fmepm

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

fmepm

投稿者

Fred Mamadjanov

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

Oracle EPM Cloud MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

Oracle EPM Cloud MCP Server のツール

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

概要

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

よくある質問

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.

「データベース」の他のコンテンツ

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.