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

Quick Start

Windows (Recommended)

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

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

• 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