[ Casestudy]
Resource Augmentation for Oracle Forms to Oracle APEX Migration
Deliverydevs took careful planning. Data integrity was needed because there was a chance of corruption or loss. The lack of resources led to a high-pressure work environment with strict deadlines.
CLIENT
EFU General Insurance
Sector
Insurance
Scope
Resource augmentation
Oracle Forms to Oracle APEX migration
services
Staff Augmentation
Contents
Copy link
01
The challenge
EFU General Insurance needed to move its motor underwriting system from Oracle Forms to Oracle APEX, and it needed to happen soon. Data integrity was the first constraint, because corruption or loss was a real possibility; a shortage of resources had already produced a high-pressure environment with firm deadlines; and the system documentation was so scant that establishing what the existing system actually did became a piece of work in its own right before any migration could begin.
What the migration had to protect
- Data integrity, against a real risk of corruption or loss during the move.
- Firm deadlines, under a resourcing shortfall that had already raised the pressure.
- Undocumented behaviour, recovered from the live Oracle Forms system rather than from documentation.
- User adoption, with business users brought into the interface design rather than handed the result.
02
What we did
Extensive research produced a proper augmentation plan, and three highly qualified engineers were placed on the EFU General campus to carry the implementation and its integration. A deep evaluation of the existing system gave us the technological nuances and let us identify the features and functionality that genuinely had to migrate, from which a project plan with precise deadlines, checkpoints and direction for each deliverable followed. Business documentation was prepared and examined first and signed off by the key stakeholders, and from there the work concentrated on an Oracle APEX interface shaped by business user input rather than by assumption.
Undocumented systems are migrated by reading the system, not the documentation.
On the migration
03
The toolkit
Three disciplines carried the engagement, each against a named part of the problem.
System assessment and planning
A thorough analysis of the existing Oracle Forms system supplied the information the migration depended on, and a comprehensive project plan with schedules and milestones kept the technological difficulties in an organized sequence rather than a scramble.
User-centric interface development
The Oracle APEX interface was built to be simple and intuitive, with feedback from business users folded in so the new system met their actual demands — the most direct answer to the risk of poor adoption.
Testing and data integrity
Strict testing and validation protocols reduced the chance of data loss or corruption, confirming that every record migrated correctly and that the new system operated dependably.
Resource augmentation
Tired of outdated technology holding your business back?
Tell us what the old system still does that nothing else does, and we’ll plan the move around it.
04
Results
The APEX platform improved system performance substantially, with higher processing rates and a more responsive interface, while simpler procedures and less manual intervention produced a visible lift in operating efficiency. The interface was built from end-user feedback and the experience of using it improved accordingly. The move also closed the security problem, retiring the risks tied to the ageing Oracle Forms platform and leaving a safer environment for sensitive data, while the testing and validation carried out during the transfer held data integrity intact with nothing important lost or corrupted. Oracle APEX now carries policy issuance, risk assessment, claims administration and policy renewals.
05
Conclusion
The project closed efficiently despite the technical detail, the stringent time constraints and the work of acclimatizing everyone to a new system. The motor underwriting system runs on the new APEX platform with better performance and a better experience, and with a more secure and effective system in place EFU General is positioned to keep serving its clients well and to handle what comes next more efficiently.
Sitting on a platform nobody documented?
Send us what you have and an engineer will come back with how the migration would run.
