M&A: Oracle Cloud Applications Transformed from Multiple EBS Systems

Financial Services

Client Overview

Listed on the Fortune 500, this US based organization offers a wide range of financial products & services. Headquartered in Florida, and with a global strength of about 50000, this organization has continued to drive growth for firms around the world innovating the customer experience around financial services.

Project Scope

Client’s legacy application included two instances of Oracle eBS. The target system was Oracle Cloud applications. The scope of the project included the following:

  • Migrate 236 Setups, and 41 master and transaction objects in Projects portfolio, P2P, O2C, Inventory management applications  from Oracle eBS into Oracle Cloud
  • Incorporate business specific consolidation, validation & transformation rules during migration
  • Accelerated migration timeline of ten weeks, requiring multiple migration iterations
  • Comply with their regulated data validation requirements.
  • Required preload and postload reconciliations & reporting

The modules in scope included:

  • Financials ( GL, AP, AR, FA, CM, Tax)
  • Supply Chain Management ( OM and INV)
  • Procurement 
  • Project Portfolio (Costing, Billing, Finance) 
  • AGIS (Intercompany)
  • Expenses

Business Situation

Setup migration was being done manually by business & IT teams. This resulted in a very complicated deployment strategy for new entity rollouts, new OU provisioning etc. The manual process was not only tedious but also led to massive amounts of errors and rework. 

This resulted in severe delays on overall project schedules. They then decided to automate their Oracle Setup deployments with the aim to improve quality and accelerate implementation timelines.

Technical Situation

For Setup migration dataZap was deployed. The key to reducing manual work and errors was to automate setup migration tasks (such as copy of Org Units, Legal Entities & Business orgs), in an accelerated manner. The other challenge was to ensure that the repeatable process was also reliable, and one that ensured high data quality.


The data was cleansed prior to the migration, using dataZap. The project implementation was done in 10 weeks.  The timeline was achieved using the dataZap’s preconfigured templates, which covered the Transformation, Mapping, Data Quality, Pre-validation, Extraction, Error handling and Data Loaders using Standard APIs and Interfaces.  The templates, along with the DQM engine ensured that the data flowing into the target was clean & compatible.

Pre-load, post load validation reports were generated for user review and approval. Post load reconciliation and verification was also carried out to ensure the migration was successful.

The organization leveraged dataZap’s BR100 reports for audit & reporting purposes.  Automated setup migration effectively reduced close to 60% of manual efforts.

Below is the high level overview of the solution implemented:



  • Automated setup migration reduced  60% efforts on the overall project timelines.
  • Reliable process with a repeatability factor of close to 80%
  • Data quality achieved was close to 90%

Products and Services Used

dataZap - Pre-Configured Templates & Migration Engine to Extract, Transform, Pre-Validate, Load, Reconcile & Report.


No items found.