Pretius. Built Smarter: Strategic merger as an answer to modern challenges
Pretius. Built Smarter:
Strategic merger as an answer to modern challenges

Migrate your Oracle Forms to APEX with an expert team

Choose a company with 5 Oracle ACEs on board and a proven track record

Top-level Oracle APEX and migration expertise

01

Enterprise-grade low-code applications

We build and maintain mission-critical, high-performance APEX applications for industry leaders. This includes powerful dashboards, BPM tools, sales commission systems and extensions to existing core systems (ERP, HCM, CRM, etc.).
Our low-code solution are designed with scalability and security in mind, which is crucial for corporate environments. We focus on delivering applications that not only respond quickly to business needs but also integrate seamlessly with existing IT infrastructure, guaranteeing business continuity and minimizing risk. Thanks to a rapid development methodology, we are able to deliver functional prototypes and finished systems in record time, which significantly reduces the TCO (Total Cost of Ownership).

02

Oracle Forms to APEX migration

We are specialists in modernizing legacy Oracle Forms applications, preserving your core business logic while transitioning you to a modern, web-native architecture. We can even accelerate this process with our AI Forms to APEX Assistant.
The migration process is more than just a technical code transfer; it is a strategic transformation that frees your systems from archaic technology. We retain all the business nuances and complex logic from Oracle Forms while simultaneously transforming them into flexible, browser-accessible APEX applications. Our AI migration assistant helps with cost estimation and further automates routine tasks, allowing us to focus on other things, such as optimizing and adapting the user interface to modern standards.

03

Legacy modernization

We specialize in migrating outdated platforms like Oracle Forms, Discoverer, and OBIEE to modern, cost-effective alternatives, including Oracle APEX and Java-based frameworks.
We start with a full legacy system assessment, which allows us to define the most effective modernization path—be it re-platforming, re-hosting, or a full re-engineering. We are not limited to just changing the platform; our goal is to increase performance, improve security, and reduce maintenance costs. By transitioning to modern, future-proof technologies, we ensure that your investment will serve the organization for many years to come.

04

Data & application re-engineering

Beyond migration, we re-engineer and refactor your applications, breaking down monolithic structures, optimizing database performance, and building modern data pipelines to ensure your systems are agile, scalable, and future-proof.
Application re-engineering is often necessary to achieve true operational agility. We aim to break down large, monolithic systems into smaller, independent microservices, which radically simplifies making changes, testing, and deployment. Simultaneously, we focus on advanced database optimization and building modern data pipelines to speed up application operation and enable the use of data for making real-time strategic business decisions.

05

Cloud migration, strategy and optimization

As an official Oracle partner, we have deep expertise in Oracle Cloud Infrastructure (OCI), including sovereign cloud solutions, but our experience also spans AWS, Google Cloud Platform (GCP), and Microsoft Azure. We can design a cloud migration strategy, optimize costs, performance, and scalability, as well as conduct a "lift and shift" (re-hosting) or a full application re-architecture.
Choosing the right cloud and migration strategy is fundamental to the success of digital transformation. Our multi-cloud expertise allows us to recommend the most optimal and cost-effective solution for every client. Moreover, our strategy always includes in-depth optimization of cloud costs and performance, ensuring that the chosen cloud environment is fully consistent with your long-term business and regulatory goals.

Pretius AI Forms to APEX Assistant

To make your migration faster and more predictable, we leverage our proprietary AI Forms to APEX Assistant. This powerful, custom-built tool uses the power of AI to accelerate every phase of your project, reducing risk and saving you many developer-hours. Our assistant is an intelligent accelerator that delivers concrete business value:
  • AI-powered project estimation: The first step to any successful project is an accurate plan. Our AI analyzes your FMB and XML files to provide a highly accurate estimation of the migration effort, with a proven 90% accuracy rate. This eliminates guesswork and allows for precise budgeting and resource planning from day one.
  • Semi-automated conversion: We kickstart the technical migration by automatically converting vast amounts of your core logic. The assistant intelligently transforms your Forms PL/SQL into optimized database packages and utility modules, freeing up your developers to focus on high-value modernization tasks instead of tedious, manual copying.
  • Ongoing developer assistance: Our AI tool provides continuous support to the development team throughout the project. It acts as an expert co-pilot, providing guidance, identifying troublesome areas, and suggesting modern APEX-native solutions for legacy processes. This boosts developer productivity and ensures best practices are followed.
icon-idea

Note:

Pretius AI Forms to APEX Assistant isn’t a product we sell, but rather an internal tool we use as part of our Oracle Forms to APEX migration service. It helps us be more effective and efficient. By using it, we don't just make your project faster—we make it smarter, more predictable, and more cost-effective.

Real-life experience with Oracle Forms-APEX migration projects

van-group-logo-white
Branch
Transportation
Country
Poland
SYSTEM
Freight management

Digitally transforming Van Group's logistics with a custom Freight Management System

Modernizing the system with new features, including route planning, cargo tracking, and automatic freight cost calculation. The system has reduced human errors, assisted drivers with navigation, and enabled a faster response to lucrative orders.

Who and when should migrate

Who should migrate?

Migration is the optimal path for organizations with extensive systems based on Oracle Forms technology. It is a perfect solution for organizations wanting to preserve their valuable PL/SQL business logic built over the years, while simultaneously opening the system to innovations, cloud solutions, and native mobility. Key sectors and companies that benefit most from this transformation include:

Financial and banking institutions

Banks, credit unions, leasing companies, and financial intermediaries are among the heaviest historical users of Oracle Forms. Their back-office systems — managing loan origination, interest calculations, repayment schedules, currency reconciliation, and general ledger entries — were often built directly in Oracle Forms and have been running unchanged for 15–20 years.

The urgency to migrate is particularly acute in this sector. Financial regulators across the EU and globally increasingly treat operation on unsupported or unpatched software as a systemic risk. Frameworks like DORA (the EU’s Digital Operational Resilience Act, in force since January 2025), MiFID II, PSD2, and national banking supervision guidelines all require demonstrable ICT risk management — which is nearly impossible to satisfy on a platform with no active vendor support or security patches.

Oracle APEX offers native database-level security, row-level access control, and detailed audit logging — all out of the box. For a sector where data integrity and traceability are non-negotiable, this is a critical advantage over the aging Forms client-server model. APEX also supports REST-native integration with core banking systems (CBS), credit scoring APIs, and regulatory reporting platforms, eliminating the data silos that Forms-based workflows inevitably create.
altapay-case-study-1
Regulatory warning:
Operating Oracle Forms 12c beyond December 2026 without Premier Support means no new CVE patches. For any institution subject to PCI-DSS, GDPR, or banking supervision audits, this is not merely a technical debt issue — it is a direct compliance violation waiting to be discovered.

Logistics and supply chain

vangroup-case-study-2
Logistics businesses operating internationally also benefit from APEX’s multi-language support and REST-native customs/EDI integrations — two areas where legacy Forms systems consistently create manual workarounds.
Freight forwarders, road haulage operators, warehouse managers, and distribution network coordinators often rely on Oracle Forms for the core operational screens that underpin every shipment, route, and delivery: order entry, cargo tracking, driver dispatch, cost calculation, and customs documentation management. These systems are typically deeply integrated with ERP platforms (Oracle EBS, SAP) and legacy EDI pipelines.

The fundamental incompatibility between Oracle Forms and modern logistics is mobility. Drivers, warehouse staff, port agents, and field coordinators cannot access a Forms-based system from a tablet or smartphone — they are chained to a desktop terminal at a fixed location. In an industry where real-time visibility and rapid response to exceptions (late pickups, route changes, cross-docking decisions) are competitive differentiators, this is a crippling limitation.

Pretius has direct, validated experience here: the Van Group project — a full freight management system built in Oracle APEX — delivered route planning, cargo tracking, and automatic cost calculation in a web and mobile-native environment, eliminating human errors and enabling faster response to high-value orders.

Agriculture and food processing

Agricultural processing companies, dairy cooperatives, grain merchants, sugar refineries, and large food manufacturers frequently operate Oracle Forms-based systems to manage their supplier networks — often composed of hundreds or thousands of individual farms and cooperatives with varying contractual terms, quality grades, and seasonal delivery schedules. These systems handle raw material intake, quality testing results, payment calculations per delivered weight and grade, and regulatory traceability records.

The food processing sector is under increasing pressure from two directions: supply chain complexity and food safety regulation. EU Farm to Fork legislation, FSMA (Food Safety Modernization Act) in the US, and international HACCP and ISO 22000 standards all require end-to-end traceability from farm to shelf — something that is extremely difficult to implement on a system built in the 1990s.

Migrating to Oracle APEX transforms these systems into web-accessible platforms. Cooperative representatives can submit delivery schedules and view payment statements from a browser or smartphone. Quality inspectors can record test results at the intake point on a tablet. Management dashboards can aggregate real-time volumes, payments, and quality trends across the entire supplier network — something that was previously only visible through end-of-day batch reports.
pretius-agriculture
Seasonal peak processing — harvest windows in particular — demands systems that can scale and remain stable under concentrated load. APEX, backed by Oracle Database, handles this reliably and without the Java WebLogic middleware complexity that Forms requires.

Engineering and asset management

pretius-casestudy-pharma
For municipal and public-sector asset managers, Oracle APEX’s robust role-based access control is particularly important: different roles (inspector, engineer, manager, auditor) each see precisely the data they need, with full audit trails required by public procurement and infrastructure regulations.
Engineering firms, municipal utilities, infrastructure operators, and facility management companies rely on Oracle Forms for asset lifecycle management — the systems that track the entire lifespan of physical infrastructure: creation, inspection, maintenance, repair, replacement, and decommissioning. This includes water distribution networks, power grids, gas pipelines, road infrastructure, and commercial real estate portfolios.

These organizations face a specific modernization challenge: their asset data is irreplaceable — decades of maintenance history, inspection records, and failure analyses are locked inside Oracle Database tables managed by Forms-based front ends. The data itself is valuable; only the front end needs to be replaced. This makes a Forms-to-APEX migration particularly well-suited, because all the PL/SQL business logic and database schemas can be preserved and extended rather than rebuilt from scratch.

Pretius has demonstrated this in practice: the Sweco case study describes the modernization of a core asset management system, delivering improved performance, better UX, and significantly reduced maintenance costs — all while preserving the underlying Oracle data model that the organization had invested years in building.

Insurance

Insurance companies, brokerage networks, and reinsurance firms have long relied on Oracle Forms for the administrative backbone of their operations: policy underwriting, client risk assessment, claims intake, premium calculation, agent commission management, and regulatory reporting. These systems are typically highly complex, with intricate business rules encoding underwriting guidelines, premium tables, and claims handling procedures built up over decades.

The insurance sector has two particularly acute Oracle Forms pain points. First, the consultant experience: insurance agents and consultants working in a client-facing capacity need to run policy calculations and produce proposals quickly — often while in a meeting or on the road. A desktop-only Oracle Forms system makes this impossible, forcing paper-based workarounds or delayed follow-ups that directly impact sales conversion. Second, Solvency II and related national insurance supervision frameworks impose strict requirements on data governance, auditability, and ICT risk management — requirements that are increasingly difficult to meet on unsupported legacy platforms.

APEX enables a single application to serve both back-office staff managing complex policy administration and front-office consultants who need a fast, intuitive interface on any device. The same underlying Oracle data model powers both experiences. Pretius has direct experience here: a client assessment system built for an insurance organization now supports over 300 consultants simultaneously, delivering both the reliability and the modern UX that a client-facing tool demands.
pretius-profitowi-case-study-2
Insurance companies also benefit from APEX’s built-in REST API framework for connecting to telematics providers (for usage-based insurance), credit scoring bureaus, and national insurance registers — integrations that Forms-based systems handle only through expensive custom middleware layers.

Pharmaceutical and life sciences

pretius-pharmaceutical
Validation note:
Oracle APEX's declarative development model actually simplifies the validation process compared to a custom-coded application. The platform's deterministic, configuration-driven behavior means a smaller surface area to validate, and Oracle's own GAMP 5 Category 4 classification of APEX supports a streamlined validation approach accepted by FDA and EMA inspectors.
Pharmaceutical manufacturers, contract research organizations (CROs), medical device companies, and biotech firms are among the most demanding Oracle Forms users still in production. Their systems manage the full spectrum of regulated processes: batch manufacturing records, laboratory information management (LIMS), quality control testing, deviation and CAPA (Corrective and Preventive Action) workflows, and regulatory submission data preparation. These applications weren't just built in Oracle Forms — they were validated in Oracle Forms, which is precisely why they've been left untouched for so long.

This is the sector's defining tension: the same regulatory frameworks that make migrating feel risky also make staying an increasingly indefensible position. FDA 21 CFR Part 11 and the EU's Annex 11 to the GMP guidelines require that electronic records and electronic signature systems remain under active vendor support, with documented evidence of security patch management. Running a validated system on software that Oracle no longer patches does not satisfy these requirements — it creates a finding in any GxP audit.

The GxP validation concern is real, but it is not a blocker — it is a project parameter. Pretius migrates validated systems by treating the APEX application as a new validated system: we produce the full IQ/OQ/PQ validation documentation package as part of the delivery. The business logic, audit trail structures, and electronic signature workflows are re-validated in APEX, not abandoned. This is a structured effort, but it is far less risky than continuing to run on an unpatched, unsupported platform under FDA or EMA scrutiny.

Beyond compliance, the operational gains are substantial. Quality teams using Forms-based CAPA systems today deal with slow, desktop-only screens that cannot integrate with document management systems or send automated notifications. In APEX, the same workflow becomes a browser-accessible, role-aware process with automatic email escalations, integrated document attachments, and real-time status dashboards visible to both site management and corporate QA simultaneously.
When should the decision be made?
The main motivator for immediate action is the "technological death clock" – the inevitably approaching end of vendor support (for the popular 12c version, Premier Support expires in December 2026). The migration should be planned right now, especially for highly regulated entities (i.e., financial sector), for whom operating on unsupported software poses a massive cybersecurity risk and threatens to violate strict regulations.

The challenge: A legacy system that holds back your business

Oracle Forms was a reliable workhorse for decades, but today's business world demands more. If you're still running critical operations on Forms, you are likely facing significant challenges:

  • High and rising costs: Expensive licensing (costs include licenses for Forms, but also other parts of the required infrastructure, such as WebLogic, etc.), disappearing developer talent, and complex client-server maintenance drain your IT budget.
  • Lack of mobility: Your applications are chained to the desktop, making remote work inefficient and fieldwork impossible.
  • Problems with maintaining competencies: Forms specialists are retiring. Few are learning new things—it's a 1990s technology. Finding someone who knows Forms and Java is becoming increasingly difficult and expensive.
  • Security & compliance risks: Older systems are notoriously difficult to patch and secure, exposing you to modern threats and compliance violations.
  • Integration "nightmares": Difficulty connecting to modern cloud services, APIs, and other critical SaaS applications creates data silos and manual workarounds.
  • Poor user experience (UX): Outdated, non-intuitive interfaces frustrate users, slow down onboarding, and lead to costly errors. This is especially true for new, younger employees, who are often used to working with more modern solutions.

The clock is ticking: Oracle Forms end of support

Beyond these daily frustrations, there is a critical, time-sensitive business risk: the impending end of support for Oracle Forms.

Oracle's support lifecycle for Forms is coming to an end. For the widely used Fusion Middleware 12c version, Premier Support ends in December 2026, with Extended Support ending in December 2027. The most recent 14.1.x version will be supported a while longer, until December 2029 (Premier Support) and December 2032 (Extended Support), respectively.
Klepsydra

What this means for your business:

  • No new security patches: After support ends, Oracle will no longer release new security updates, leaving your critical data and applications vulnerable to new, sophisticated threats.
  • No new bug fixes: Any newly discovered bugs or functional issues will go unresolved, leading to potential application instability and operational disruptions.
  • Major compliance failures: Operating on unsupported software is a major red flag for auditors and can put you in breach of regulatory requirements like PCI, HIPAA, and GDPR.
  • Extreme "Sustaining Support" costs: Your only option will be Oracle's "Sustaining Support," which provides no new patches or fixes and comes at a premium price for minimal support.

The question is no longer if you should migrate, but when. Running your business on an unsupported platform is not a viable strategy – it's a critical liability waiting to happen.

Pretius AI Semantic Search - 1

The solution: The Oracle APEX business advantage

All of these challenges can be answered by a move to Oracle APEX. This isn't just an update—it's a complete business transformation. As a no-cost feature of your Oracle Database, APEX is the clear, low-risk path forward. It allows you to build and deploy world-class, data-driven applications at incredible speed.
Migrating to APEX moves you from a high-maintenance legacy system to a high-performance, future-proof platform.

Key business advantages of Oracle APEX Migration

  • Drastically reduce total cost of ownership (TCO):
    This is the most immediate and powerful ROI. APEX is a fully-supported, no-cost feature of the Oracle Database. You eliminate Oracle Forms and Reports licensing and runtime fees forever. Less infrastructure and simplified maintenance mean your budget goes to innovation, not just "keeping the lights on."
  • Accelerate business agility & speed-to-market:
    Go from idea to enterprise-grade application 10-20x faster. APEX's low-code, declarative framework empowers developers to build and deploy rich, functional applications with minimal hand-coding. Need a new report, dashboard, or data entry form? It can be done in hours or days, not months.
  • Enable a true mobile & remote workforce:
    APEX apps are web apps (with PWA support), which means the platform is mobile-ready out of the box. A single APEX application is 100% responsive, working flawlessly across any desktop, tablet, or smartphone. You can empower your sales team, field technicians, and remote employees with secure access to real-time data from any device, anywhere.
  • Enhance security & simplify compliance:
    Leverage the world-class, built-in security of your Oracle Database. APEX standardizes software development and provides powerful, pre-built features for authentication, authorization, and session management, making it far easier to secure your data and pass audits than with legacy client-server systems.
  • Boost productivity & user satisfaction:
    Replace clunky, gray screens with modern, intuitive, and beautiful user interfaces that your employees will love. A better UX means faster onboarding, fewer data-entry errors, and increased productivity across your entire organization.
  • Seamlessly integrate your entire ecosystem:
    APEX is built for the modern, connected world. Its native support for REST APIs allows you to effortlessly connect your core database logic to any cloud service, third-party application, or microservice, breaking down data silos and automating workflows.

Potential migration challenges

Challenge 1: System complexity and "dead" code

Challenge

  • Systems developed over decades often become a conglomerate of code repeatedly modified to satisfy immediate market needs. They contain thousands of screens and reports, a significant portion of which is so-called "dead" code. A traditional attempt to rewrite everything "one-to-one" (so-called "Big Bang" approach) is doomed to fail due to the overwhelming amount of work and the risk of disrupting business continuity.

Our answer

  • Instead of a risky revolution, we implement a methodical "Data-Driven Scoping" approach. First, we spend some time logging user activity in the old system to precisely identify the actually used functionalities (the so-called critical path) and eliminate "dead" code from the migration scope. Moreover, we use our proprietary Pretius AI Forms to APEX Assistant tool, which allows us to precisely estimate the time and costs of the work and semi-automatically transfer core business logic directly to the database, saving hundreds of development hours. The process is gradual, and the new and old systems can run in parallel.

Challenge 2: User habits problem

Challenge

  • Back-office employees are often highly accustomed to the specifics of desktop Oracle Forms, including keyboard-only navigation using function keys (F8, F10, etc.), high data density screens, and working in multiple windows simultaneously with independent sessions. Standard APEX applications work differently – they depend on mouse-based interfaces and assign the session to the browser, which means that opening several tabs leads to state sharing and risks overwriting data from one tab with another. Implementing modern interfaces meets with resistance and frustration from business teams.

Our answer

  • We do not forcefully impose a "modern" design that lowers productivity; instead, we create a hybrid UI that preserves the high data density layout and supports key keyboard shortcuts from the old system. We also solved the technological problem of session sharing by creating a custom mechanism in Oracle APEX that fully isolates the state of individual browser tabs. Thanks to this, users can safely work on multiple processes simultaneously, which quickly builds system acceptance among the most demanding employees.

Interested in a Forms to APEX migration?

Contact us at hello@pretius.com or use the form below to capitalize on our extensive experience with such projects.

Our proven, low-risk migration path

We don't just "lift and shift." We use a strategic methodology that mitigates risk, delivers fast wins, and modernizes your application for the future.

icon-exchange-ideas

01

Proof of Concept

If you’re not sure if a Forms-to-APEX migration is even possible in your case, we can create a PoC to show you that it is. With a small amount of resources and 4-8 weeks, we’ll take the most difficult module – the one with the greatest complexity or the most business-critical – and rewrite it. If it’s a success (and it usually is), it's a sign that the rest of your system can be migrated as well.
Decorative image

02

Discover & assess

We perform a deep analysis of your existing Forms applications, database, and PL/SQL business logic. We identify the scope of the project, and evaluate what can be automated, what needs to be refactored, and what can be retired. We have a proprietary AI-powered Forms to APEX Assistant tool, which allows us to estimate the time and cost of the project.
Decorative image

03

Plan & prioritize

We ask you whether you want to do a 1:1 migration or use this occasion to modernize, and we build a strategic migration roadmap. We prioritize modules based on business impact, allowing for a phased rollout that provides tangible wins quickly without disrupting your operations.
Decorative image

04

Migrate & modernize

Our experts use a combination of automated conversion tools and hands-on refactoring. We don't just copy your old screens; we redesign workflows to be intuitive and efficient, leveraging modern APEX components like interactive reports, charts, and faceted search. Of course, we can also make the system resemble Oracle Forms as much as possible (including mirroring keyboard shortcuts) to ensure a smooth transition.
Decorative image

05

User Acceptance Testing (UAT)

Users test the new system and see if it works just like the old one (or better). Employees need to be trained, shown that the new application is not worse, just different. Sometimes it’s also necessary to negotiate minor changes in the flow to reassure end users.
Decorative image

06

Deployment & support

We manage a seamless go-live process with intensive support for the first 2-3 months. We ensure 100% data integrity and functional parity, and also identify edge cases (scenarios that weren’t covered during testing) and react to them accordingly.

After deployment, we provide training and support to ensure your team is successful and your new application grows with your business.

Alternatively, depending on your needs, we can adopt a unique co-creation approach and train your in-house team throughout the entire project to ensure your employees are ready for future maintenance and further development of your new APEX-based system.

A partnership, instead of a hand-off: Our co-creation model

We offer a more flexible and empowering alternative to the traditional "black box" migration. With our co-creation model, this isn't a project we do for you – it's one we do with you. We integrate our APEX migration experts directly with your in-house IT and business teams. Together, we become a single, unified unit focused on a shared goal.

This collaborative approach delivers powerful, long-term business advantages:

  • Build exactly what you need:
    Your business experts are involved from day one, ensuring the new APEX application is perfectly aligned with your real-world processes. There are no "surprise" reveals—just a system that works the way your business works.
  • Create lasting internal expertise:
    The best part of the project isn't just the new application; it's the new skills your team gains. Through daily collaboration and knowledge transfer, your team learns APEX development best practices during the migration.
  • Empower your team for the future:
    When the project is over, your team doesn't just get a user manual. They have the deep, hands-on knowledge to confidently maintain, troubleshoot, and extend the new APEX application themselves, dramatically reducing your long-term reliance on external support.
pretius newsletter decorative image

What our clients say

icon-quote-block

Adam Kasperowicz

CIO at VAN group
The new e-VAN system has become an innovative tool and work environment. The development team allows us to use the potential of the latest trends and technological solutions: web & mobile development, responsiveness, integrations, low-code, and cloud computing.

Stop Maintaining. Start Innovating.

Your core business logic is valuable. Your legacy interface is a liability.

Unlock the full potential of your data and empower your teams with a modern, secure, and flexible application platform. Contact us today at hello@pretius.com (or using the contact form below) to see how quickly you can leave Oracle Forms behind and unlock the potential offered by a powerful, modern low-code platform.

FAQ

Oracle APEX is a modern platform for building web applications. It runs in the browser (no installation required) and uses the Oracle database. It's low-code—easier and cheaper to develop than traditional programming.

Yes. With an Oracle Database license, you can use APEX at no additional cost.

Unfortunately no. The automated process is hampered by several reasons:

  1. A Forms Program Unit is a combination of conditions, authentications, processes & validations. APEX requires these to be split out into clearly defined logical areas.
  2. A Forms Program Unit contains Forms-specific PL/SQL, for example the SYNCHRONIZE command. These have no APEX equivalents.
  3. Applications rebuilt in APEX will inherently look and function differently, requiring manual adjustment.

However, our developers can use AI Forms to APEX Assistant to speed up the conversion of the above-mentioned conditions, commands, interfaces, etc., making the whole process semi-automated.

It depends on your particular circumstances. A small system (10-20 Forms) takes a few months. A medium system (50-100 Forms) takes 6-12 months. A large system (several hundred Forms) takes years. However, we do it module by module and you don't have to wait until the end to start using new components.

We will provide you with an accurate estimate based on a combination of statistical, AI, and human analysis, along with extensive experience with past projects.

You can, and you will get some new features and an extended support window. However, even the latest version of Oracle Forms isn’t as modern and future-proof as Oracle APEX. You’ll inevitably miss out on some of the features and possibilities. 

Moreover, if you stay on Forms, you’ll still need to pay licensing fees, whereas APEX is something you already own as part of your Oracle DB license (and, as such, it doesn’t incur additional costs). Moving to APEX simply makes more sense, especially since upgrading from older Oracle Forms to the newer version will also require time and resources.

Clients often ask us to perform a one-to-one UI conversion of the Forms to APEX in the belief that this is quicker to perform. This is a false belief, as it’s much faster for APEX developers to utilize the modern, responsive design of the Universal Theme using native APEX components. Getting APEX to mimic the nuances of Oracle Forms is time-consuming and tedious. Moreover, the outcomes are usually inferior.

In addition, Oracle Forms users take advantage of keyboard control, with the function keys F1-F12 being utilized. This does not typically translate to web applications. 

Finally, the designs of a legacy application were fine 20 years ago, but nowadays, many more web components can be utilized within the APEX framework. Therefore, this may be the ideal opportunity for a fresh makeover.

Oracle has prepared a questionnaire to help you decide.

A Forms to APEX migration fits well because:

  • The DB can be totally reused, including all server-side code
  • PL/SQL is at the heart of both applications
  • Forms developers can be reskilled in APEX following Learning Paths

When deciding on an alternative to APEX, do consider:

  • The existing skillset of the development team
  • The investment already made in the DB
  • Long-term technology strategy of your organization
  • Integration requirements with other systems and technologies
  • Performance and scalability needs of the application
  • Budget constraints and total cost of ownership
  • Desired level of vendor independence

Looking for a software development company?

Work with a team that already helped dozens of market leaders. Book a discovery call to see:

  • How our products work
  • How you can save time & costs
  • How we’re different from another solutions

footer-contact-steps

We keep your data safe: ISO certified

We operate in accordance with the ISO 27001 standard, ensuring the highest level of security for your data.
certified dekra 27001
© 2026 Pretius. All right reserved.
avatar-adam-kierzkowski

Adam Kierzkowski

/ Oracle APEX Team Leader

Adam dołączył do Pretius ponad 5 lat temu. Wcześniej pracował w inżynierii robotyki, ale zawsze ciągnęło go do tworzenia oprogramowania. Obecnie jest Team Leaderem, programistą APEX specjalizującym się w bazach danych Oracle oraz osobą stojącą za popularnym "Kursem Oracle APEX" na YouTube. Po pracy lubi grać w gry wideo i oglądać dobre filmy lub seriale.