Oracle Financials · Capability

Oracle Financials General Ledger API

REST API for Oracle Fusion Cloud Financials General Ledger, providing programmatic access to journal batches, journal entries, ledger balances, currency rates, chart of accounts filters, and budgetary control. The API supports creating, retrieving, updating, and deleting journal batches, viewing account balances for any account combination or account group, and managing currency conversion rates used across the financial system.

Run with Naftiko OracleFinancialsAPI

What You Can Do

GET
Listjournalbatches — Oracle Financials List journal batches
/fscmRestApi/resources/11.13.18.05/journalBatches
GET
Getjournalbatch — Oracle Financials Get a journal batch
/fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
PATCH
Updatejournalbatch — Oracle Financials Update a journal batch
/fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
DELETE
Deletejournalbatch — Oracle Financials Delete a journal batch
/fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
GET
Listledgerbalances — Oracle Financials List account balances
/fscmRestApi/resources/11.13.18.05/ledgerBalances
GET
Listcurrencyrates — Oracle Financials List currency rates
/fscmRestApi/resources/11.13.18.05/currencyRates
POST
Createchartofaccountsfilter — Oracle Financials Create a chart of accounts filter
/fscmRestApi/resources/11.13.18.05/chartOfAccountsFilters
GET
Listbudgetarycontrolresults — Oracle Financials List budgetary control results
/fscmRestApi/resources/11.13.18.05/budgetaryControlResults
POST
Createbudgettransaction — Oracle Financials Create a budget transaction
/fscmRestApi/resources/11.13.18.05/budgetaryControlBudgetTransactions

MCP Tools

listjournalbatches

Oracle Financials List journal batches

read-only idempotent
getjournalbatch

Oracle Financials Get a journal batch

read-only idempotent
updatejournalbatch

Oracle Financials Update a journal batch

deletejournalbatch

Oracle Financials Delete a journal batch

idempotent
listledgerbalances

Oracle Financials List account balances

read-only idempotent
listcurrencyrates

Oracle Financials List currency rates

read-only idempotent
createchartofaccountsfilter

Oracle Financials Create a chart of accounts filter

listbudgetarycontrolresults

Oracle Financials List budgetary control results

read-only idempotent
createbudgettransaction

Oracle Financials Create a budget transaction

Capability Spec

oracle-financials-capability.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Oracle Financials General Ledger API
  description: REST API for Oracle Fusion Cloud Financials General Ledger, providing programmatic access to journal batches,
    journal entries, ledger balances, currency rates, chart of accounts filters, and budgetary control. The API supports creating,
    retrieving, updating, and deleting journal batches, viewing account balances for any account combination or account group,
    and managing currency conversion rates used across the financial system.
  tags:
  - Oracle
  - Financials
  - API
  created: '2026-05-06'
  modified: '2026-05-06'
capability:
  consumes:
  - type: http
    namespace: oracle-financials
    baseUri: https://servername.oraclecloud.com
    description: Oracle Financials General Ledger API HTTP API.
    authentication:
      type: bearer
      token: '{{ORACLE_FINANCIALS_TOKEN}}'
    resources:
    - name: fscmrestapi-resources-11-13-18-05-journalbatches
      path: /fscmRestApi/resources/11.13.18.05/journalBatches
      operations:
      - name: listjournalbatches
        method: GET
        description: Oracle Financials List journal batches
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-journalbatches
      path: /fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
      operations:
      - name: getjournalbatch
        method: GET
        description: Oracle Financials Get a journal batch
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: updatejournalbatch
        method: PATCH
        description: Oracle Financials Update a journal batch
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletejournalbatch
        method: DELETE
        description: Oracle Financials Delete a journal batch
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-ledgerbalances
      path: /fscmRestApi/resources/11.13.18.05/ledgerBalances
      operations:
      - name: listledgerbalances
        method: GET
        description: Oracle Financials List account balances
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-currencyrates
      path: /fscmRestApi/resources/11.13.18.05/currencyRates
      operations:
      - name: listcurrencyrates
        method: GET
        description: Oracle Financials List currency rates
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-chartofaccount
      path: /fscmRestApi/resources/11.13.18.05/chartOfAccountsFilters
      operations:
      - name: createchartofaccountsfilter
        method: POST
        description: Oracle Financials Create a chart of accounts filter
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-budgetarycontr
      path: /fscmRestApi/resources/11.13.18.05/budgetaryControlResults
      operations:
      - name: listbudgetarycontrolresults
        method: GET
        description: Oracle Financials List budgetary control results
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: fscmrestapi-resources-11-13-18-05-budgetarycontr
      path: /fscmRestApi/resources/11.13.18.05/budgetaryControlBudgetTransactions
      operations:
      - name: createbudgettransaction
        method: POST
        description: Oracle Financials Create a budget transaction
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
  exposes:
  - type: rest
    port: 8080
    namespace: oracle-financials-rest
    description: REST adapter for Oracle Financials General Ledger API.
    resources:
    - path: /fscmRestApi/resources/11.13.18.05/journalBatches
      name: listjournalbatches
      operations:
      - method: GET
        name: listjournalbatches
        description: Oracle Financials List journal batches
        call: oracle-financials.listjournalbatches
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
      name: getjournalbatch
      operations:
      - method: GET
        name: getjournalbatch
        description: Oracle Financials Get a journal batch
        call: oracle-financials.getjournalbatch
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
      name: updatejournalbatch
      operations:
      - method: PATCH
        name: updatejournalbatch
        description: Oracle Financials Update a journal batch
        call: oracle-financials.updatejournalbatch
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/journalBatches/{JeBatchId}
      name: deletejournalbatch
      operations:
      - method: DELETE
        name: deletejournalbatch
        description: Oracle Financials Delete a journal batch
        call: oracle-financials.deletejournalbatch
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/ledgerBalances
      name: listledgerbalances
      operations:
      - method: GET
        name: listledgerbalances
        description: Oracle Financials List account balances
        call: oracle-financials.listledgerbalances
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/currencyRates
      name: listcurrencyrates
      operations:
      - method: GET
        name: listcurrencyrates
        description: Oracle Financials List currency rates
        call: oracle-financials.listcurrencyrates
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/chartOfAccountsFilters
      name: createchartofaccountsfilter
      operations:
      - method: POST
        name: createchartofaccountsfilter
        description: Oracle Financials Create a chart of accounts filter
        call: oracle-financials.createchartofaccountsfilter
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/budgetaryControlResults
      name: listbudgetarycontrolresults
      operations:
      - method: GET
        name: listbudgetarycontrolresults
        description: Oracle Financials List budgetary control results
        call: oracle-financials.listbudgetarycontrolresults
        outputParameters:
        - type: object
          mapping: $.
    - path: /fscmRestApi/resources/11.13.18.05/budgetaryControlBudgetTransactions
      name: createbudgettransaction
      operations:
      - method: POST
        name: createbudgettransaction
        description: Oracle Financials Create a budget transaction
        call: oracle-financials.createbudgettransaction
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    port: 9090
    namespace: oracle-financials-mcp
    transport: http
    description: MCP adapter for Oracle Financials General Ledger API for AI agent use.
    tools:
    - name: listjournalbatches
      description: Oracle Financials List journal batches
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: oracle-financials.listjournalbatches
      outputParameters:
      - type: object
        mapping: $.
    - name: getjournalbatch
      description: Oracle Financials Get a journal batch
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: oracle-financials.getjournalbatch
      outputParameters:
      - type: object
        mapping: $.
    - name: updatejournalbatch
      description: Oracle Financials Update a journal batch
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: oracle-financials.updatejournalbatch
      outputParameters:
      - type: object
        mapping: $.
    - name: deletejournalbatch
      description: Oracle Financials Delete a journal batch
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: oracle-financials.deletejournalbatch
      outputParameters:
      - type: object
        mapping: $.
    - name: listledgerbalances
      description: Oracle Financials List account balances
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: oracle-financials.listledgerbalances
      outputParameters:
      - type: object
        mapping: $.
    - name: listcurrencyrates
      description: Oracle Financials List currency rates
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: oracle-financials.listcurrencyrates
      outputParameters:
      - type: object
        mapping: $.
    - name: createchartofaccountsfilter
      description: Oracle Financials Create a chart of accounts filter
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: oracle-financials.createchartofaccountsfilter
      outputParameters:
      - type: object
        mapping: $.
    - name: listbudgetarycontrolresults
      description: Oracle Financials List budgetary control results
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: oracle-financials.listbudgetarycontrolresults
      outputParameters:
      - type: object
        mapping: $.
    - name: createbudgettransaction
      description: Oracle Financials Create a budget transaction
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: oracle-financials.createbudgettransaction
      outputParameters:
      - type: object
        mapping: $.
binds:
- namespace: env
  keys:
    ORACLE_FINANCIALS_TOKEN: ORACLE_FINANCIALS_TOKEN