In a previous blog, I mentioned how Oracle Reports is now deprecated as of Fusion Middleware 12c Release 2 (18.104.22.168). This means no more new releases of Oracle Reports will be included in future releases of Oracle Fusion Middleware. To be clear, this also means no more functional enhancements and only critical bugs being fixed until Extended support ends in October 2025.
So what does this mean if you are looking to upgrade to the latest version of Oracle Forms?
As part of Oracle WebLogic Server (WLS), the WebLogic Suite edition, you get Oracle Forms Services and Oracle Reports Services, but you are also entitled to Oracle Internet Application Server (iAS), Enterprise Edition, that includes a restricted-use license for Oracle BI Publisher. Below you can see what the Oracle BI Publisher restricted-use license entitlement is for iAS.
iAS, again, includes Oracle Forms Services and Oracle Reports Services and the restricted-use license for Oracle BI Publisher, but this is limited to Production use only. Therefore, you are not entitled to create, test or debug any Oracle BI Publisher reports.
Oracle Forms and Reports (OFR) license also only allows Oracle BI Publisher use in Production environments only. Again, this does not entitle you to perform code changes, testing or debugging to applications or reports but allow the deployment and running of applications and reports
An Oracle Internet Developer Suite (iDS) allows development, testing and debugging of Oracle Forms and Oracle Reports with its inclusion of Oracle Forms Builder and Runtime and Oracle Reports Builder and Runtime and this is the same when it comes to the Oracle BI Publisher restricted-use license. This only entitles you for development, testing and debugging of Oracle BI Publisher Reports.
You do have other options when it comes to developing/redeveloping reports for your Oracle Forms applications. These options are; running an your existing Oracle Reports service, with no functional updates and Premier Support ending in August 2022 or a third-party service that can integrate with Oracle Forms, such as PL/PDF or Jasper Reports to name a couple.
Author: Gavin Bell
Job Title: Development Consultant
Bio: Gavin is a Development Consultant at DSP-Explorer. Having attained a BSc in Computing he embarked on a career working with Oracle technologies and specialising in SQL and PL/SQL programming. In previous roles he has worked with Oracle Forms and Reports (v9-12), Oracle Retail (v13) and APEX (v4.2-18.2). Here at DSP-Explorer he is part of a highly skilled development team providing APEX development solutions and training to both UK and international businesses.