Modernizing legacy grant management for a US federal healthcare agency with Oracle APEX
Key Highlights
- OptiSol partnered with a major US Federal Healthcare Agency to modernize its legacy grant management system, moving from Oracle Forms 6i to Oracle APEX.
- The agency supported more than 3,000 active users, but its legacy system required significant workstation maintenance and faced challenges with accessibility, performance, security and scalability.
- Instead of rebuilding the entire system from scratch, OptiSol used Oracle APEX to modernize the application while keeping the agency’s existing Oracle Database and core business logic intact.
- The modernized grant management system provided a secure, responsive, browser-based experience while reducing the time and cost typically involved in a full-scale modernization effort.
Problem Statement
01
High Maintenance Effort: The legacy Oracle Forms 6i application had to be installed on more than 3,000 workstations. Every update, security patch or system change required manual configuration, increasing the workload for IT teams.
02
Complex Legacy Logic: Over 12 years, important business rules had been built into forms, triggers and PL/SQL code. Rebuilding this logic from scratch would have been time-consuming and could have introduced errors or disruptions to existing grant processes.
03
Accessibility and Security Gaps: The agency required a modern web application that could support federal accessibility requirements, secure user access and centralized security controls. The existing client-server system could not easily meet these needs.
04
High Cost of Rewriting: A complete rewrite using traditional technologies such as Java/J2EE would have required significant development effort, additional infrastructure and a multi-year implementation timeline.
05
Performance Issues: The legacy client-server architecture experienced delays when users accessed the system over distributed networks, particularly during periods of high usage.
Solution Overview
01
Preserved Existing Logic: OptiSol used Oracle APEX to modernize the application while continuing to use the existing Oracle Database, PL/SQL packages, database triggers, views and security models.
02
Modern Web Experience: The legacy Oracle Forms interfaces were transformed into responsive, browser-based applications using Oracle APEX. Therefore users could access the system through standard web browsers without installing software on their workstations.
03
Simplified Architecture: The APEX-based approach reduced need for additional middleware & complex application infrastructure, making the system easier to manage and maintain.
04
Improved Security and Testing: The solution introduced centralized single sign-on, Virtual Private Database security policies and automated testing to support secure access and more reliable grant management workflows.
05
Faster Delivery: Oracle APEX's low-code capabilities allowed the team to quickly build, test, demonstrate and refine application modules with business users, shortening the overall modernization cycle.
Business Impact
About The Project
This success story highlights how OptiSol helped a major US Federal Healthcare Agency modernize their legacy grant management system. The agency was struggling with the maintenance complexity, limited accessibility, performance challenges and modernization constraints of its Oracle Forms 6i environment. OptiSol leveraged Oracle APEX to transform the legacy application into a secure, responsive web-based platform while preserving the agency’s existing Oracle Database and critical business logic. This approach enabled the agency to modernize its grant management operations without the risks and complexities of a complete system rewrite.
FAQs:
How can Oracle Forms 6i applications be modernized using Oracle APEX?
Oracle APEX can modernize Oracle Forms 6i applications into responsive web applications while reusing the existing Oracle Database and applicable business logic
Can Oracle APEX preserve existing PL/SQL business logic?
Yes. Oracle APEX can reuse the existing PL/SQL packages, procedures & functions, reducing the need to rewrite established database business logic.
What are the benefits of migrating from Oracle Forms to Oracle APEX?
Migration can provide a modern browser-based experience, simpler deployment, reduced maintenance, responsive interfaces and faster modernization while retaining the Oracle Database foundation.
How does Oracle APEX reduce the maintenance burden of legacy applications?
Oracle APEX moves applications to a browser-based model, reducing workstation-level installations, manual updates and desktop configuration required across large user environments.
Can Oracle APEX eliminate desktop application installations?
Yes. Oracle APEX delivers applications through standard web browsers, eliminating the need to install and maintain application software across individual user workstations.
Testimonials of Our Happy Clients
Ken Kisner
Global Head of Digital R&D
My experience has been incredibly positive. They were incredibly easy to work with, even with changing requirements.
They are incredibly competitive, but are only a fraction of the cost of US companies.
They are definitely the most professional of the foreign companies that we were looking into.
Nyswyn K.
Director of Software Development
Our journey with OptiSol has been nothing short of remarkable. For over 7 years, we have partnered with them on our digital transformation, and the results have been truly transformative.
Over the years, we have come to trust OptiSol Business Solutions as a reliable and strategic partner.
Al Bagiro
CTO, Auto Insurance Company
The AI engine was completed on time and trained to 90% accuracy. Their eagerness to learn new knowledge impressed us.
Their team is large to handle multiple projects at once, and likes to resolve challenges as well as learn new things. They also welcome regular communications, and of course, needless to say, develop everything in sprints.
Dan Talken
Founder, CEO, & CTO, My Equipment Library, LLC
OptiSol Business Solutions has shown youthful skill and dedication to the projects. Moreover, they have been quick to implement their solutions without sacrificing the quality of each platform.
We’re constantly impressed with their speed and quality of the development that they achieve on a consistent basis.
Dr. A.K Pradeep
CEO MachineVantage
Exceptional Collaboration and Expertise - A Top-Notch Partner for AI, ML, and Digital Applications.
I have had the privilege of working with an exceptional team of professionals from India on numerous AI, ML, and digital application projects. Their expertise in these domains is remarkable, and they consistently impressed us with their knowledge, resources, and innovative approach.
Rick Tigges
CFO, Bemodo
They are very responsive and able to shift focus quickly as we have needed it for business reasons.
OptiSol Business Solutions has been great at documenting the timeline of the project. They were very responsive and were able to shift focus quickly, as well. They discuss what they’re working on without any issues. So far, there’s no need to improve their service.