Oracle E-Business Suite · Arazzo Workflow

Oracle EBS Item Availability Check

Version 1.0.0

Resolve an item by number, read its on-hand quantity, and branch on stock availability.

1 workflow 1 source API 1 provider
View Spec View on GitHub Business ApplicationsE-Business SuiteEnterpriseERPOracleArazzoWorkflows

Provider

oracle-e-business-suite

Workflows

check-item-availability
Resolve an item and branch on whether it has on-hand stock.
Resolves an inventory item by number in an organization, reads its on-hand quantities, and branches on whether any quantity exists.
4 steps inputs: itemNumber, organizationId outputs: inventoryItemId, itemStatus, onhandQuantity
1
resolveItem
Resolve the inventory item by number within the organization, returning the first match.
2
readOnhand
Read on-hand quantities for the resolved item in the organization and branch on whether any stock is recorded.
3
reportAvailable
Read the item master record to report its details now that on-hand stock was confirmed.
4
reportOutOfStock
Read the item master record to surface its details when no on-hand stock was found.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: Oracle EBS Item Availability Check
  summary: Resolve an item by number, read its on-hand quantity, and branch on stock availability.
  description: >-
    An Oracle Inventory availability flow. The workflow resolves an inventory
    item by its number in an organization, reads on-hand quantities for it, and
    branches on whether stock is present to report the item as available or out
    of stock. Each step inlines its request so the availability check can be
    executed without opening the OpenAPI source.
  version: 1.0.0
  x-realizes-capability-ids:
  - BC-530
  x-capability-derivation:
    method: 'deterministic join: sourceDescriptions -> per-tag OpenAPI -> tag/capability edge. No classification at this step.'
    min_confidence: 0.7
    sources:
    - capability_id: BC-530
      capability_name: Inventory Management
      spec: oracle-e-business-suite-inventory-api-openapi.yml
      confidence: 0.75
    model: Turbo EA Capabilities by Vincent Verdet — Turbo EA, https://github.com/vincentmakes/turbo-ea-capabilities, CC BY 4.0
sourceDescriptions:
- name: inventoryApi
  url: ../openapi/oracle-e-business-suite-inventory-api-openapi.yml
  type: openapi
workflows:
- workflowId: check-item-availability
  summary: Resolve an item and branch on whether it has on-hand stock.
  description: >-
    Resolves an inventory item by number in an organization, reads its on-hand
    quantities, and branches on whether any quantity exists.
  inputs:
    type: object
    required:
    - itemNumber
    - organizationId
    properties:
      itemNumber:
        type: string
        description: Inventory item number (segment1) to resolve.
      organizationId:
        type: integer
        description: Inventory organization identifier.
  steps:
  - stepId: resolveItem
    description: >-
      Resolve the inventory item by number within the organization, returning
      the first match.
    operationId: getInventoryItems
    parameters:
    - name: segment1
      in: query
      value: $inputs.itemNumber
    - name: organizationId
      in: query
      value: $inputs.organizationId
    - name: limit
      in: query
      value: 1
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      inventoryItemId: $response.body#/items/0/inventoryItemId
  - stepId: readOnhand
    description: >-
      Read on-hand quantities for the resolved item in the organization and
      branch on whether any stock is recorded.
    operationId: getOnhandQuantities
    parameters:
    - name: inventoryItemId
      in: query
      value: $steps.resolveItem.outputs.inventoryItemId
    - name: organizationId
      in: query
      value: $inputs.organizationId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      onhandQuantity: $response.body#/items/0/transactionQuantity
    onSuccess:
    - name: inStock
      type: goto
      stepId: reportAvailable
      criteria:
      - context: $response.body
        condition: $.items.length > 0
        type: jsonpath
    - name: outOfStock
      type: goto
      stepId: reportOutOfStock
      criteria:
      - context: $response.body
        condition: $.items.length == 0
        type: jsonpath
  - stepId: reportAvailable
    description: >-
      Read the item master record to report its details now that on-hand stock
      was confirmed.
    operationId: getInventoryItems
    parameters:
    - name: inventoryItemId
      in: query
      value: $steps.resolveItem.outputs.inventoryItemId
    - name: organizationId
      in: query
      value: $inputs.organizationId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      itemStatus: $response.body#/items/0/inventoryItemStatusCode
    onSuccess:
    - name: done
      type: end
  - stepId: reportOutOfStock
    description: >-
      Read the item master record to surface its details when no on-hand stock
      was found.
    operationId: getInventoryItems
    parameters:
    - name: inventoryItemId
      in: query
      value: $steps.resolveItem.outputs.inventoryItemId
    - name: organizationId
      in: query
      value: $inputs.organizationId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      purchasingEnabled: $response.body#/items/0/purchasingEnabledFlag
  outputs:
    inventoryItemId: $steps.resolveItem.outputs.inventoryItemId
    onhandQuantity: $steps.readOnhand.outputs.onhandQuantity
    itemStatus: $steps.reportAvailable.outputs.itemStatus

Work with this as data

Every workflow 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 arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow in the catalog.
  • 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 workflow
curl "https://apis.io/api/v1/arazzo/oracle-e-business-suite-item-availability-check-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?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.

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