Client Profile

ADS (Atlantic Diving Supply) are prime vendor and leading trading organization of United States of America. It core business to sell the military operation specific equipments and accessories to Army and related organizations.

Project Profile

Customer was looking for all modules to be configured, which are relevant to Supply Chain Management, Logistics, Financials, Procurement and Marketing. HIPL Team has configured following business process / Application modules for the ADS.

ADS core business was running with Zero Inventory, in which most of the Sales Orders are fulfilled with latest purchased done against the demand generated with Sales Orders.ADS is having 3 different inventory operations based on the nature of the items supplied to Military and defense agencies. ADS was using Great Plain (Microsoft ERP system) as legacy system which was configured with open controls. This implementation further extended to setup Multiple Online Stores to provide the easy access of Product Catalog and purchase to ADS’s Customers.

– Available to Promise

– Global Order Promise Process

– Inventory Management

– Warehouse

– Procure to Pay ( Drop Ship and Warehouse Stocking )

– Quote to Cash

– Bill of Material

– Discrete Manufacturing

– Accounts Receivables

– Accounts Payables

– Cash Management

– General Ledger and Financials

– Sales Online

– Lead and Opportunity Management

– Order and Shipment

– Alerts and Notifications with Workflow

– Daily Business Intelligence

– Balance Scorecard

– Discoverer Reports

– Costing Management

– iStore ( e-Commerce Site)

– iPayment ( online payment)

Major Challenges Faced

Standard Oracle E-Business Suite was not perfectly synchronized with ADS Business process. There are lots of challenge come in terms of Business Process, User Training / Education, Legacy Data and Analytical Data needs.

Legacy Data Conversion

Legacy Data Conversion is one of the major challenges for any project, which require lots of analysis to match existing data with oracle application table. ADS were using Great-Plain as legacy business application, which stores different data in different format. Also lots of data, was not sync with master data like Customer and Items of Sales Order doesn’t exist in Master Data set. We have uploaded following legacy data after cleaning of different constraints

§ More than 3000 Customers with 9000 sites.

§ More than 1800 Vendors

§ More than 48000 Master Items

§ More than 100 Kit Items with component configuration

§ More than 2000 Sales Orders with different status (Open, Booked, Fulfilled, Closed, Shipped).

§ More than 500 item’s inventory in hand.

§ More than 2000 Purchases Order with partial receipts.

§ More than 200 Accrued Purchases

§ 36 Months Trial Balance

§ More than 600 lines of Opening Bank Reconciliation.

Net Margin Calculation

Oracle is calculating cost margin on sales based on the actual shipment cost and sales price. But ADS is calculating margin on proposed PO cost and line sales price. Standard Oracle Application is storing such type of information for Drop Ship cases only. This was one of the show-stopper for this implementation and to overcome this issue, we have developed new process.

Drop Ship Accounting

Oracle is doing inventory accounting with single inventory account, but ADS was using different accounting practice for internal sales orders and drop ship sales order. It was again show-stopper for this implementation and ADS doesn’t want to progress further, if this feature is not available. To overcome this issue, we have developed custom process.

COGS Accounting Generation

The matching principle of accounting states that each expense item related to revenue earned must be recorded in the same accounting period as the revenue it helped to earn. But Standard Oracle is generating COGS transaction at the time shipment and revenue at the time of Auto-Invoice process, which sometimes went out of sync. This drawback was one of the major show-stopper and ADS is looking some solution before proceeding on e-Business. To resolve the issue, we wrote different API / processes to change COGS generation pointer and Oracle is able to generate COGS along with revenue generation.

Custom Reservation Allocation

Being a Trading organization, ADS wants to use Oracle ATP process, which help them to better planning and utilization of available inventory, transit inventory and in-pipe inventory after generation of Demand. Co-incidentally this feature was not available with ATO Item types, which used by ADS organization. Due to non-availability of this feature, ADS procured excess inventories for different items. To resolve the issue, we developed one custom process to recalculate the demand vs. supply.

CAGE File Process

Being a prime vendor, ADS is receiving remittance from bank in electronic format, which known as CAGE File. But standard oracle lockbox process did not support CAGE Format. This resultant ADS was not able to process remittance on time and users need to do manual transactions capture for the same. To resolve the issue, we developed one custom process to convert CAGE File Format in to Oracle accepted bank format.

AR Invoice Incomplete Process

As per Oracle intended feature, All Auto-Invoice Transaction gets created with complete status and if anyone ran AR GL Transfer process, Oracle posts invoice to GL. But in normal cases, ADS applied some adjustments / discounts on different invoice and user failed to apply the same due to posting of transaction. To resolve the issue, we developed one custom process to create transaction with incomplete status.

Oracle Mobile Application Supply Chain Management

Oracle provides facility to use mobile application to do application transaction with the help of with the help of handheld device. This device help user to scan barcode of item / document and transact on Oracle Application with Oracle Mobile Application.

Daily Business Intelligence

Daily Business Intelligence or DBI is used to provide macro level information with graphical presentation of different data sources. This help top management / executives to take important decisions and analysis. We have configured DBI for Financials, Inventory, Sales, Marketing, Expense, Payables and Profit & Loss etc.