Complex Data Cleansing for a Digital Transformation from Oracle to SAP

Industry:
Automotive Car Company

Client Overview

The client is the 4th largest car manufacturing unit in India, with two manufacturing units set up in South India on Bangalore's outskirts. They employ almost 6000 employees with a production output of over 150000 units per year and an operating income of almost Rs. 20000 crore.

Project Scope

The scope was split into three separate Projects based on the revised approach. The initial scope was to migrate from the existing Oracle EBS system to SAP S/4HANA, with MM, FI & SD being the modules focused on. However, this was later revised to just FI & SD being the operative modules with MM at a later juncture. ChainSys was involved in the migration of all Master data and Transactional data from Oracle EBS to SAP S/4HANA. 

Once the revised approach was confirmed, the integration of open Invoices, which would continue to be prepared in Oracle EBS, was also handed to ChainSys. This involved integration of Invoices of Raw Materials and Services procured locally, Spare Parts sourced locally, imported as well as Fixed Assets, sourced locally & imported.

As per statutory requirements, one full year transactions should be in one system for financial auditing purposes. Since they went live in the mid of the financial year, they moved historical data from EBS and current transactions from S/4 HANA into SAP BW. For Audit purpose, developed 100+ dashboards.


Business Situation

Following the revised approach, it was decided that all payments to all stakeholders and creation of Sales Orders for automobiles as well as spare parts would be made through SAP S/4HANA, but the MM-related actions such as the creation of new Items, new Vendors as well as Purchase Requisitions, Contracts, Purchase Orders, Goods Receipts would continue in Oracle EBS till MM migration was completed.


Technical Situation

The current system being used as a heavily customized version of Oracle EBS, which was used for all modules. Following the mandate from the parent company, the decision was made to shift from Oracle EBS to SAP S/4HANA. A myriad of issues cropped up as S/4HANA is a more rigid system with validations for almost all fields and character limitations that are not present in Oracle EBS.

Solutions

Chain-Sys prepared validations for cleansing of data maintained in Oracle EBS as shown below:

  • For Customers & Vendors in EBS migrated as Business Partner in SAP, State was a text field in EBS without any validations. During migration, this became an issue as State (Region) in SAP was a validated field based on the country (eg. Karnataka is maintained as 29, Tamil Nadu as 33). But in EBS, the State was usually incorrectly spelt (eg. Karnataka was maintained as Karantaka, Karntaka, Karnatak, Tamil Nadu was maintained as Tamilnadu, Tamil Nad). Chain-Sys was able to cleanse the records by maintaining data correctly as per SAP standards.
  • Postal Code in EBS was also a text field in Oracle EBS which allowed for extra characters to be input (eg. 641 037). Chain-Sys prepared a logic with our tool to validate the Postal Code as maintained in Oracle EBS based on the country and remove unwanted characters like (space) or hyphens, thereby migrating the correct data to SAP.
  • Contact details such as phone numbers in SAP are validated and do not allow special characters (eg. “+” or “-”). Chain-Sys was able to prepare a logic to remove these special characters, thereby maintaining the contact details while staying within the validation rules of SAP.
  • Item Number in SAP is character restricted to 20 characters due to the database structure. There is no character restriction for Item Number in Oracle EBS. Chain-Sys was able to truncate the data from EBS before entering it to SAP. For any duplicates available due to the truncation, it was handed by the addition of a “/1”,”/2” to differentiate.
  • EBS AP invoice numbers are mapped to SAP Reference field, but the data for EBS AP invoice numbers had many user-entered special characters such as space, comma which made it difficult to move into SAP. The Business wanted to make the invoice numbers without any special characters when moved to SAP, so with the tool, we built a logic to cleanse all the invoice numbers as per the Business requirements.
  • EBS AP invoice numbers, which are mapped to SAP reference was having many duplications in EBS, but when its moved to SAP there was a duplicate check which does not allow the same reference numbers with respect to the same vendor number. So the Business wanted to identify the duplicate invoice numbers and add suffix to the invoice numbers with /1 , /2 and so on. The same logic has been built in the tool and the data is being cleansed while extracting it.
  • In EBS AP invoices had scenarios where if the invoice is posted against asset the budget code is wrongly entered with revenue budget and when invoice is posted against expense item and budget is wrongly entered with capital budget, so the Business wanted us to cleanse the data by loading into SAP with a dummy budget code for expense item and one for revenue budget. The same logic was built in the tool and the requested budget codes were moved into SAP.
  • Some of the EBS invoices were posted without a Cost center when posting, but the Business wanted it to load the invoices into SAP with some cost centers as per the logics provided. So we built a logic to cleanse the data with no cost centers and uploaded it with the requested cost center.

Illustrations

Benefits

  • The client is able to remove unnecessary information and move only required information into S/4 HANA, in terms of Masters.
  • All business validations were done by Chainsys Migration tool.

Products and Services Used

dataZen - To 'Get Clean' and 'Stay Clean', and Introduce Master Data Governance.


Reference

No items found.