A London-Based Council’s Oracle ERP Migration to Cloud
September 12, 2022Remove Pain Points & Speed up your Data Processes Successfully
Case Study – Public Sector
A London-based council authority in Greater London, England, needed to migrate customer and supplier records to Oracle ERP Cloud seamlessly and effectively. It was essential that they only migrate quality data into their Cloud environment.
Prerequisites
Before migrating to the Cloud, the council cleansed their existing data. They removed errors and made sure that the information across the database was standardized and consistent. Therefore, only moving active customers and suppliers to the Cloud.
Deactivation Project
The council used the More4apps custom query functionality to determine which customers and suppliers did not have open invoices and had not been active in three years or more.
After that, they defined parameters to identify additional customer and supplier records that should be disabled. They discovered that approximately 15,000 customers and 17,000 supplier records needed deactivated using the More4apps tools within the EBS Toolbox.
Completing the deactivation project using the More4apps suite of products, reduced the time it would have taken the council to do the same task manually by 98%, which is the equivalent of 4-5 months.
The finance team can now be confident that their customer and supplier data in the new Cloud infrastructure is accurate and up-to-date.
![](https://more4apps.com/wp-content/uploads/2022/09/A-London-Based-Councils-Successful-Migration-to-Oracle-ERP-Cloud-2.png)
Cleansing Project
The More4apps tools addressed errors and standardized details concerning the customers and suppliers before migrating master data to the Cloud.
Ringo Jouhal, a data migration expert with over 20 years of experience, said, “When you have 100,000 customers or suppliers with address details to review, it’s much easier to do that using the spreadsheets provided by More4apps than it would be in the application, one record at a time. You can copy, paste, and use standard Excel functions against the data, like VLOOKUPS in the spreadsheet, to analyze it much quicker than you could through the application front-end.”
Remove Pain Points & Speed up your Data Processes Successfully with More4apps
Case Study
A London-Based Council’s Oracle ERP Migration to Cloud
Since end-users would input and amend data, the tool needed to be easy to implement. More4apps solutions were used because they’re designed with the end-user in mind and developed within the familiar environment of an Excel spreadsheet.
Using a single Excel spreadsheet was attractive to the council because end-users cleansed data manually in Excel before the migration so there was comfortability.
More4apps helped the council accelerate its migration to the Cloud while mitigating the risks. As Scott Sherrin, an Oracle Cloud Finance Project Manager, happily said, “We are moving fewer and cleaner pieces of data.”
Brochure:
Data Loading Solutions for Oracle EBS
Visit our Resource Library for additional materials or connect with an expert today!
Brochure:
Harness the Power of Excel in ERP Cloud
Visit our Resource Library for additional materials or connect with an expert today!