Inventory Management System
The Opportunity
A major FMCG company required an Inventory management system to manage and track the inventory of its plant and warehouse and integrate the inventory movement with their existing Oracle Process Manufacturing application and other legacy applications.
Our Approach
- Provide a user friendly application to allow user to perform various inventory movement operations and to interact and manage the inventory movements with OPM.
- Allow user to perform different inventory movements at UOM level
- Manage/Track the inventory of Plant (Manufacturing/Plant warehouse) and Distribution Center.
- Capture the inventory movements performed through other application between Plant, DC and Customer, by defining proper interfaces.
- Provide views and reports product-wise/warehouse-wise to view the on line Inventory for Product at PLANT/warehouse and logical location level.
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
- On line inventory available for products at all levels of storage viz. Plant, Warehouse and logical location levels
- Automated interfaces to all the other applications which affect the inventory, hence providing a consolidated view, to manage the inventory movement between the Plant, DC and Customer.
- Manages the inventory movement between Plant Warehouse and Supplier.
- Manages the inventory movement with Plant Warehouse and Plant Manufacturing.
- Physical movements of inventory can be tracked against the theoretical movements.
- Reports for various inventory movements' product wise and warehouse wise
