 |
 |
 |
 |
 |
 |
 |
| Global Order Fulfillment system for a Fortune 500 company: The client is a chemical, materials and energy major and one of the world's most innovative companies. The company has an integrated customer service system. It seeks a Global Order Fulfillment Process solution to serve customers in the Americas, Europe and the Asia-Pacific region. The system must offer the full spectrum of functions from order receipt up to payment, spanning order receipt, commitment, order entry, order pricing, order management, shipping, invoicing, collection, product returns and complaint handling. The system's original Oracle 6 database was converted to Oracle 7.2.3. The application has programs in a wide variety of Oracle products like SQL*Forms 3.0, Oracle Reportwriter, Pro*C, RPT, PL/SQL and SQL Reports. The front end menu interface was built using C, so support and maintenance was a great challenge with manuals/documents and even Oracle support missing. The system interfaces with the Kanban manufacturing system. The finished goods data is continuously loaded to the integrated customer service system by a background process. Using the data from Kanban, the system does automatic allocation of new quantities to waiting orders, thereby keeping priorities of the Order requests under control. Using this system, the company strives for a 100% in-time shipment of the orders. The data interface between the two systems is an ASCII file. The system uses Portable Netware Protocol for accessing the Kanban data file. The other interface is the MOS system in Europe that invoices all the orders. The whole MOS interface involves a series of Batch programs. The system creates an ASCII file for MOS which does the invoicing, and then sends back the feedback file. This file is used to update the shipping/invoice information in the system. Infinix added several new features to the Global Order Fulfillment Process. Order acknowledgements are now printed for European Orders entered by European customer sales representatives in their respective sites. It involved an elaborate analysis of the European Customs and legal requirements that differ in many ways from the US. A majority of the Kalrez products are single part items handled by the system. Now, the system has been enhanced to store and track Kalrez seal kits that consist of up to 7 different parts. It facilitates information delivery to Kanban, schedule parts of these Kits for production and alert the respective personnel to place orders for non-Kalrez parts. Top |