Handheld Computer System Development, Inventory Management Systems, Host Validation System - Project Executed by SPEC-India.com
 

Order Management System

The Opportunity

A major FMCG organization wanted an Integrated Order Management System, which could take care of creation of orders raised through their various business model viz. Direct Customer Orders through EDI, Internal Orders (manual and through Demand Resource Planning), Door to Sales customers (integration with hand held device application).  The orders raised have to be managed right upto the delivery. There are various delivery models that need to be addressed, viz. Common Carrier, Company Truck, Customer pick-up, third party logistics delivery, and DTS delivery.

Our Approach

Provide User Friendly application to allow user to perform order management activities like Internal Order, Customer Order, HHC Order, BIN-Route order, 3PL order.

Provide Order Entry for OT Customers with following methods:
  • Manual Order Entry
  • EDI (Electronic Data Interchange)
  • HHC Order Entry
Provide Order Delivery using following methods:
  • DC or Plant Shipment (Through Company Carrier or External Carrier)
  • HHC Driver Delivery
  • 3PL Delivery (Delivery through 3rd Party Logistic provider)
Provide interfacing with other applications for the data exchange:
  • 3PL System (to send orders and receive order status)
  • HHC (Order receiving and delivery)
  • Billing applications
  • EDI Corrections and approval
  • OPM Application for required inventory data
Our Solution
  • Develop solution using J2EE Technology (Java, JDK 1.3.1, EJB) and using Oracle 9i Application Server and Oracle 9i Database along with required calls to Oracle Process Manufacturing Application
  • Usage of MVC architecture to enable ease of maintenance
  • Usage of Session Facade and Proxy design patterns
  • Usage of Java Swing components to develop User Interfaces which have a high usability
  • Transaction Management is achieved through Container Managed Stateless Session Beans.
Business Benefits
  • One single application catering to a varied number of business models.
  • Open design of the application allows the business to manage various customer types, warehouse types, shipment / delivery types etc.
  • Ease of use through mass update functions.
  • Automated interfacing with varied applications with error reporting and error correction mechanisms.