Oracle Forms and Oracle Reports are the foundational Oracle application development platform components used by thousands of enterprise organisations worldwide — particularly in public sector, financial services, utilities, and healthcare — to deliver complex, data-intensive business applications that run directly against Oracle Database. Oracle Forms applications are characterised by their depth of Oracle Database integration: Direct Oracle database access via Oracle Net Services, PL/SQL stored procedure and function calls embedded in form triggers, Oracle Sequence generation for primary keys, and sophisticated multi-block master-detail forms that handle complex transactional business logic at the database layer. Oracle Reports complements this with server-side report generation, bursting, and distribution capabilities integrated into Oracle Application Server (OAS/OHS). These are not simple web screens — they are Oracle Database applications that encode significant institutional business logic in Forms triggers, PL/SQL libraries, and custom Java bean components.
Oracle's message to Forms and Reports customers has been consistent for the past decade: modernise to Oracle APEX (Application Express) or Oracle Visual Builder Cloud Service (VBCS). Oracle has extended Forms support further than most analysts expected — a reflection of how large and embedded the Forms customer base remains — but the support lifecycle message is now unambiguous: Oracle Forms 12c (12.2.1.x) is the last major Forms release, and Oracle has indicated that new investment is focused exclusively on APEX and VBCS. Third-party support on Oracle Forms 12c and earlier versions cuts annual support costs by 50–65%, removes Oracle's modernisation deadline pressure entirely, and gives your organisation the time and budget to plan any transformation on its own strategic terms — not Oracle's commercial ones.
Running Oracle? Find out exactly what you're overpaying. Free cost analysis, no commitment.
500+ enterprise clients · Est. 2016 · 15-min response · No commitment
Oracle Forms 11g (11.1.2.x) and Oracle Reports 11g entered Sustaining Support in January 2022. Oracle Forms 12c (12.2.1.x) and Oracle Reports 12c are in Premier Support until December 2026, with Extended Support available through December 2029. Oracle Forms 6i and 10g are in Sustaining Support with no patches available. For any organisation on Forms 11g or earlier, TPS is immediately relevant; for Forms 12c organisations, TPS represents proactive cost reduction before Oracle's 2026–2029 support lifecycle transition. See our Oracle Forms overview and Oracle TPS complete guide for full lifecycle context.
Oracle APEX and VBCS Modernisation — What Oracle's Migration Pitch Omits
Oracle APEX and Oracle Visual Builder Cloud Service are genuinely capable modern application platforms. For new application development, APEX in particular delivers rapid development on Oracle Database with strong low-code productivity. The problem Oracle's account teams consistently understate is the cost and risk profile of migrating existing Oracle Forms applications — not building new ones.
A mature Oracle Forms application portfolio — 150–400 Forms modules, 50–100 Reports, 20–40 PL/SQL libraries (PLLs), custom Java beans, and a custom Oracle Application Server configuration — is not "modernised" by pointing developers at APEX documentation. It requires: business analyst review of each form's trigger logic to document the business rules encoded in forms triggers (FOR LOOP, WHEN-VALIDATE-ITEM, KEY-COMMIT, POST-FORMS-COMMIT); developer re-creation of that logic in APEX page processes, validations, and dynamic actions; DBA rationalisation of PL/SQL libraries into package procedures that APEX can call; re-creation of all Oracle Reports in APEX Interactive Reports, Oracle Analytics Publisher, or a third-party reporting tool; re-testing of all business processes against the new application (Forms validation logic and APEX validation logic diverge significantly in multi-block forms scenarios); and UAT with business users who have been using the Forms interface, often for 15–20 years, and have well-established muscle memory. For a large public sector organisation with 200+ Forms modules, industry benchmarks consistently produce cost estimates of £1.5M–£5M and 24–42 months for a credible migration programme. GoVendorFree TPS on the existing Forms environment costs a fraction of that, annually.
Oracle Forms and Reports Version Matrix — TPS Eligibility
| Version | Platform / Deployment | Oracle Support Status | TPS Available |
|---|---|---|---|
| Oracle Forms 6i / Reports 6i | Client-Server (Forms 6i) and Web (Reports 6i via OAS) | Sustaining Support only | ✓ Yes — very large TPS cohort |
| Oracle Forms 10g / Reports 10g | Web deployment via Oracle Application Server 10g (OAS) | Sustaining Support only | ✓ Yes — ideal TPS candidate |
| Oracle Forms 11g (11.1.1.x) | WebLogic 10.3.x deployment, Oracle HTTP Server | Sustaining Support only | ✓ Yes — TPS recommended |
| Oracle Forms 11g R2 (11.1.2.x) | WebLogic 10.3.6, OHS 11g, enhanced web deployment | Sustaining Support only | ✓ Yes — large active TPS cohort |
| Oracle Forms 12c (12.2.1.x) | WebLogic 12c, OHS 12c, Oracle Identity Management integration | Premier Support until Dec 2026 | ✓ Yes — proactive TPS candidate |
| Oracle Reports 12c (12.2.1.x) | Reports Server, Reports Servlet, WebLogic 12c deployment | Premier Support until Dec 2026 | ✓ Yes |
| Oracle APEX 23.x / 24.x | Cloud or on-premise, low-code application platform | Active development | ✓ Yes — for APEX on Oracle DB TPS |
GoVendorFree TPS Coverage for Oracle Forms and Reports
GoVendorFree's Oracle TPS covers the complete Oracle Forms and Reports stack — the Forms and Reports Server components, Oracle WebLogic (or OAS/OHS for pre-12c), Oracle HTTP Server, Oracle Database connectivity, and Oracle Net Services configuration. Coverage includes:
- Oracle Forms Server: Forms Servlet and Web deployment stability (WebLogic 10.3.6 / 12c hosting); Oracle Forms Server configuration and tuning (formsweb.cfg, default.env); Forms session management and concurrent user capacity advisory; Forms HTTP Session persistence advisory; Oracle Forms Java Archive (JAR) and frmall.jar deployment advisory; OHS mod_wl_ohs reverse proxy configuration; SSL/TLS configuration for Forms over HTTPS; Forms load balancing advisory (WebLogic Cluster for Forms)
- Oracle Reports Server: Oracle Reports Server daemon stability; Reports job queue management; Reports output format configuration (PDF, RTF, HTML, CSV, XML, XLSX); Oracle Reports Bursting and distribution configuration; Reports Servlet and CGI deployment advisory; in-process reporting from Forms (RUN_REPORT_OBJECT built-in advisory); Reports parameter form advisory; Oracle Reports Builder (.rdf/.rep) runtime stability
- PL/SQL Library (PLL) and Forms Runtime: PL/SQL library compilation and attachment advisory; Forms trigger execution stability (pre-query, post-query, when-validate, key triggers); Oracle Database PL/SQL package and procedure call advisory from Forms triggers; Oracle sequence and ROWID advisory; Forms Built-in subprograms and restricted/unrestricted procedure advisory; Forms error handling (ON-ERROR, ON-MESSAGE trigger advisory)
- Oracle Database Connectivity: Oracle Net Services (TNS/SCAN) configuration for Forms; Oracle JDBC Thin and OCI connectivity advisory; Oracle Advanced Security (ASO) for encrypted Forms-DB connections; Oracle Connection Manager (CMAN) advisory for Forms environments; Database link advisory for multi-database Forms applications
- WebLogic / Application Server: WebLogic 10.3.6 and 12c domain configuration stability; WebLogic server and cluster JVM advisory (JDK 8 and compatibility advisory with Temurin/Zulu for OpenJDK migration); Oracle HTTP Server 11g and 12c stability; OPSS (Oracle Platform Security Services) for Forms security advisory; Node Manager configuration and Forms managed server advisory
- Security and Compliance: Oracle Internet Directory (OID) and LDAP integration for Forms SSO advisory; Oracle Access Manager (OAM) and WebGate integration for Forms; SSL certificate management; Forms application-level security (user/responsibility matrix, menu security module advisory)
Public Sector and Healthcare — Oracle Forms TPS Cohort
Oracle Forms' two largest TPS cohort sectors — public sector and healthcare — each carry operational constraints that make Oracle's modernisation timeline commercially and operationally unrealistic.
In UK public sector, Oracle Forms applications support local authority finance systems (many based on Oracle's own Forms-based products — Oracle Financials, Oracle Housing), NHS clinical administration (patient registration, appointment scheduling modules built on Oracle Forms), DVLA and HMRC back-office processing, and central government department operational systems. The GDS (Government Digital Service) Service Standard mandates user research, iterative design, and accessibility compliance (WCAG 2.1 AA) for any replacement digital service — requirements that produce realistic delivery timelines of 18–36 months even for well-resourced programmes. Public sector procurement rules (Crown Commercial Service frameworks, PCR 2015 competitive tendering obligations for high-value contracts) add further timeline and governance constraints. Our public sector practice covers the TPS governance and procurement framework for Oracle Forms decisions.
In healthcare, Oracle Forms applications support clinical patient management, NHS Trust financial management, pharmacy dispensing workflow management, and radiology request and reporting workflow. DCB0129 Clinical Risk Management requirements and CQC regulatory oversight mean that any clinical software change requires a clinical risk assessment, safety case documentation, and UAT with clinical staff — a process that can add 6–18 months to a migration programme timeline. NHS Transformation Directorate priorities and NHS I&M budget constraints create a resource environment where large-scale application modernisation programmes compete with clinical transformation, cloud migration, and EPR (Electronic Patient Record) consolidation programmes. See our healthcare practice for the NHS digital and DCB compliance framework relevant to Oracle Forms TPS.
Four-Profile Oracle Forms and Reports TPS Cost Model
Related Oracle TPS Resources
- Oracle Third-Party Support: The Complete Enterprise Guide
- Oracle Forms and Reports Support — Overview
- Oracle Fusion Middleware Third-Party Support
- Oracle TPS Service Overview
- Oracle Support Cost Reduction White Paper
- Case Study: Public Sector Organisation — 55% Oracle Support Saving
- Public Sector Industry Practice