Oracle Fusion Cloud Applications

Oracle Fusion Cloud Applications Common Lookups API

Manage lookup types and lookup codes

GitHub OpenAPI

Operations 7

GET /fscmRestApi/resources/11.13.18.05/commonLookups Oracle Fusion Cloud Applications List common lookups #
POST /fscmRestApi/resources/11.13.18.05/commonLookups Oracle Fusion Cloud Applications Create a common lookup #
GET /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType} Oracle Fusion Cloud Applications Get a common lookup #
PATCH /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType} Oracle Fusion Cloud Applications Update a common lookup #
DELETE /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType} Oracle Fusion Cloud Applications Delete a common lookup #
GET /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType}/child/lookupCodes Oracle Fusion Cloud Applications List lookup codes for a lookup type #
POST /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType}/child/lookupCodes Oracle Fusion Cloud Applications Create a lookup code #

Documentation

📖
Documentation
https://docs.oracle.com/en/cloud/saas/financials/26a/farfa/index.html
📖
Authentication
https://docs.oracle.com/en/cloud/saas/financials/22r3/farfa/Authentication.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/financials/26a/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/human-resources/22r3/farws/
📖
Authentication
https://docs.oracle.com/en/cloud/saas/human-resources/22r3/farws/Authentication.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/human-resources/26a/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/supply-chain-management/22r3/fasrs/
📖
Authentication
https://docs.oracle.com/en/cloud/saas/supply-chain-management/22r3/fasrs/Authentication.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/supply-chain-management/26a/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/sales/faaps/index.html
📖
Authentication
https://docs.oracle.com/en/cloud/saas/cx-sales/rest-authentication.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/sales/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/applications-common/26a/farca/index.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/applications-common/26a/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/project-management/26a/fapap/index.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/project-management/26a/index.html
📖
Documentation
https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/index.html
📖
GettingStarted
https://docs.oracle.com/en/cloud/saas/epm-cloud/index.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-fusion/refs/heads/main/openapi/oracle-fusion-common-lookups-api-openapi.yml

Other Resources

🔗
ChangeLog
https://docs.oracle.com/en/cloud/saas/readiness/erp/index.html
🔗
ChangeLog
https://docs.oracle.com/en/cloud/saas/readiness/hcm/index.html
🔗
ChangeLog
https://docs.oracle.com/en/cloud/saas/readiness/scm/index.html
🔗
ChangeLog
https://docs.oracle.com/en/cloud/saas/readiness/sales.html

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-common-lookups-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

oracle-fusion-common-lookups-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Fusion Cloud Applications Oracle Fusion Common Features REST Absences Common Lookups 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: Common Lookups
  description: Manage lookup types and lookup codes
paths:
  /fscmRestApi/resources/11.13.18.05/commonLookups:
    get:
      operationId: listCommonLookups
      summary: Oracle Fusion Cloud Applications List common lookups
      description: Retrieve common lookup type definitions and their associated lookup codes used across Fusion Cloud applications.
      tags:
      - Common Lookups
      parameters:
      - $ref: '#/components/parameters/limit'
      - $ref: '#/components/parameters/offset'
      - $ref: '#/components/parameters/fields'
      - $ref: '#/components/parameters/q'
      - $ref: '#/components/parameters/finder'
      responses:
        '200':
          description: Common lookups retrieved
          content:
            application/json:
              schema:
                type: object
                properties:
                  items:
                    type: array
                    items:
                      $ref: '#/components/schemas/CommonLookup'
                  count:
                    type: integer
                  hasMore:
                    type: boolean
        '401':
          $ref: '#/components/responses/Unauthorized'
    post:
      operationId: createCommonLookup
      summary: Oracle Fusion Cloud Applications Create a common lookup
      description: Create a new common lookup type.
      tags:
      - Common Lookups
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/CommonLookupCreate'
      responses:
        '201':
          description: Common lookup created
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/CommonLookup'
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
  /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType}:
    get:
      operationId: getCommonLookup
      summary: Oracle Fusion Cloud Applications Get a common lookup
      description: Retrieve a specific common lookup type and its codes.
      tags:
      - Common Lookups
      parameters:
      - name: LookupType
        in: path
        required: true
        description: Lookup type identifier
        schema:
          type: string
      - $ref: '#/components/parameters/fields'
      - $ref: '#/components/parameters/expand'
      responses:
        '200':
          description: Common lookup details
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/CommonLookup'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
    patch:
      operationId: updateCommonLookup
      summary: Oracle Fusion Cloud Applications Update a common lookup
      description: Update an existing common lookup type.
      tags:
      - Common Lookups
      parameters:
      - name: LookupType
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/CommonLookupCreate'
      responses:
        '200':
          description: Common lookup updated
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
    delete:
      operationId: deleteCommonLookup
      summary: Oracle Fusion Cloud Applications Delete a common lookup
      description: Delete a common lookup type.
      tags:
      - Common Lookups
      parameters:
      - name: LookupType
        in: path
        required: true
        schema:
          type: string
      responses:
        '204':
          description: Common lookup deleted
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
  /fscmRestApi/resources/11.13.18.05/commonLookups/{LookupType}/child/lookupCodes:
    get:
      operationId: listLookupCodes
      summary: Oracle Fusion Cloud Applications List lookup codes for a lookup type
      description: Retrieve lookup codes belonging to a specific lookup type.
      tags:
      - Common Lookups
      parameters:
      - name: LookupType
        in: path
        required: true
        schema:
          type: string
      - $ref: '#/components/parameters/limit'
      - $ref: '#/components/parameters/offset'
      - $ref: '#/components/parameters/fields'
      responses:
        '200':
          description: Lookup codes retrieved
          content:
            application/json:
              schema:
                type: object
                properties:
                  items:
                    type: array
                    items:
                      $ref: '#/components/schemas/LookupCode'
                  count:
                    type: integer
                  hasMore:
                    type: boolean
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
    post:
      operationId: createLookupCode
      summary: Oracle Fusion Cloud Applications Create a lookup code
      description: Create a new lookup code within a lookup type.
      tags:
      - Common Lookups
      parameters:
      - name: LookupType
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/LookupCodeCreate'
      responses:
        '201':
          description: Lookup code created
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
components:
  schemas:
    LookupCodeCreate:
      type: object
      required:
      - LookupCode
      - Meaning
      properties:
        LookupCode:
          type: string
        Meaning:
          type: string
        Description:
          type: string
        EnabledFlag:
          type: boolean
        DisplaySequence:
          type: integer
    CommonLookupCreate:
      type: object
      required:
      - LookupType
      - Meaning
      properties:
        LookupType:
          type: string
        Meaning:
          type: string
        Description:
          type: string
    LookupCode:
      type: object
      properties:
        LookupCode:
          type: string
          description: Lookup code value
        Meaning:
          type: string
          description: Display meaning
        Description:
          type: string
          description: Code description
        EnabledFlag:
          type: boolean
          description: Whether the code is enabled
        StartDateActive:
          type: string
          format: date
          description: Start date for active period
        EndDateActive:
          type: string
          format: date
          description: End date for active period
        DisplaySequence:
          type: integer
          description: Display order sequence
    CommonLookup:
      type: object
      properties:
        LookupType:
          type: string
          description: Lookup type identifier
        Meaning:
          type: string
          description: Display name for the lookup type
        Description:
          type: string
          description: Lookup type description
        ModuleType:
          type: string
          description: Module that owns the lookup
        CreationDate:
          type: string
          format: date-time
  parameters:
    limit:
      name: limit
      in: query
      required: false
      schema:
        type: integer
        default: 25
        maximum: 500
    expand:
      name: expand
      in: query
      required: false
      schema:
        type: string
    fields:
      name: fields
      in: query
      required: false
      schema:
        type: string
    offset:
      name: offset
      in: query
      required: false
      schema:
        type: integer
        default: 0
    finder:
      name: finder
      in: query
      required: false
      schema:
        type: string
    q:
      name: q
      in: query
      required: false
      schema:
        type: string
  responses:
    NotFound:
      description: The requested resource was not found
    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