OTM stands for Oracle Transportation Management and it is a software product designed to automate various logistics business processes like receiving orders from source ERP systems for freight consolidation, optimizing routes and shipping costs, sending …
Basic Logistics terminology
If you are a developer and not having logistics domain knowledge and want to quickly gain some insight, here are some basic logistics terms that you need to be familiar with.
Carrier: Carrier is the service provider(SP) for freight movement from one …
OTM Architecture
OTM application has a typical three tier architecture. It has web tier, app tier and oracle database as third tier. These three components can be installed on separate servers (Linux/Windows) or they may be installed on the same server. Usually for lower …
OTM Inbound Integrations (XML)
There are several ways of bringing in data into OTM system. Below are some of the methods:
- via XML that follows Glog XML schema posted from a middleware applications like Oracle SOA, webMethods, Mulesoft, etc
- Manaul XML uploads by OTM users
- CSV Uploads …
OTM Outbound Integrations
OTM system can generate outbound XML data for any business object like ‘Order Release’, ‘Shipment’ etc either manually(using Send Interface Transmission action) or programmatically using same action from OTM Agent(workflow). We will …
CSV Data Uploads
We can load data to OTM is using CSV files. You can follow below steps to load location into OTM using CSV upload. Note that same steps are applicable to any OTM object like order release,shipment, invoice, etc.
1. Create a sample location manually in OTM …
Posting Data to OTM using HTTP request
Any external system like EBS, SAP can frame this XML structure programatically and ‘POST’ this xml to OTM Integration servlet: glog.integration.servlet.WMServlet
Below is an PLSQL program posting Location element to OTM:
DECLARE
-- This is OTM …OTM Domains, Standard Schema and Data Dictionary
Domains:
OTM Data is organized into domains. Each domain is like grouping of data / business transactions based on the different business units with in the same organization.
If there is a corporation with logistics requirements across various business …
OTM Order Management Data Structure
Purchase Order
PO record will have the basic details like source location, destination location, INCO terms, Item number, Qty etc. Note that PO might not have exact weight/volume details that might be required for planning orders. Usually POs are created …
OTM Shipment Management Data Structure
Shipments
Shipment will have - Equipment(s), Shipment Ship Units within an Equipment, and Shipment Ship Unit lines within a Shipment Ship Unit.Note that at shipment level, ship units are always tied to equipment.
So, if a order release ship unit has …