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
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- fccs_agent/tools/dimensions.py:22-29 (handler)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": {}, }, },
- fccs_agent/agent.py:147-150 (registration)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)" }
- fccs_agent/agent.py:188-191 (registration)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 +