Distribution and Logistics

The solution was developed for a Customer who is a prime vendor for US MOD for providing the Special military operation equipments and accessories to Army and associated organizations.

Industry Segment: Distribution And Logistics

Project Status: Initial implementation project was completed in 2006 and is currently under annual maintenance support

Project Profile

it was a comprehensive implementation of all the modules which are relevant to Supply Chain Management, Financials, Procurement and Marketing. HIPL Oracle Team configured the following business process / Application modules for the project.

• Accounts Receivables
• Accounts Payables
• Cash Management
• General Ledger and Financials
• Inventory Management
• Warehouse
• Procure to Pay ( Drop Ship and Warehouse Stocking )
• Quote to Cash
• Discrete Manufacturing
• Sales Online
• Lead and Opportunity Management
• Order and Shipment
• Bill of Material
• Alerts and Notifications with Workflow
• Daily Business Intelligence
• Balance Scorecard
• Discoverer Reports
• Costing Management
• iStore ( e-Commerce Site)

Major Challenges Faced

• Data conversion and migration from Great-Plain to Oracle E-Business which stores data in different format
  
  
• More than 3000 Customers with 9000 sites
  
  
• Net Margin Calculation in Oracle is cost margin on sales based on the actual shipment cost and sales price. But customer is calculating margin on proposed PO cost and line sales price for which the custom process is developed
  
  
• Being a prime vendor, the customer receives remittances from banks in an electronic format, which is known as a CAGE File. The standard Oracle lockbox process did not support this CAGE Format. So, our Oracle expert team developed a customised process to convert the CAGE File Format to an Oracle accepted bank format.
  
  
• Implementation of Oracle Mobile Application Supply Chain Management
  
  
• Daily Business Intelligence or DBI is used to provide macro level information with graphical presentation of different data sources for Financials, Inventory, Sales, Marketing, Expense, Payables and Profit & Loss etc.