OTM Developer Workbench

One workspace for building, exploring and troubleshooting Oracle Transportation Management.

OTM 26C

YOUR OTM DEVELOPMENT WORKSPACE LOCAL TOOLKIT

Build. Configure.
Integrate. Troubleshoot.

Everything you need to work with Oracle Transportation Management, organized around the way you work.

WORKSPACE DIRECTORY

Development tools

Choose a tool by workflow. Your existing modules are grouped here.

ROADMAP

Planned development modules

Future capabilities are shown separately from tools that are already available.

⇄REST API WorkbenchPrepare requests, inspect responses and organise OTM REST API test scenarios.Planned · Not available yetPLANNED

⌘XSLT ToolkitInspect, format and test XSLT mappings used in OTM integrations.Planned · Not available yetPLANNED

⇆Configuration CompareCompare selected OTM configuration extracts and prepare migration review checklists.Future idea · Scope to be definedFUTURE

QUICK START

Get started

Common tasks, one click away.

YOUR WORKSPACE

Recently used

Open a frequently used tool.

✦

Workbench highlightsDesigned for OTM development

✓ SQL building and metadata exploration
✓ XML / JSON payload development
✓ Guided Order Release generation
✓ Configuration and troubleshooting help
✓ Local browser-based utilities

OTM 26C referenceConfirm environment-specific details before use

▤2,411Documented tables

▦38,782Documented columns

</>16Business areas

✓26CWorkbench reference

Query Builder

Business object

Query type

GID / XID (optional)

Domain name (optional)

SQL Editor

Ready. Generate a query or paste your own SQL, then run a check.

Quick reference

Shipment lookupShipment header and domain filter

Order Release lookupRelease details by GID

Shipment ↔ Order ReleaseStarter ship unit relationship pattern

Domain distributionCount records by domain

Safety checklist

Read-only firstPrefer SELECT for analysis. Avoid UPDATE / DELETE / INSERT in production.

Domain filteringCheck whether DOMAIN_NAME filtering is required for the target object.

Join validationConfirm relationship keys and cardinality before joining.

PerformanceFilter early, avoid SELECT *, review execution plans with DBA support.

PHASE 4 · DEVELOPER TOOLKIT

XML / JSON Payload Studio

Format, validate and inspect integration payloads — directly in your browser.

Local processing · No API calls

Input payloadPaste or edit your source XML / JSON

01 · INPUT

OutputFormatted or validated result

02 · OUTPUT

Ready · Paste a payload and select an action.

PATH TOOLS

XPath / JSONPath

Generate paths directly from the payload above. No need to paste the payload again.

Paste your XML or JSON in the editor above. Click Generate to list every discovered element, attribute or property with its path.

Your payload stays in this browser tab. Nothing is submitted to OTM or stored on a server.

PAYLOAD ANALYSIS

Compare XML / JSON Payloads

Compare two versions to identify added, removed and changed fields. Formatting-only whitespace is ignored for XML.

Payload A · OriginalPaste the original XML / JSON

01 · BEFORE Differences found

Payload B · UpdatedPaste the updated XML / JSON

02 · AFTER Differences found

Paste two payloads in the same format, then select Compare payloads.

Comparison runs locally in your browser. Payloads are not uploaded or sent to OTM.

STRUCTURED OTM FORM

Order Release Generator

Build configuration-specific OTM Order Release XML with guided fields, repeatable lines and an instant output preview.

ORDER RELEASE

RELEASE CONFIGURATION

DOMAIN NAME

ORDER RELEASE ID (XID)

SPLIT ALLOWED

MODE PROFILE GIDEnter XID only, or DOMAIN.XID when domain is required.

ORDER RELEASE DATES

EARLY PICKUP

LATE PICKUP

EARLY DELIVERY

LATE DELIVERY

LOCATIONS

LOCATION DOMAIN

SHIP FROM LOCATION XID

SHIP TO LOCATION XID

SHIP UNITS & LINES

Each line belongs to its Ship Unit. Matching ShipUnitContent references are generated automatically.

RELEASE REFNUMS

Only the Refnums entered here will be generated. Existing sample Refnums are removed.

ATTRIBUTE SELECTIONS

Select Attribute1 through Attribute20 and enter its value. Only selected attributes are generated under FlexFieldStrings.

SINGLE PAYLOAD OUTPUT FORMAT

All formats use the same form values and selected release configuration.

Choose a release configuration, enter the required details, and generate your XML.

OUTPUT

GENERATED ORDER RELEASE PAYLOAD

XML preview will appear after generation.

FORM-BASED BULK GENERATION

Bulk Order Release Generator

Generate multiple Order Release payloads using the configuration and fields entered in the Order Release form above.

RECORD COUNT (MAX 1,000)

STARTING SEQUENCE

ORDER RELEASE ID PREFIX

OUTPUT FORMAT

Common form values are reused. Order Release, Ship Unit and Release Line identifiers are regenerated for each record. The selected form configuration, dates, locations, Refnums and attributes are carried into every payload.

Complete the Order Release form, then set the bulk options.

BULK OUTPUT SUMMARY

No records generated yet.

GENERATION MANIFEST · JSON

Bulk output is generated from the Order Release form. JSON is generated as an XML-equivalent representation of the form-built Order Release. Confirm field names and resource envelopes against your approved OTM REST API or Transmission contract before sending to an environment.

WHAT'S NEXT

Payload Studio roadmap

The next capabilities will be added in planned releases.

6 capabilities

Editor & ValidatorFormat, minify, validate, copy and download XML / JSON.

Available · Open ↗ 02

XPath & JSONPathSelect document nodes and generate paths for XML elements or JSON properties.

Available · Open ↗ 03

Payload ComparisonCompare two payloads and identify structural or value differences.

Available · Open ↗

OTM Sample LibraryBrowse payload examples backed by verified OTM samples.

Planned · v0.11.3

Bulk Order Release GeneratorGenerate XML and JSON payloads from the Order Release form.

Available · Open ↗

Advanced UtilitiesXML tree, XML ↔ JSON conversion, template manager and size analyzer.

Planned · v0.11.4

OTM examples and mandatory-field checks will be marked verified only when supported by your supplied samples or approved documentation.

OTM DATA DICTIONARY · 26C

Advanced Metadata Explorer

Build a query visually: select OTM tables, connect them through configured relationships, choose columns and review the SQL.

Loading metadata...Tables and columns

—Tables

—Columns

—Configured relationships

0Selected tables

2. Configure query

Select one or more tables from the left.

Available RelationshipsAutomatically opens when you select a table. Choose only the joins you need.Select a table to discover joins

Select a table to discover its configured relationships.

Select two or more tables to see the visual join canvas.

OTM DATA UTILITIES · v0.18.27

OTM Rate CSV Generator

Upload your Rate workbook, validate the predefined OTM Rate rules and generate CSV files in the correct import sequence. Files are processed locally in your browser.

NO AI REQUIRED

01Upload workbook

02Validate & generate

INPUT WORKBOOK

Upload Excel file

↑

Which Excel file should I upload?

Upload the source Rate workbook that you currently use with your Rate Upload VBA process. Do not upload the generated RATE_GEO.csv, RATE_GEO_COST.csv or other output CSV files.

The supplied workbook includes Rate Record, TRANSPORT MODE, GEOGRAPHY TYPE, Sheet1, Accessorial Cost, Rate Refnum and RATE_COSTBAs lookup values. The CONDITION PARAMETER and Cost Basis dropdowns are preconfigured. Keep the worksheet headers and lookup values intact.

↓ Download updated Rate Upload template Includes the latest Instruction sheet, Rate Record layout, RATE_COSTBAs lookups, dropdowns and unit-break fields. Use this workbook as the source template for CSV generation.

⇧Upload your source Rate Excel workbookor click to browse · XLSX, XLS, XLSM

No workbook selected

Privacy & credentialsWorkbook data is processed in this browser and is not uploaded to a server. The Configuration sheet is excluded from mapping because it may contain connection credentials. Enter DOMAIN_NAME in the first column of every Rate Record row; this is mandatory for GID generation. Remove active passwords from shared workbooks.

GENERATION PROFILE

Choose output package

▤

Template profile

Predefined OTM Rate rules generate the eight supported table structures. Field mappings are handled automatically; no manual mapping is required.

OUTPUT

Validate & generate

✓

Standard CSV structure

Row 1Table name only (e.g. RATE_GEO)

Row 2Target table column headers

Row 3EXEC SQL date-format statement

Row 4+Generated data records

Upload your Rate workbook, select the required output tables, then validate and generate.

OTM Developer Workbench

Build. Configure.Integrate. Troubleshoot.

Development tools

Planned development modules

Get started

Recently used

Query Builder

SQL Editor

Quick reference

Safety checklist

Starter OTM table catalog

SQL Checker

Predefined OTM Query Library

Unified SQL Builder · v0.7.0

1. Select tables

2. Select columns

3. Add filters (optional)

4. Generated SQL