Skip to main content
Glama
FCCS MCP Agentic Server

FCCS MCP Agentic Server

by ivossos

FCCS MCP Agentic Server

Oracle EPM Cloud Financial Consolidation and Close (FCCS) agentic server using Google ADK with MCP support.

Features

  • 25+ FCCS Tools: Full coverage of Oracle FCCS REST API

  • Dual Mode: MCP server (Claude Desktop) + Web API (FastAPI)

  • Memory & Feedback: PostgreSQL persistence with RL tracking

  • Mock Mode: Development without real FCCS connection

  • Bilingual: English and Portuguese support

Related MCP server: Oracle EPM Cloud MCP Server

Quick Start

Automated Setup:

.\setup-windows.bat

This will:

  • Create virtual environment

  • Install all dependencies

  • Create .env file from template

  • Guide you through configuration

Manual Setup:

  1. Create virtual environment: python -m venv venv

  2. Activate: .\venv\Scripts\Activate.ps1

  3. Install: pip install -e .

  4. Configure: Copy .env.example to .env and edit

  5. Initialize database: python scripts\init_db.py (if using PostgreSQL)

Quick Commands:

  • Start web server: .\start-server.bat

  • Start MCP server: .\start-mcp-server.bat

  • Install dependencies: .\install-dependencies.bat

  • Initialize database: .\init-database.bat

See WINDOWS_DEPLOYMENT.md for detailed Windows setup guide.

Linux/Mac

1. Install Dependencies:

pip install -e .

2. Configure Environment:

cp .env.example .env
# Edit .env with your settings

3. Run:

MCP Server (for Claude Desktop):

python -m cli.mcp_server

Web Server (for API access):

python -m web.server

Interactive CLI:

python -m cli.main

Claude Desktop Configuration

Add to %APPDATA%\Claude\claude_desktop_config.json:

{
  "mcpServers": {
    "fccs-agent": {
      "command": "python",
      "args": ["-m", "cli.mcp_server"],
      "cwd": "C:\\path\\to\\fccs-mcp-ag-server",
      "env": {
        "FCCS_MOCK_MODE": "true"
      }
    }
  }
}

API Endpoints

Endpoint

Method

Description

/

GET

Health check

/tools

GET

List available tools

/execute

POST

Execute a tool

/tools/{name}

POST

Call specific tool

/feedback

POST

Submit user feedback

/metrics

GET

Get tool metrics

Available Tools

Application

  • get_application_info - FCCS application details

  • get_rest_api_version - API version info

Jobs

  • list_jobs - List recent jobs

  • get_job_status - Job status by ID

  • run_business_rule - Execute business rules

  • run_data_rule - Execute data load rules

Dimensions

  • get_dimensions - List all dimensions

  • get_members - Get dimension members

  • get_dimension_hierarchy - Build hierarchy tree

Journals

  • get_journals - List journals

  • get_journal_details - Journal details

  • perform_journal_action - Approve, reject, post

  • update_journal_period - Update period

  • export_journals / import_journals

Data

  • export_data_slice - Export grid data

  • smart_retrieve - Smart data retrieval

  • copy_data / clear_data

Reports

  • generate_report - Generate FCCS reports

  • get_report_job_status - Async report status

Consolidation

  • export_consolidation_rulesets / import_consolidation_rulesets

  • validate_metadata

  • generate_intercompany_matching_report

  • import_supplementation_data

  • deploy_form_template

Architecture

fccs-mcp-ag-server/
├── fccs_agent/           # Main package
│   ├── agent.py          # Agent orchestration
│   ├── config.py         # Configuration
│   ├── client/           # FCCS HTTP client
│   ├── tools/            # 25+ tool modules
│   └── services/         # Feedback service
├── cli/                  # CLI & MCP server
│   ├── main.py           # Interactive CLI
│   └── mcp_server.py     # MCP stdio server
└── web/                  # FastAPI server
    └── server.py

Deployment

Windows

See WINDOWS_DEPLOYMENT.md for complete Windows deployment guide including:

  • Prerequisites installation

  • Automated setup scripts

  • Windows Service configuration

  • Troubleshooting

Docker

docker build -t fccs-agent .
docker run -p 8080:8080 --env-file .env fccs-agent

Google Cloud Run

gcloud run deploy fccs-agent \
  --source . \
  --region us-central1 \
  --allow-unauthenticated \
  --set-env-vars FCCS_MOCK_MODE=true

See QUICK_DEPLOY.md for detailed Cloud Run deployment.

Feedback System

The agent tracks tool executions for reinforcement learning:

  • Automatic: Execution time, success/failure, errors

  • User Feedback: 1-5 rating via /feedback endpoint

  • Metrics: Aggregated stats via /metrics endpoint

Documentation

License

MIT

fccs-mcp-ag-server

Available Tools

36 tools
clear_dataC

Clear data for specified scenario, year, and period / Limpar dados

Inputs: scenario, year, period.

copy_dataC

Copy data between scenarios, years, or periods / Copiar dados

Inputs: from_scenario, to_scenario, from_year, to_year, +2 more.

deploy_form_templateC

Deploy a form template / Implantar um template de formulario

Inputs: template_name (required), parameters.

export_consolidation_rulesetsC

Export configurable consolidation rulesets / Exportar regras de consolidacao

Inputs: parameters.

export_data_sliceC

Export a specific data slice (grid) from the application / Exportar um slice de dados

Inputs: grid_definition (required), cube_name.

export_journalsC

Export consolidation journals / Exportar diarios de consolidacao

Inputs: parameters.

generate_consolidation_process_reportC

Generate a Consolidation Process Overview Report showing data flow from Local GAAP to Consolidated / Gerar relatorio de processo de consolidacao

Inputs: entity, account, period, year, +1 more.

generate_intercompany_matching_reportC

Generate intercompany matching report / Gerar relatorio de correspondencia ICP

Inputs: parameters.

generate_investment_memoC

Generate a 2-page investment memo (Word doc) with financial analysis / Gerar memorando de investimento

Inputs: ticker (required).

generate_reportC

Generate FCCS report (Task Manager, Supplemental Data, Enterprise Journal) / Gerar relatorio FCCS

Inputs: group_name (required), report_name (required), generated_report_file_name, parameters, +4 more.

generate_report_scriptC

Generate a Python script template for custom FCCS reporting / Gerar script Python para relatorio customizado

Inputs: script_name (required), report_type, description, accounts, +4 more.

generate_system_pitchB

Generate a one-pager pitch document about the system's capabilities / Gerar documento de apresentacao do sistema

Inputs: no named parameters.

get_application_infoC

Get information about the FCCS application / Obter informacoes sobre a aplicacao FCCS

Inputs: no named parameters.

get_dimension_hierarchyC

Build a parent-child hierarchy for a dimension / Construir hierarquia pai-filho

Inputs: dimension_name (required), member_name, depth, include_metadata.

get_dimensionsB

Get list of dimensions in the application / Obter lista de dimensoes na aplicacao

Inputs: no named parameters.

get_job_statusC

Get the status of a specific job / Obter o status de um job especifico

Inputs: job_id (required).

get_journal_detailsC

Get detailed information about a specific journal / Obter detalhes de um diario

Inputs: journal_label (required), scenario, year, period, +1 more.

get_journalsC

Retrieve consolidation journals with optional filters / Obter diarios de consolidacao

Inputs: scenario (required), year (required), period (required), consolidation, +4 more.

get_membersC

Get members of a specific dimension / Obter membros de uma dimensao especifica

Inputs: dimension_name (required).

get_recent_executionsC

Get recent tool executions that can be rated / Obter execucoes recentes que podem ser avaliadas

Inputs: tool_name, limit.

get_report_job_statusC

Get status of an asynchronously running report job / Obter status de um job de relatorio

Inputs: job_id (required), report_type.

get_rest_api_versionB

Get the REST API version / Obter a versao da API REST

Inputs: no named parameters.

import_consolidation_rulesetsC

Import configurable consolidation rulesets / Importar regras de consolidacao

Inputs: parameters.

import_journalsC

Import consolidation journals / Importar diarios de consolidacao

Inputs: parameters.

import_supplementation_dataC

Import supplementation data / Importar dados de suplementacao

Inputs: parameters.

list_jobsB

List recent jobs in the FCCS application / Listar jobs recentes na aplicacao FCCS

Inputs: no named parameters.

perform_journal_actionC

Perform an action on a journal (approve, reject, post, etc.) / Executar acao em um diario

Inputs: journal_label (required), action (required), parameters.

query_local_metadataC

Query the local metadata cache for dimension members / Consultar cache local de metadados

Inputs: dimension, member_filter.

run_business_ruleC

Run a business rule (e.g., Consolidation) / Executar regra de negocio

Inputs: rule_name (required), parameters.

run_data_ruleC

Run a Data Management load rule / Executar regra de carga do Data Management

Inputs: rule_name (required), start_period (required), end_period (required), import_mode, +1 more.

smart_retrieveD

Smart data retrieval with automatic 14-dimension handling / Recuperacao inteligente

Inputs: account (required), entity, period, years, +2 more.

smart_retrieve_consolidation_breakdownC

Retrieve all Consolidation dimension members (Entity Input, Entity Consolidation, Entity Total, Proportion, Elimination, Contribution) for an entity / Recuperar todos os membros da dimensao Consolidation para uma entidade

Inputs: account (required), entity, period, years, +1 more.

smart_retrieve_with_movementC

Smart data retrieval with configurable Movement dimension / Recuperacao inteligente com dimensao Movement customizavel

Inputs: account (required), movement (required), entity, period, +3 more.

submit_feedbackC

Submit user feedback (rating 1-5 stars) for a tool execution to improve RL learning / Enviar feedback do usuario para melhorar aprendizado RL

Inputs: execution_id (required), rating (required), feedback.

update_journal_periodC

Update the period of a journal / Atualizar o periodo de um diario

Inputs: journal_label (required), new_period (required), parameters.

validate_metadataC

Validate application metadata / Validar metadados da aplicacao

Inputs: log_file_name.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    C2.9/5.0

    Scored across 36 tools

    Disambiguation4/5

    Most tools have distinct purposes, such as clear_data for clearing, copy_data for copying, and generate_report for reporting. However, some overlap exists, like get_journals and get_journal_details both retrieving journal information, which could cause minor confusion. Overall, descriptions help differentiate, but a few tools have unclear boundaries.

    Naming Consistency4/5

    Tool names largely follow a consistent verb_noun pattern, such as clear_data, copy_data, and generate_report. There are minor deviations, like smart_retrieve and smart_retrieve_with_movement using adjectives, but the naming remains readable and predictable throughout the set.

    Tool Count3/5

    With 36 tools, the count is borderline high for an FCCS server, feeling heavy and potentially overwhelming. While it covers various aspects like data management, reporting, and consolidation, it might benefit from consolidation or categorization to improve usability without sacrificing functionality.

    Completeness5/5

    The tool set provides comprehensive coverage for FCCS operations, including data management (clear, copy, import, export), reporting (generate various reports), consolidation (rulesets, journals, actions), and system interactions (info, status, metadata). No obvious gaps are present, supporting full CRUD/lifecycle workflows in the domain.

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables management and configuration of Cisco ACI (Application Centric Infrastructure) fabrics through the APIC REST API, providing 35+ tools for tenant management, network policies, EPGs, bridge domains, VRFs, contracts, and health monitoring.
      2
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      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. Built by Fred Mamadjanov, Oracle ACE and EPM Solution Architect.
      18
      MIT
    • F
      license
      Not graded
      quality
      B
      maintenance
      Enables interaction with Oracle Cloud Infrastructure through the MCP protocol. Supports dynamic profile selection and provides 85 tools for managing compute, databases, networking, IAM, storage, load balancers, OKE, monitoring, and cost management.
      -
    • F
      license
      Not graded
      quality
      C
      maintenance
      Enables interaction with Oracle Fusion HCM via REST, SOAP, SQL, and BPM, supporting catalog search, operation execution, ESS processes, BI Publisher reports, security diagnostics, and workflow management.
      -