Oracle Forms Migration to Java

the fastest way to reach us:

Partner numbers sample
2 2 , 6 5 7
Migrated objects
7 6 , 5 6 9 , 4 2 1
Migrated lines of code

Trusted by:

Challenges that our clients often face

Oracle Reports is part of the popular, but outdated, Oracle Forms & Reports environment, which is in a declining phase of life and:

  • It is unprofitable to maintain.
  • Continuity of its operation is at risk.
  • Oracle Reports will no longer be actively developed.
  • It causes security problems.
  • Rewriting reports from scratch, e.g., in Java / Oracle
  • Analytics Publisher (formerly called BI Publisher) is tedious, costly, time-consuming and fraught with the risk of errors.

How can we help you?

We can transform your reports from the discontinued Oracle Reports technology into modern reports based on the JasperReports Java library.

Oracle Reports

Jasper Reports

Oracle Reports

Jasper Reports

Oracle Reports

Jasper Reports

Benefits of migrating

Oracle Reports to Java JasperReports using Re_Forms21®.

Start migrating and check pricing

Freely download Re_Forms21® Reports Tool to evaluate reports and estimate prices.
So easy! Stop waiting!

What are your additional benefits?

Business and technological benefits of using Re_Forms21®.

Automated migration
of Oracle Reports,
regardless of complexity

Standard reports close to 100% automation with minimal adjustments:

  • Different text width.
  • Subtle changes in text formatting.
  • Leading zeros in numeric values.

Flexible approach to the migration model and costs incurred

Fast migration and our support in fine tuning reports:

  • You get reports ready for fine-tuning.
  • We support your team in fine-tuning your reports.

Turnkey report migration:

  • We migrate and tune reports for you.
  • You get migrated reports that are 100% ready to use.

Have a look at our customers’ stories

Selected companies that worked with us:

Warsaw Stock Exchange (Poland)

Migrated two applications in Oracle Forms & Reports to modern Java web technology.
The migration involved nearly 300 objects and 437,471 lines of PL/SQL code.

Additional challenges:

The included forms displayed over 1500 text fields at once and there was a need for high performance in reading files from the user’s disk.

  • The migration part took only 6 months.
  • The full project, including PoC, migration, UX/UI design, remigration of changes, and acceptance tests, was successfully completed in 12 months.
  • This opened up possibilities for integration with other systems and applications.

Visma Oy (Finland)

Migrated two CRM-class systems in Oracle Forms & Reports to a modern Java web technology.
The migration involved 256 objects and 446,211 lines of PL/SQL code.

Additional challenges:

Reading and writing files to the user’s disk using JavaScript, and Integrating files with the financial transaction system.

  • The full project, including Pilot, migration, developer workshops and acceptance tests was successfully completed in 9 months.
  • The migration part took only 5 months.
  • Significant improvements in data security.
  • Increase the scalability of the system and its flexibility in the further evolution of the system.

Additional Benefits of Migrating
Oracle Reports to JasperReports

Migrating from Oracle Reports to JasperReports offers numerous advantages that can
significantly enhance your reporting capabilities and overall system performance.

Reduced licensing
and support costs

JasperReports is an open-source solution, making it more economical in terms of licensing and support costs compared to Oracle Reports.

Flexibility and
scalability

JasperReports easily adapts to changing business needs. It integrates with a variety of data sources such as databases, XML files, CSV files, and web services.

Rich visualization
capabilities

JasperReports offers advanced data visualization features, including interactive charts, pivot tables, and other graphical elements, to make reports more readable and engaging.

Easy
integration

JasperReports can be integrated with other systems seamlessly, making it easy to deploy in existing environments. Its automation and integration features simplify report generation and distribution.

Various output
formats

JasperReports supports multiple output formats like PDF, Excel, CSV, HTML, and more, providing flexibility in how you present your data.

State-of-the-art
design tools

JasperSoft Studio, the design tool for JasperReports, offers an intuitive graphical interface, making it easy to create and modify reports.

Active community
and regular updates

JasperReports has a large and active community that provides updates, fixes, and new features, ensuring the platform remains robust and current.

Reduced risk
of obsolescence

Using JasperReports minimizes the risk of your reporting system becoming outdated, as it leverages modern technologies and practices.

Better maintenance
and flexibility

JasperReports’ architecture allows for easier maintenance and greater flexibility, ensuring that your reporting system can evolve with your business needs.

Hear Directly From Our Clients

What makes us stand out.

We are very satisfied with the results and can
fully recommend Re_Forms21 as a
trustworthy partner with the highest level of competences and with an innovative product that
stood up to very high expectations.

We recommend Re_Forms21 as reliable and
timely suppliers, and the Re_Forms21
technology as a mature and secure tool for
quickly transitioning from Oracle Forms &
Reports to Java technology.

Olli Suihkonen
Sr. Manager at Visma Software Oy

Mariusz Zieliński
Director of the IT Department
at PGNiG, ORLEN Group

We are very satisfied with the results and can fully recommend Re_Forms21 as a trustworthy partner with the highest level of competences and with an innovative product that stood up to very high expectations.

Olli Suihkonen
Sr. Manager at Visma Software Oy

We recommend Re_Forms21 as reliable and timely suppliers, and the Re_Forms21 technology as a mature and secure tool for quickly transitioning from Oracle Forms & Reports to Java technology.

Mariusz Zieliński
Director of the IT Department
at PGNiG, ORLEN Group

Enhance the efficiency
and security of your Oracle Reports

Learn how migrating reports to modern stack can save money and increase operational efficiency.

What's Included

Automated Oracle Reports migration
to modern Jasper Reports stack with PL/SQL to Java translation:

  • All report triggers.
  • Functions, procedures, packages.
  • PLL libraries.
  • Complete transfer of all SQL statements.
  • Automatic conversion of all major report components.
  • Java code compatible with Oracle Forms applications migrated with Re_Forms21.

Automated PL/SQL to Java translation

Code Example
PACKAGE utils_pkg IS
  FUNCTION is_type_visible(p_type_id VARCHAR2) RETURN BOOLEAN;
END;

-- Utility package
PACKAGE BODY utils_pkg IS
  FUNCTION is_type_visible(p_type_id VARCHAR2) IS
    v_priority INTEGER;
  BEGIN
    SELECT priority INTO v_priority FROM Types
    WHERE type_id = p_type_id;

  RETURN v_priority > 10;
  END;
END;

FUNCTION FTypeFormatTrigger RETURN BOOLEAN IS
BEGIN
  RETURN utils_pkg.is_type_visible(:TYPE_ID);
END;

FUNCTION BeforeReport RETURN BOOLEAN IS
BEGIN
  :CP_GLOBAL := 2;
  -- Initializing user session with Library
  session_utils.init();
END;
@ReportController("EXAMPLE_REPORT")
public class ExampleReport extends BaseScriptlet {
    @Inject CommonLib commonLib;
    @Inject UtilsPkg utils_pkg;

    // Utility package
   @Package
   public class UtilsPkg {
     public boolean is_type_visible(SqlVarchar p_type_id) {
       SqlInteger v_priority;
       sqlSelectInto(
         v_priority,
         "SELECT priority FROM Types WHERE type_id = :1",
         p_type_id);
       return v_priority > 10;
    }
}

@FormatTrigger("F_TYPE")
public boolean fTypeFormatTrigger() {
  return utils_pkg.is_type_visible(getVarchar("TYPE_ID"));
}

@BeforeReport
public void beforeReport() {
  setValue("CP_GLOBAL", 2);

  //Initializing user session with Library
  commonLib.session_utils.init();
 }
}

Start migrating and check pricing

Freely download Re_Forms21® Reports Tool to evaluate reports and estimate prices.
So easy! Stop waiting!

Migration of Oracle Reports object to JasperReports, including:

RDF and PLL transformed to Java and JRXML in multiple stages (extraction, pre-patching, conversion, post-patching, installation).

Oracle Reports vs JasperReports – Preserved structure of migrated reports

Migration of margins and content, elements arranged in appropriate sections.

Oracle Reports vs JasperReports – Preserved structure of migrated reports

Migration of margins and content, elements arranged in appropriate sections.

Why migrate now?

Outdated reports reduce productivity, raise costs and compromise security.
Modernize you reports now to stay competitive. We can do it automatically!

Stop waiting!

How easy it is to work with us

Don't just take our word for it. Before you spend a single dollar, check it out ! Send us your Oracle Reports, and we will automate the migration within 7 days. You will see:

  • What your system looks like in the new technology.
  • That your business logic is 100% preserved.
  • How much time and money you will save on the project.

PoC requirements

A set of sample reports of varying complexity:

  • Report definition in RDF or XML format.
  • All report dependencies (e.g., PLL files).
  • Test values of user parameters.
  • Expected output of reports in PDF format.
  • Database dump or VPN access to test database

To download your analyser, fill out the form:

Thank you for filling out the form!

Freely download Re_Forms21 Reports Tool to evaluate reports and estimate prices. So easy! Stop waiting!