The solution was built in JSP to interface with Microcontroller with IP based access for each Kardex Shuttle. The interface software was hosted on Tomcat on Linux Server. Application is handling the complete stores and the material locations were stored in database. For storing the material in to system, the material was fetched from Purchase Receipt entry from Oracle EBS and then it was saved into database with Kardex location. The complete tray call /send was managed through our software.
The key part in this application was material issue management and inter organization transfer for changing material allocations. We did all the operation through single screen. The consolidation of shop order was done to save the material picking time. Also, the shortage items were separately managed. We provided facility for pending receipts the data was fetched from Oracle EBS, so the store manager was able to trace the material movement before it arrives physically to stores.
For production department the correct and fast shop order issue is a critical thing, it improves the production capacity greatly. It was observed that our interface software has reduced the time required for issue by 40% which has resulted in considerable increase in the organization revenue.