Oracle OTM Container Tracking Saves $150K Annually for Agribusiness Leader

About the Client

A $5B privately held U.S. company in the Agriculture, Food & Beverages, and Consumer Packaged Goods sector. With fully integrated operations, from farm to shelf, they manage a diverse portfolio including fruits, nuts, flowers, water, wines, and juices. The company is the world’s largest grower of tree nuts, the top citrus producer in the U.S., and the global leader in flower delivery.

The Challenges

The client’s existing tracking tool from a third-party provider was expensive and offered limited container visibility.

Licensing costs were excessively high
Tracking data lacked details required for operational decision-making
MarineTraffic API was identified as a replacement but mapping its data to Oracle OTM proved technically challenging
The client faced a strict deadline: the old system had to be phased out before license renewal, leaving no room for delays

The client needed a solution that would cut licensing costs, deliver detailed real-time shipment visibility, and integrate seamlessly with Oracle OTM and EBS.

The Solution

Our team designed a robust, modular integration framework using Oracle OIC and PL/SQL to replace the legacy tracking service.

Key solution highlights:

Business-Critical Events Identified – Defined essential events for tracking BOLs and containers.
MarineTraffic API Integration – Orchestrated API calls through Oracle OIC for accurate vessel and drayage tracking.
Custom Rules Engine – Developed a PL/SQL program to derive voyage and container event details from OTM and MarineTraffic data.
Reusable, Scalable Design – Modularized integrations to ensure scalability, efficient error handling, and easy debugging.
Seamless System Integration – Combined Oracle OTM, Oracle EBS, MarineTraffic APIs and PL/SQL for a unified solution.

The architecture emphasized accuracy, scalability, and real-time decision-making.