FCCS MCP Agentic Server
This server provides agentic access to Oracle EPM Cloud Financial Consolidation and Close (FCCS) with dual MCP server and web API modes, featuring 40+ tools for comprehensive FCCS operations.
Comprehensive FCCS Operations: Full coverage of Oracle FCCS REST API including application management, job execution, dimension exploration, journal handling, data operations, report generation, and consolidation processes
Dual Access Modes: Functions as both an MCP server for Claude Desktop integration and a FastAPI web server for direct API access
Application & Job Management: Retrieve application details, API version information, list recent jobs, check job statuses, and run business or data load rules
Dimension & Metadata Operations: Get dimension lists and members, build parent-child hierarchies, and query local metadata cache with SQL-like filtering
Journal Management: Retrieve, filter, approve, reject, post journals, update periods, and perform bulk import/export operations
Intelligent Data Retrieval: Smart data tools with automatic 14-dimension handling, consolidation breakdown (Entity Input, Total, Proportion, Elimination, Contribution), movement dimension customization, and data copy/clear operations
Reporting Capabilities: Generate FCCS reports (Task Manager, Supplemental Data, Enterprise Journal, Consolidation Process) in multiple formats (HTML, PDF, XLSX, CSV) with async support, plus custom Python script templates for reporting
Advanced Consolidation: Export/import consolidation rulesets, validate metadata, generate intercompany matching reports, import supplementation data, and deploy form templates
Feedback & Learning System: PostgreSQL persistence with reinforcement learning tracking, user feedback submission (1-5 stars), execution history viewing, and performance metrics
Business Document Generation: Create system pitch documents and investment memos with financial analysis
Development Flexibility: Mock mode for development without real FCCS connection, bilingual English/Portuguese support, and automated setup scripts
Deployment Options: Windows, Linux/Mac, Docker, and Google Cloud Run deployment with detailed guides for each platform
Enables deployment of the FCCS agent server on Google Cloud Run platform
Stores tool execution history, feedback, and metrics for reinforcement learning tracking of FCCS operations
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@FCCS MCP Agentic Server list recent jobs and check their status"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Windows (Recommended)
Automated Setup:
.\setup-windows.batThis will:
Create virtual environment
Install all dependencies
Create
.envfile from templateGuide you through configuration
Manual Setup:
Create virtual environment:
python -m venv venvActivate:
.\venv\Scripts\Activate.ps1Install:
pip install -e .Configure: Copy
.env.exampleto.envand editInitialize database:
python scripts\init_db.py(if using PostgreSQL)
Quick Commands:
Start web server:
.\start-server.batStart MCP server:
.\start-mcp-server.batInstall dependencies:
.\install-dependencies.batInitialize 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 settings3. Run:
MCP Server (for Claude Desktop):
python -m cli.mcp_serverWeb Server (for API access):
python -m web.serverInteractive CLI:
python -m cli.mainClaude 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 |
| GET | List available tools |
| POST | Execute a tool |
| POST | Call specific tool |
| POST | Submit user feedback |
| GET | Get tool metrics |
Available Tools
Application
get_application_info- FCCS application detailsget_rest_api_version- API version info
Jobs
list_jobs- List recent jobsget_job_status- Job status by IDrun_business_rule- Execute business rulesrun_data_rule- Execute data load rules
Dimensions
get_dimensions- List all dimensionsget_members- Get dimension membersget_dimension_hierarchy- Build hierarchy tree
Journals
get_journals- List journalsget_journal_details- Journal detailsperform_journal_action- Approve, reject, postupdate_journal_period- Update periodexport_journals/import_journals
Data
export_data_slice- Export grid datasmart_retrieve- Smart data retrievalcopy_data/clear_data
Reports
generate_report- Generate FCCS reportsget_report_job_status- Async report status
Consolidation
export_consolidation_rulesets/import_consolidation_rulesetsvalidate_metadatagenerate_intercompany_matching_reportimport_supplementation_datadeploy_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.pyDeployment
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-agentGoogle Cloud Run
gcloud run deploy fccs-agent \
--source . \
--region us-central1 \
--allow-unauthenticated \
--set-env-vars FCCS_MOCK_MODE=trueSee 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
/feedbackendpointMetrics: Aggregated stats via
/metricsendpoint
Documentation
Windows Deployment Guide - Complete Windows setup
GitHub Setup Guide - Repository setup and configuration
Quick Deploy - Google Cloud Run deployment
ChatGPT Quick Start - ChatGPT integration
Dashboard Quick Start - Performance dashboard
License
MIT
fccs-mcp-ag-server
Available Tools
36 toolsclear_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
Scored across 36 tools
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.
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.
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.
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
Read and edit GA4, Search Console and Google Tag Manager from any MCP client. 29 tools.
One OAuth connector for your team's remote MCP servers, with Tool Packs, guardrails and logs.
Query financial statements, KPIs, ratios, cash forecasts and budgets from your general ledger
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables 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.2MIT
- AlicenseNot gradedqualityCmaintenanceConnect 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.18MIT
- FlicenseNot gradedqualityBmaintenanceEnables 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.-
- FlicenseNot gradedqualityCmaintenanceEnables 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.-