Oracle EBS to Oracle Cloud Migration Testing Types

4 min readDec 22, 2020


Testing is crucial during the migration of the legacy application to the Cloud without any data loss or downtime. So analyzing and determining which testing strategy to employ while performing migration is critical to business success. Enterprises must invest quality time and effort to establish a proper migration testing plan. A well-defined migration testing strategy is essential to mitigating the risks involved and delivering a successful migration. It comprises of three phases the Pre-Migration, In-Migration, and Post-Migration. We have already given a brief introduction to the Pre-Migration readiness checklist in our E-Book. In this blog, we’ll break down what migration testing types entail for the rest two phases.

Let’s start with the testing types involved in the In-Migration testing phase:

  1. Configuration Testing — Configuration testing helps in evaluating the immediate or long term effects of configuration changes on the system’s behavior and performance and find for the combinations under which the system can work without any flaws or issues while matching its functional requirements.
  2. Data Validation Testing — Data Validation testing allows you to make sure that the data which you’re dealing with is complete and accurate. For any discrepancy in the report being migrated, the system will display errors that have occurred during the migration process. To receive an accurate report, issues will have to be resolved.

When you perform follow-up tests Post-Migration testing comes into the picture which will give a clear idea of various types of testing that gets covered here to be called Cloud Ready Transition. This phase of testing should include:

  1. System Integration Test — SIT or System Integration Testing is the process of comprehensive testing performed on the application software which is composed of many sub-systems. Systems Integration Testing looks after software module dependencies whether they are functioning properly and also if the data integrity is preserved between distinct modules of the whole system.
  2. User Acceptance Test — This is the final phase of any software development life cycle(SDLC), this process plays an important role as it validates whether all the business requirements are in sync before the release. Before the software is released in the market, the User Acceptance Test has a wider role to play in ensuring whether all the functional specifications defined by the product owner is present.
  3. Security Validation — Security validation discovers potential threats that a user could face. It allows an organization to test an attack in their own environment safely and provide them with evidence of whether this attack can be prevented. The process ensures if the security systems satisfy the requirements and the product quality actually meets the client’s needs.
  4. Reports Validation — Validation provides input on whether the product built is up to mark. This process validates the actual and expected output of the software and ensures that the product meets the user’s requirements.
  5. Business Process Testing — Functional validation or cloud-ready validation assesses production readiness of migrated applications. It is fundamental to verify if various aspects of the migrated applications are performing as per SLA’s. For an effective Oracle Cloud migration, validate SaaS/Cloud services functions, and perform end-to-end application’s functions validation.
  6. Interface Testing — Cloud migration comprises moving data along with managing a range of variables such as — security, authentication, integration, compatibility, testing, and monitoring over time. All the interfaces and systems are covered while planning for integration testing like Middleware’s, Databases. Key areas of testing should include Real-time/Near real-time processing of requests, large dataset file processing, oracle sales Cloud, HCM, and ERP Cloud Adapters.
  7. Reports Validation Testing — Reports Validation is critical to identify a pre-conversion validation plan which relies heavily on the review of FBDI load errors as they occur, resulting in a scramble late in the project to review and repair records. This is followed by a disjointed post-migration validation process that involves spot-checking records from the front end, ad hoc Excel dumps, and a comparison between legacy and Oracle Cloud reports:
  8. Security Testing — The objective of the security architecture is to enable you to maintain your security posture when running Oracle E-Business Suite and associated applications in Oracle Cloud. Even though you may be reducing the overhead of building and maintaining data center infrastructure, you still need unparalleled control and transparency over what you’re running in the cloud.
  9. Regression Testing — End to end regression validation should include testing of configuration, data, and code migrations. Tests should include managed customizations and configurations along with validation across multiple locations.

Our recommendation of shifting left ensures early detection of defects in the developmental stage which ensures quality delivery and zero risks in the testing phases. The varied testing processes take care of individual aspects involved in the detailed validation check. Enterprises planning to migrate to Oracle Cloud should adopt the above testing process to achieve a stable migration that would allow unhindered business continuity.

Author — Dimpy Sharma




Opkey is a SaaS Based Automation Tool that allows you to easily automate testing of Oracle, Salesforce & Workday.