Oracle EBS AMS Support

Pharma Manufacturer

Oracle EBS AMS Support

Pharma Manufacturer

Client Overview

Since its inception in 1941, the client  has been known as a pioneer in the area of crop protection chemicals for the Industry as well as the farming community. Today it has successfully leveraged its strengths to emerge as a leader in a range of speciality and performance chemicals.                                                

India’s leading chemical/Pharma manufacturer with 1500+ Employees and over Rs.702 Cr annual revenue.

Project Scope

  • AMS client for over eight years
  • Database upgrade 10.2.04 to 11.0.3
  • Upgrade from  Oracle EBS11i to R12.1.3
  • Implementation of GST Implementation, iProcurement and Fixed Assets.


  • Oracle E-Business Suite R12.1.3
  • Oracle General Ledger, Account Payable, Account Receivable, Fixed Assets, Cash Management, Inventory, Purchase, Order Management,   Oracle Process Manufacturing.

Business Situation

  • Complicated OPM Costing Distributions for Inventory Transfers across Organizations
  • Batch Job is Released and then Cancelled while ingredients are Picked
  • The recipe is adjusted after Ingredients have been Picked
  • Detailed Batch Job Report includes Ingredients picks to Sales.

Key Challenges

  • Transferring the material(ISO) within the organization, Operating Unit and out OU based on Physical location GST regime wise
  • AOP Production and Budgeting
  • Timely approval of PO's and PO Report automation
  • Difficulty in timely closing of Periods
  • No proper knowledge on period closures
  • Manual calculation of Batch cost due to many out of system calculation involved
  • Automation of the RMA process after GST
  • Accounting problem in system due to lower GST patch
  • Quality check result communication between the departments in the system
  • Difficulty in GST claim location wise and frequent changes of TDS Rates.


  • Implemented multiple ISO order type within the OU and out of OU based on physical location. Separate report made for the user to know the current ISO order type in system
  • Planning and Budgeting Cloud Service product is suggested to the client for AOP production and budgeting
  • Given continues training to the users for the new functionality in system and providing crispy SOP for their reference.
  • Many new requirement as per latest government notification are configured in system as per client requirement apart from oracle standard functionality
  • Accounting and many GST related issues are solved after applying the GST latest RUP 11 patches for smooth functioning of the system
  • Automated PO copy through Email to supplier directly from the PO once it is approved without manual interventions.

Business Process Flow


  • Cash management module solution reduced the unnecessary  workaround entries related banking transactions
  • Able  to perform the Period Closure within first 5 days of every month without any major issues
  • Bank Reconciliation was done manually before Upgrade. We configured the BRS in R12 to make the Bank Reconciliation process automation.
  • Oracle 11g database upgradation with minimum downtime
  • Instance Performance was optimized.
  • Minimal blackout time provided for production upgrade
  • Increasing in Enhancement accumulated with in the AMS.
  • RCA help to avoid repeatable issues.


No items found.