Case Study 1: 

The Client: Our Client and Engineering Electro-Mechanical Manufacturing company with the Mother Company having Oracle Application E-Business Suite 12.1.3 and was running on their premises in their data centre. The Operating System was Windows environment. On the other hand the subsidiary was using Tally to maintain their Financial Accounting.

It was necessary to Rollout the Business Scenario of the subsidiary as absolutely currently configured environment at the instance of Mother company,    and bring the two legal entities under a common platform with identical configuration and setup to maximum possible extent.

Business Needs:  Implemented Oracle E-Business Suit (Version 12.1.3) with basic financial modules of finance with General Ledger, Payables, Receivables, Cash Management, Fixed Assets, Advance Collection,  India Localization Tax(mother company had EB Tax implemented for their Legal Entity) , Purchasing & Receiving, Inventory, Warehouse Management, Order Management, Shipping,  Advance Pricing and Manufacturing including BOM, Engineering, WIP,  Cost Management and Planning .

Challenges:  

1. COVID99: Outbreak of COVID99 restricted the movement of the consultants causing unforeseen delay. 
2. Customization: The mother company had many customizations which required knowledge transfer.
3. India Localization Tax: The mother company being a Foreign Company KT and Training of the Core Team on the rules and process of India Localization Taxes.   
4. Inter Company Transfers: The client was having intercompany transfers between two legal entities residing in India and abroad. 
5. Project wise Costing: There was a requirement to generate a report which will show monthly costing project wise.

Solution:

Since the client needed a robust application by which they can capture cost at the project task level, manage cost and revenue budget, generate Invoices from projects and recognize revenues.  At the same time, the client required an application by which they can track and control the activities performed at different project sites. At the end of every month, the client wanted to see the performance of every project as well as task and project wise cash forecasting.

Conacent proposed the client to implement two modules Oracle Project Costing and Oracle Project Billing for handling their project costing and billing operation. In addition to these two modules, Conacent suggested to develop a custom bolt-on Application to address the above mentioned challenges. 

Strategy:

Leveraging the implementation, a team of 7 experts from Conacent decided on the methodology and approach to rollout and implement the Oracle Application R12.1.3 to achieve process efficiencies. Conacent, using Oracle solutions, streamlined the manufacturing, distribution, procurement and financial accounting processes of the client. 

 Executive involvement and support continued throughout the project. Prior to initiating the process the mother company and their subsidiary provided a brief overview of their AS-IS and business process as they did not have any documented process flow or business flow of the legacy system. The Chart of accounts although had different segments both in numbers and in types including their values they ware mapped in terms of identity and values. The commons were identified programmatically and verified manually and the remaining additional values of the individual segments were uploaded using data migration scripts. The same approach was followed in case of migration of all the master data.

In case of migration of Open transactions and balances all data was collected on a cutoff date and then it was transferred from the old system to the merged-consolidated system using migration scripts and at times using data loaders / Web ADIs.   

Training was provided to the end users of both the Mother Company and subsidiary company to adopt the new processes and changed steps of the parent company.

Benefits:

• The implementation imparted high visibility to the Manufacturing and improved planning and execution
• There was a significant improvement in cash flow due to real-time processes. A large number of processes have been automated, which has increased the efficiency and reduced overhead costs
• Timely delivery and proper order booking increased due to online on-hand availability.
• The client witnessed significant improvement in its on-time delivery record due to the processes and applications implemented.
• Reduce reconciliation activity
• Online BS/PL 
• A large number of manual practices were systematized.
• Excel dependency reduced   to a great extent.
• After nine months of team effort the project was successfully launched and modules were put into production and the ERP system achieved its expected potential very quickly. We had executive support for pursing ERP. They began their venture by identifying, streamlining and even documenting their business practices and provided extensive education that spanned the organization.