Skip to main content
Glama
ivossos

FCCS MCP Agentic Server

by ivossos

get_dimensions

Retrieve all dimensions from Oracle EPM Cloud FCCS applications to manage financial consolidation and close processes.

Instructions

Get list of dimensions in the application / Obter lista de dimensoes na aplicacao

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Implementation Reference

  • The main tool handler function that executes the get_dimensions logic by calling the FCCS client and formatting the response.
    async def get_dimensions() -> dict[str, Any]:
        """Get list of dimensions in the application / Obter lista de dimensoes na aplicacao.
    
        Returns:
            dict: List of dimensions with their types.
        """
        dimensions = await _client.get_dimensions(_app_name)
        return {"status": "success", "data": dimensions}
  • The tool schema definition including name, description, and input schema (empty object since no parameters required).
    {
        "name": "get_dimensions",
        "description": "Get list of dimensions in the application / Obter lista de dimensoes na aplicacao",
        "inputSchema": {
            "type": "object",
            "properties": {},
        },
    },
  • Registration of the get_dimensions tool handler in the central TOOL_HANDLERS dictionary used by the agent.
    # Dimensions
    "get_dimensions": dimensions.get_dimensions,
    "get_members": dimensions.get_members,
    "get_dimension_hierarchy": dimensions.get_dimension_hierarchy,
  • The underlying FCCS client helper method that implements the API calls or mock data retrieval for dimensions, called by the tool handler.
    async def get_dimensions(self, app_name: str) -> dict[str, Any]:
        """Get dimensions / Obter dimensoes."""
        if self.config.fccs_mock_mode:
            return MOCK_DIMENSIONS
    
        # Try multiple endpoints
        endpoints = [
            f"/{app_name}/dimensions{self._get_query_params()}",
            f"/{app_name}/dimensions",
            f"/{app_name}/metadata/dimensions{self._get_query_params()}",
            f"/{app_name}/metadata/dimensions",
        ]
    
        for endpoint in endpoints:
            try:
                response = await self._client.get(endpoint)
                if response.status_code == 200:
                    return response.json()
            except Exception:
                continue
    
        # Fallback to standard FCCS dimensions
        return {
            "items": [
                {"name": "Years", "type": "Time"},
                {"name": "Period", "type": "Time"},
                {"name": "Scenario", "type": "Scenario"},
                {"name": "View", "type": "View"},
                {"name": "Entity", "type": "Entity"},
                {"name": "Consolidation", "type": "Consolidation"},
                {"name": "Account", "type": "Account"},
                {"name": "ICP", "type": "ICP"},
                {"name": "Data Source", "type": "Data Source"},
                {"name": "Movement", "type": "Movement"},
                {"name": "Multi-GAAP", "type": "Multi-GAAP"},
            ],
            "note": "Standard FCCS dimensions (endpoint not available)"
        }
  • Inclusion of dimensions.TOOL_DEFINITIONS (containing get_dimensions schema) in the aggregated ALL_TOOL_DEFINITIONS list exposed via get_tool_definitions() for MCP.
    ALL_TOOL_DEFINITIONS = (
        application.TOOL_DEFINITIONS +
        jobs.TOOL_DEFINITIONS +
        dimensions.TOOL_DEFINITIONS +

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ivossos/fccs-mcp-ag-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server