Oracle Fusion AR MCP Server 🚀

A remote Model Context Protocol (MCP) server built in Python that provides secure access to Oracle Fusion Cloud Accounts Receivable REST API. Deploy once, share with everyone!

🌟 Key Features

• 🌐 Remote MCP Server: Deploy to cloud and share via URL

• 🔒 Secure: No credential storage, per-request authentication

• 📊 Three MCP Tools:

  • oracle_ar_list_invoices - List and filter invoices

  • oracle_ar_get_invoice_details - Get detailed invoice information

  • oracle_ar_search_invoices - Advanced search with statistics

• 📝 Dual Output: Both JSON and human-readable Markdown

• ⚡ Fast: Built with Python + uv + httpx (async)

• ☁️ Cloud-Ready: One-click deploy to Railway, Render, Heroku

🚀 Quick Deploy

Deploy to Railway (Recommended - Free Tier Available)

1. Click the button above or go to railway.app

2. Connect your GitHub repository

3. Set environment variable:

   • ORACLE_BASE_URL: https://fa-euth-dev46-saasfademo1.ds-fa.oraclepdemos.com

4. Deploy! 🎉

You'll get a URL like: https://oracle-ar-mcp-server-production.up.railway.app

Deploy to Render

1. Click the button or go to render.com

2. Connect your GitHub repository

3. Render auto-detects configuration from render.yaml

4. Deploy! 🎉

Other Platforms

See DEPLOYMENT.md for detailed instructions for:

• Heroku

• Google Cloud Run

• AWS ECS/Fargate

• Azure Container Apps

• Docker deployment

📡 Connect to Your Deployed Server

Once deployed, anyone can connect using your server URL.

For Claude Desktop

Add to claude_desktop_config.json:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

Test Your Deployment

📚 API Documentation

Endpoints

• GET / - Service information and available tools

• GET /health - Health check endpoint

• GET /sse - SSE endpoint for MCP connections

• POST /messages - MCP message endpoint

MCP Tools

1. oracle_ar_list_invoices

List invoices with optional filtering and pagination.

Parameters:

2. oracle_ar_get_invoice_details

Get detailed information about a specific invoice.

Parameters:

3. oracle_ar_search_invoices

Advanced search with filters and statistics.

Parameters:

🛠️ Local Development

Prerequisites

• Python 3.10+

• uv (recommended)

• Oracle Fusion Cloud credentials

Setup

Run Locally

Run Tests

🔒 Security

✅ Secure Design

• No Credential Storage: Credentials are passed per-request only

• Stateless: No session state stored on server

• No Logging: Credentials are never logged

• HTTPS Only: All communication encrypted (via hosting platform)

• Input Validation: Full Pydantic validation on all inputs

🔑 Authentication Flow

1. User calls MCP tool with Oracle username/password

2. Server receives request (credentials in memory only)

3. Server authenticates request to Oracle API

4. Oracle returns data

5. Server formats and returns response

6. Credentials discarded (not stored anywhere)

📊 Technology Stack

• Python 3.12 - Modern async Python

• uv - Fast, reliable package manager

• MCP SDK - Model Context Protocol support

• httpx - Async HTTP client

• Pydantic - Data validation and type safety

• Starlette - ASGI web framework

• uvicorn - ASGI server

• pytest - Testing framework

📁 Project Structure

🤝 Sharing Your Server

After deploying, share your server with others:

1. Share the SSE Endpoint URL

2. Provide Configuration Instructions

Users add this to their Claude Desktop config:

3. Users Provide Their Own Credentials

Each user must have their own Oracle Fusion credentials, which they provide when using the tools. The server never stores or shares credentials between users.

🧪 Testing

Manual Testing

Automated Testing

📈 Monitoring

Health Check

Response:

Platform Logs

• Railway: Dashboard → Your App → Logs

• Render: Dashboard → Your Service → Logs

• Heroku: heroku logs --tail

💰 Cost

Free Tier Options

• Railway: $5 credit/month (sufficient for light use)

• Render: 750 hours/month free

• Heroku: Free with credit card (1000 dyno hours/month)

Paid Plans (Production)

• Railway: ~$5-10/month

• Render: ~$7/month

• Heroku: ~$7/month

🔄 Updates & CI/CD

Automatic Deployments

Push to GitHub and your platform automatically deploys:

GitHub Actions

• ✅ Automatic testing on PRs

• ✅ Code quality checks (ruff, mypy)

• ✅ Coverage reports

• ✅ Build verification

🐛 Troubleshooting

Server Won't Start

• Check platform logs for errors

• Verify environment variables are set

• Ensure PORT is not hardcoded (use platform's PORT)

Oracle API Connection Failed

• Verify ORACLE_BASE_URL is correct

• Check Oracle API is accessible from your platform

• Test with health check endpoint

Claude Desktop Can't Connect

• Verify SSE endpoint URL is correct

• Ensure HTTPS is enabled

• Check server is running (health check)

• Restart Claude Desktop after config change

🤝 Contributing

1. Fork the repository

2. Create a feature branch (git checkout -b feature/amazing-feature)

3. Make your changes

4. Run tests (uv run pytest)

5. Commit changes (git commit -m 'Add amazing feature')

6. Push to branch (git push origin feature/amazing-feature)

7. Open a Pull Request

📄 License

MIT License - see LICENSE file

🙏 Acknowledgments

• Built with Model Context Protocol

• Uses Oracle Fusion Cloud REST APIs

• Powered by uv

📞 Support

• 📖 Deployment Guide

• 🐛 Report Issues

• 💬 Discussions

🚀 Deploy once, share with everyone!

Made with ❤️ for the MCP community