Documentation
Back to CaptainMCP Overview
Use Cases & Workflows
Discover how natural language changes the way you interact with Oracle EPM.
Example Scenarios
The Month-End Rollover
Instead of navigating menus to update variables and run scripts sequentially, simply tell your AI assistant:
"Update the 'CurMo' substitution variable to 'Feb' and then run the 'Calculate Actuals' business rule for the 'OEP_FS' cube."
The MCP server translates this intent, fetches the variable endpoints, patches them, and submits the job, returning the execution status to the chat.
Security & Access Audits
Quickly audit user access without running reports:
"List all users who have the 'Service Administrator' role and export it as a markdown table."
The AI uses the Security roles endpoints, parses the JSON payload, and formats it beautifully for you.
Metadata Troubleshooting
Resolve calculation issues by questioning the hierarchy:
"Is the account '4100' set to Dynamic Calc? What is its parent?"
The server retrieves the dimension member properties and the AI analyzes the data storage and consolidation operators to give you an immediate answer.