ALLOCATION — Oracle Transportation Management Reference

Allocation records for inventory and capacity reservations.

This page documents the ALLOCATION table in Oracle Transportation Management (OTM) -- columns, primary key, incremental cursor, and the exact REST API endpoints used to extract it. This is one of 18 OTM tables that Supaflow's Oracle Transportation Management connector syncs natively into Snowflake, Databricks, BigQuery, Redshift, or Postgres.

Overview

Attribute	Value
OTM export table name	ALLOCATION
OTM metadata resource name	allocations
Composite primary key	ALLOC_SEQ_NO, ORDER_RELEASE_GID
Incremental cursor field	UPDATE_DATE
Category	Reference

OTM REST API endpoints

OTM exposes every table through the logistics REST API. Paths depend on the authentication method you use.

Export API (fetch rows)

POST one of the following URLs, depending on your OTM authentication mode:

• OAuth 2.0 (IDCS): https://{your-otm-host}/logisticsRestApi/data/v1/exportRequests/
• Basic Auth: https://{your-otm-host}/logisticsRestApi/data-int/v1/exportRequests/

Example request body for ALLOCATION:

{
  "schema": "PRIMARY",
  "contentType": "text/plain",
  "tables": {
    "items": [
      { "tableName": "ALLOCATION", "partSize": 5000 }
    ]
  }
}

To pull only rows updated after a given timestamp (the recommended pattern for incremental sync), add a rangeAfter block:

{
  "schema": "PRIMARY",
  "contentType": "text/plain",
  "rangeAfter": { "value": "2026-04-01T00:00:00Z" },
  "tables": {
    "items": [
      { "tableName": "ALLOCATION", "partSize": 5000 }
    ]
  }
}

The response is a CSV payload with the table name on line 1, column headers on line 2, and data rows starting on line 3.

Metadata catalog (fetch schema)

GET the schema for ALLOCATION:

• OAuth 2.0: https://{your-otm-host}/logisticsRestApi/resources/v2/metadata-catalog/allocations
• Basic Auth: https://{your-otm-host}/logisticsRestApi/resources-int/v2/metadata-catalog/allocations

note

The OTM metadata-catalog endpoint returns HTTP 400 for several tables. If you receive a 400 here, fall back to data-driven type inference by sampling rows from the Export API. See the OTM integration guide for the full pattern.

Columns

Column	Type	Nullable	PK	Foreign key
ALLOC_SEQ_NO	NUMBER()		Yes	ALLOCATION_BASE
ORDER_RELEASE_GID	VARCHAR2(101)		Yes	ORDER_RELEASE
SHIPMENT_GID	VARCHAR2(101)	Yes		SHIPMENT
PRIVATE_COST	NUMBER()
PRIVATE_COST_CURRENCY_GID	VARCHAR2(101)			CURRENCY
PRIVATE_COST_BASE	NUMBER()
BASE_COST	NUMBER()
BASE_COST_CURRENCY_GID	VARCHAR2(101)			CURRENCY
BASE_COST_BASE	NUMBER()
TOTAL_ALLOC_COST	NUMBER()
TOTAL_COST_CURRENCY_GID	VARCHAR2(101)			CURRENCY
TOTAL_ALLOC_COST_BASE	NUMBER()
EXCHANGE_RATE_DATE	DATE	Yes
EXCHANGE_RATE_GID	VARCHAR2(101)	Yes		EXCHANGE_RATE
BASE_COST_FN	NUMBER()	Yes
BASE_COST_FN_CURRENCY_GID	VARCHAR2(101)	Yes
PRIVATE_COST_FN	NUMBER()	Yes
PRIVATE_COST_FN_CURRENCY_GID	VARCHAR2(101)	Yes
TOTAL_ALLOC_C_FN	NUMBER()	Yes
TOTAL_ALLOC_C_FN_CURRENCY_GID	VARCHAR2(101)	Yes
DOMAIN_NAME	VARCHAR2(50)
INSERT_USER	VARCHAR2(128)
INSERT_DATE	DATE
UPDATE_USER	VARCHAR2(128)	Yes
UPDATE_DATE	DATE	Yes

Column list source

The column list above is extracted from Oracle's OTM data dictionary included with the February 2025 release snapshot of this connector. Oracle publishes an updated dictionary with every Transportation and Global Trade Management release; for the current version, consult Oracle's Transportation and Global Trade Management documentation.

Incremental sync

The ALLOCATION table supports incremental sync via the UPDATE_DATE cursor. Supaflow's connector handles:

• Server-side clock skew -- measured once from OTM's RFC 1123 Date header and applied to every cursor comparison.
• Late-arriving updates -- configurable lookback window (recommended 300-600 seconds in production) re-scans the tail of the previous window.
• Identical-timestamp batches -- tracks record count at the maximum cursor timestamp so batch updates that stamp thousands of rows with the same UPDATE_DATE don't cause missed or duplicated rows.

Full pattern: The Complete Guide to Oracle Transportation Management Integration.

Sync ALLOCATION with Supaflow

Supaflow's Oracle Transportation Management connector syncs ALLOCATION -- along with 17 other OTM tables -- into your cloud data warehouse with:

• Sync and async (Object Storage PAR) export modes
• Proactive OAuth token refresh (60-second safety margin on IDCS tokens)
• Composite primary key preservation for tables with multi-field keys
• Automatic handling of the five OTM-specific data quirks (metadata 400s, "0" temporal sentinels, Z-suffixed date fields, 1 MB sync-mode truncation, _TEXT / _COMMENT column type overrides)
• Predictable connector-based pricing -- not per-row, not per MAR

Next steps:

• Book a 15-minute demo to see the OTM connector against a live instance
• Set up the OTM source in your Supaflow workspace
• Read the full OTM integration guide