Series 22 · 8 Parts· 1h 29m

Oracle Forms & PL/SQL Modernization

Modernizing an Oracle Forms, Reports & PL/SQL estate — surfacing the business logic buried in the database as explicit domain services, rebuilding the UI as a modern SPA or APEX, and deciding whether to upgrade or re-platform the database.

Start reading · Part 1

Contents

01 Should You Move Off Oracle Forms? 9 min read Is Oracle Forms dead? The honest answer — what the support clock actually says, where Forms still works, and how to tell whether your estate needs to move now or can wait.
02 Oracle Forms, Reports & PL/SQL: Where the Logic Lives 11 min read The anatomy of an Oracle Forms estate — forms and triggers, the Reports tier, and the PL/SQL packages and database triggers that hold the real system. Why the database, not the screens, is the system you are modernizing.
03 Build, Buy, or Re-platform: The Oracle Forms Decision 11 min read The strategic decision behind a Forms migration — rebuild as a custom app, replace with a packaged product, re-platform to a low-code target, or stay put. When each is the right call for a system whose value is in its bespoke logic.
04 PL/SQL Modernization & Business-Logic Extraction 12 min read Most of an Oracle application's logic is buried in PL/SQL packages, procedures, and triggers. How that logic is recovered as living specs and surfaced as explicit domain services — what to lift into code, what to keep in the database, and what to retire.
05 Oracle Forms to a Modern Web App: SPA + API 13 min read Rebuilding an Oracle Forms UI as a modern single-page application over an API layer and domain services. How blocks, items, and triggers map onto components and endpoints, slice by slice, parity-proven, with the legacy app still running.
06 Oracle Forms to APEX: When Low-Code Fits 10 min read Oracle APEX is the natural low-code target for migrating Forms inside the Oracle ecosystem. Where it genuinely fits, where it quietly does not, and how the slice-by-slice, parity-first discipline applies to a low-code rebuild.
07 Oracle Database: Upgrade to 19c or Move to PostgreSQL 12 min read The Oracle Database tier decision — what the support timeline requires, when an in-place upgrade to a long-term release is the honest answer, when a move to PostgreSQL earns its cost, and how the data and its bound PL/SQL migrate without a big-bang cutover.
08 Oracle Forms Migration Tools: What Converters Get Wrong 11 min read An honest look at Oracle Forms migration tools: what automated converters really help with, why one-to-one conversion moves the problem instead of solving it, and the approach that works.