Back to Re_forms 21

Discover how to migrate Oracle Reports quickly and efficiently

Automated Migration of Oracle Reports to Java

Automate the migration of reports from Oracle Forms & Reports to a modern Java platform, preserving the logic and functionality of your reports.

learn more

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.

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.

Benefits of migrating

Oracle Reports to Java JasperReports using Re_Forms21.

Multiple Automation Options

Achieve 80% to 100% automation with minimal manual corrections.

High Automation Levels

Achieve 95-100% automation for standard reports.

Faster Migration

Migrate standard reports 10 times faster compared to manual rewriting.

Cost Reduction

Reduce migration costs by up to 6 times.

Error Reduction

Nearly 100% reduction in the risk of errors due to high automation levels.

Zero Downtime

Ensure uninterrupted reporting during migration.

Better Code Quality

Improve code quality and ease of maintenance.

Flexible Approach

Adapt to different cooperation models and customer needs.

Preserve Report Logic

Maintain the logic and design of your reports.

Increased Efficiency

Speed up the reporting process significantly.

What are your additional benefits?

Business and technological benefits of using Re_Forms21.

Automatic or Semi-Automatic Migration

Standard reports

Complex reports

Standard Reports (95-100% automation)

Different text width.

Subtle changes in text formatting.

Leading zeros in numeric values.

Complex Reports (80-95% automation)

Empty values for out-of-context summaries.

Scaled or truncated texts.

Overlapping frames.

Unexpected vertical space.

Different page breaks.

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 you in fine-tuning your reports.

Turnkey report migration:

We migrate and tune reports for you.

You get reports that are 100% ready to use.

Have a look at our customers’ stories

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.

What will we provide you

Automated and Semi-automated Oracle Reports migration to modern tech stacks.

PL/SQL to Java translation, including:

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

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();
  } 
}

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.

Automated linked queries migration

Queries are represented by datasets.

Linked queries get separate datasets in embedded lists.

Check out DEMO

See how Re_Forms21 can transform your reports.

Additional Bonuses 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.

How easy it is to work with us

PoC requirements

A small 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

What our clients say

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.

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

We know how to help

Re_Forms21 is an origin company from 7bulls.com Group, with over 200 programming professionals. We have specialized in Oracle Forms & Reports migration for over 8 years and are an Oracle partner since 2018. You can completely count on us!

million

lines of code migrated.

20,000+

objects handled.

continents we operate in.