Complete Oracle SCM Cloud Integration Guide

CubeMaster API Integration Guide

Using Oracle Supply Chain Management (SCM) Cloud (REST API & OIC)

Generate an API TokenID to authorize Oracle Integration Cloud (OIC) or direct Oracle SCM REST adapters:

  1. Log in to CubeMaster Online.
  2. Go to Settings > Integration > API Keys.
  3. Copy your key (e.g., oracle_scm_live_77189a). Pass header TokenID: your-token-id-here.

In Oracle Integration Cloud (OIC), create an Outbound REST Connection:

  1. Go to Integrations > Connections > Create REST Adapter.
  2. Connection URL: https://api.cubemaster.net
  3. Security Policy: API Key Authentication (HTTP Header TokenID).
  4. Add REST Trigger on Oracle SCM Shipment Line status change (`ShipmentLines.ReleasedToWarehouse`).

Map Oracle SCM item attributes (`ItemNumber`, `PrimaryUOMVolume`, `UnitWeight`) to CubeMaster POST JSON payload:

{
    "Title": "Oracle SCM Shipment #SHIP-77192",
    "Description": "Automated Container Load Plan",
    "Cargoes": [
        {
            "Name": "ITEM-ORACLE-01",
            "Length": 60.0,
            "Width": 40.0,
            "Height": 50.0,
            "Weight": 600.0,
            "Qty": 20,
            "OrientationsAllowed": "OrientationsAll"
        }
    ],
    "Containers": [
        {
            "VehicleType": "Dry",
            "Name": "40FT-High-Cube",
            "Length": 472.0,
            "Width": 92.0,
            "Height": 105.0
        }
    ],
    "Rules": {
        "IsWeightLimited": true,
        "FillDirection": "FrontToRear",
        "CalculationType": "MixLoad"
    }
}

Receive CubeMaster's optimized container count and 3D diagram links into Oracle Shipping Execution (`WSH_DELIVERY_DETAILS`):

{
    "status": "succeed",
    "loadSummary": {
        "piecesLoaded": 20,
        "volumeLoaded": 5900000.0,
        "weightLoaded": 12000.0
    },
    "filledContainers": [
        {
            "name": "#1 40FT-High-Cube",
            "loadSummary": {
                "volumeUtilization": 89.2
            },
            "graphics": {
                "images": {
                    "path3DDiagram": "https://api.cubemaster.net/runtimes/oracle_scm_3d.PNG"
                }
            }
        }
    ]
}