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:

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:

2. Configure Environment:

3. Run:

MCP Server (for Claude Desktop):

Web Server (for API access):

Interactive CLI:

Claude Desktop Configuration

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

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

Deployment

Windows

See WINDOWS_DEPLOYMENT.md for complete Windows deployment guide including:

• Prerequisites installation

• Automated setup scripts

• Windows Service configuration

• Troubleshooting

Docker

Google Cloud Run

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