Oracle EBS AMS Support and Rollout

Industry:
Opticals

Oracle EBS AMS Support and Rollout

Industry:
Opticals

Client Overview

Leading Ophthalmic Lenses and Equipment Company committed to providing solutions to correct and protect the visual health of the 7.7 billion people worldwide.


Project Scope

  • AMS client for over five years.
  • Supported 11 Legal Entities, 11 Set of Books, 12 Business Units, 12 Operating units, 150 + Inv Org.
  • Ten Rollouts for new business acquisitions.
  • Global Best Practices and Statutory Compliance - GST Implementations.
  • Multiple fit gap solutions for complex business processes.
  • ChainSys appConnect tools used for complex integrations.
  • Server migration from On-Prem to Data Center.
  • Implemented Disaster Recovery.

Environment

  • Oracle E-Business Suite R12.1.3
  • Modules: Oracle General Ledger, Payable, Receivable, Fixed Assets, Cash Management, Procurement, Inventory, Order Management.
  • Salesforce Applications.
  • ChainSys :  dataZap for Integrations, and Testing.

Business Situation

  • Oracle E-Business Suite R12.1.3
  • Modules: Oracle General Ledger, Payable, Receivable, Fixed Assets, Cash Management, Procurement, Inventory, Order Management.
  • Salesforce Applications.
  • ChainSys :  dataZap for Integrations, and Testing.

Key Challenges

  • Continuous business growth through Mergers & Acquisitions
  • When we entered the support the ticket volume was over 6000 per year.
  • Need to Interface MES, Excellence, NextGen and other boundary application
  • Mapping Point of Sale(Rx.Net) system with Oracle master data 
  • Handled large volume of POS data and Prevent data loss.
  • Complex sale order scenario for Lens / OSD / NVG
  • Overall application performance and change management issues.
  • Tax Localization on Brazil, India and Israel 
  • Mapping of Margin ‘O’ / CARS (Capital Adequate Reporting Systems) reporting from Oracle.

Solution

  • Optimized Procurement process and overall processing time reduced by 40%.
  • Visibility of Lead Time and ETD with accurate delivery dates.
  • 110 pre-validations are introduced with integration between POS and Oracle EBS to improvise the data integrity and application performance. 
  • 4 million records are processed every half an hour through appConnect tool. 
  • GL Code / Tax mapping customized to fit to the complex statutory needs. 
  • Inventory automation from Manufacturing Lab to POS
  • Outright tracking of QA documents from End to End
  • Complex custom invoice bolt-on solution provided and optimized systems. 
  • Custom receipt form solution provided for ophthalmic optics business scenario and final receipt details are integrate with Oracle Inventory, Receipts and Payable. 
  • Complex solution and Formula mapping in Oracle COA for CARS / Margin ‘O’.

Business Process Flow

Benefits

  • Reduce the maintenance cost on the existing legacy system.
  • Real time visibility on point of sales.
  • Reduce the total number of process steps from invoice creation in Rx system through invoice (FAIR) processing to Oracle EBS.
  • Reduce the work effort for Inventory and Financial reconciliation process.
  • Automated Inventory Replenishment.
  • Timely resolution and Adhered to the SLA.
  • Dashboard - DPO, DSO and DIO.
  • Capital adequacy ratio standards.

Reference

No items found.