Oracle Fusion Cloud Applications Planning API

Planning application data and metadata operations

Documentation GitHub OpenAPI

Operations 2

POST /HyperionPlanning/rest/v3/applications/{applicationName}/plantypes/{planType}/exportdataslice Oracle Fusion Cloud Applications Export a data slice #

POST /HyperionPlanning/rest/v3/applications/{applicationName}/plantypes/{planType}/importdataslice Oracle Fusion Cloud Applications Import a data slice #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/oracle-fusion-planning-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Oracle Fusion Cloud Applications Oracle Fusion Common Features REST Absences Planning API
  description: REST APIs for Oracle Fusion Cloud Applications Common features, providing access to shared services such as attachments, flexfields, lookup types, roles, users, security, scheduled processes, announcements, and approval workflows used across all Fusion Cloud application pillars.
  version: 11.13.18.05
  contact:
    name: Oracle Support
    url: https://support.oracle.com
    email: support@oracle.com
  license:
    name: Oracle Cloud Services Agreement
    url: https://www.oracle.com/corporate/contracts/cloud-services/
  termsOfService: https://www.oracle.com/corporate/contracts/cloud-services/
servers:
- url: https://{instance}.oraclecloud.com
  description: Oracle Fusion Cloud Instance
  variables:
    instance:
      default: servername
      description: Your Oracle Cloud instance identifier
security:
- bearerAuth: []
tags:
- name: Planning
  description: Planning application data and metadata operations
paths:
  /HyperionPlanning/rest/v3/applications/{applicationName}/plantypes/{planType}/exportdataslice:
    post:
      operationId: exportDataSlice
      summary: Oracle Fusion Cloud Applications Export a data slice
      description: Export planning data for a specified slice defined by dimension member selections, point-of-view, and filters.
      tags:
      - Planning
      parameters:
      - name: applicationName
        in: path
        required: true
        schema:
          type: string
      - name: planType
        in: path
        required: true
        description: Plan type name
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataSliceRequest'
      responses:
        '200':
          description: Data slice exported
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/DataSliceResponse'
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /HyperionPlanning/rest/v3/applications/{applicationName}/plantypes/{planType}/importdataslice:
    post:
      operationId: importDataSlice
      summary: Oracle Fusion Cloud Applications Import a data slice
      description: Import planning data into a specified plan type using dimension member intersections and values.
      tags:
      - Planning
      parameters:
      - name: applicationName
        in: path
        required: true
        schema:
          type: string
      - name: planType
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DataSliceImport'
      responses:
        '200':
          description: Data slice imported
          content:
            application/json:
              schema:
                type: object
                properties:
                  status:
                    type: integer
                  details:
                    type: string
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
components:
  schemas:
    DataSliceImport:
      type: object
      properties:
        aggregateEssbaseData:
          type: boolean
          description: Whether to aggregate data
        cellNotesOption:
          type: string
          description: Cell notes handling option
        dateFormat:
          type: string
          description: Date format for the import
        dataGrid:
          type: object
          properties:
            pov:
              type: array
              items:
                type: string
            columns:
              type: array
              items:
                type: array
                items:
                  type: string
            rows:
              type: array
              items:
                type: object
                properties:
                  headers:
                    type: array
                    items:
                      type: string
                  data:
                    type: array
                    items:
                      type: number
    DataSliceRequest:
      type: object
      properties:
        exportPlanningData:
          type: boolean
          description: Whether to export planning data
          default: true
        gridDefinition:
          type: object
          properties:
            suppressMissingBlocks:
              type: boolean
            suppressMissingRows:
              type: boolean
            pov:
              type: object
              description: Point-of-view dimension selections
            columns:
              type: array
              items:
                type: object
              description: Column dimension members
            rows:
              type: array
              items:
                type: object
              description: Row dimension members
    DataSliceResponse:
      type: object
      properties:
        rows:
          type: array
          items:
            type: object
            properties:
              headers:
                type: array
                items:
                  type: string
              data:
                type: array
                items:
                  type: number
          description: Data rows with headers and values
        status:
          type: integer
  responses:
    BadRequest:
      description: Invalid request parameters or payload
    Unauthorized:
      description: Authentication credentials are missing or invalid
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
    basicAuth:
      type: http
      scheme: basic
externalDocs:
  description: Oracle Fusion Cloud Applications Common Features REST API Documentation
  url: https://docs.oracle.com/en/cloud/saas/applications-common/26a/farca/index.html