Oracle Reports Reviews

We are doing the POC with Liquibase, but currently we are not in a stage to finalize Liquibase and Flyway. I'm working on evaluations of these products. Based on license pricing and features available in both products, we will determine which product to implement. We have our in-house solution already, so it's quite complicated to determine how to replace that and start using a new solution. Flyway and Liquibase are being considered for CI/CD, not only for version control. I have completed a POC with Liquibase Community edition. Our product is in a transition phase as our company has been acquired by another company. The management will decide how to proceed. Currently, I'm evaluating which product between Liquibase and Flyway would fit better. DBmaestro is too high-level for our needs, where governance is a primary focus. Our current product uses Oracle, but we are planning to migrate to EDB compatible systems. I am working on GoldenGate, not cloud services. We are migrating from Oracle 9i to 19c using Oracle GoldenGate. We have distributed environments with bidirectional replication where patient data should be available to all hospitals. I have worked on Oracle APEX, specifically on migration from Oracle Forms to Oracle APEX. I'm building a strategy for efficient migration with minimal risk and effort, as we have thousands of forms. The current strategy is to migrate to a new tech stack first, then consider additional tech stacks or full migration to architectures using Angular. I'm working on migrating Oracle Reports to JasperReports as part of product modernization. I'm building architecture to replace the Oracle Reports server with JasperReports Community edition, implementing necessary REST APIs. For larger customers, we may consider JasperReports Commercial edition.

Oracle Reports compared to JasperReports is a one-stop solution with consolidated features. The report server and printer integration are all included in one package. When using other reporting technologies, we need to build APIs and change the architecture. Oracle Reports is tightly coupled with the Oracle database, providing benefits such as the ability to write PL/SQL programs within reports and implement business logic. This eliminates the need to write separate business logic on the database side. Compared to JasperReports, where JavaScript implementation is required and PL/SQL work needs to be migrated to the database side, Oracle Reports offers faster development for complex reports due to its integrated nature with the database.

The biggest issue is pricing. Oracle has de-supported Oracle Reports and is promoting BI Publisher, which has a comparatively high licensing price. This has led us to look for alternatives since Oracle has stopped investing in Oracle Reports.

We have been using the solution for a couple of months.

The report installation is quite simple on Windows servers, being a setup-based installation with no complexity. On Linux, we face some challenges with Oracle Middleware, Oracle Forms and reports, but Oracle Reports installation remains straightforward.

Regarding stability, we cannot comment on Jasper as we are in the development phase. We will be able to provide updates once we go live in production.

The solution is scalable as we can add more servers to handle increased load. The main challenge is that costs can increase if performance is low. Compared to Jasper, Oracle Reports may use more resources, possibly due to being legacy software, making it less performance-efficient than Jasper or newer reporting software.

Support from Oracle is really good.

Positive

The report installation is quite simple on Windows servers, being a setup-based installation with no complexity.

From an ROI perspective, while Oracle Reports may have provided value in the past as a legacy product, we currently don't see the ROI due to high licensing costs. This has led us to look for open source solutions such as JasperReports Community edition.

I have been working with Oracle Reports for the past one and a half years, primarily focusing on migration of reports. Oracle has started de-supporting the reports, necessitating migration to JasperReports or other reporting tools. We have evaluated JasperReports as the most viable solution, being commercially less expensive compared to other reporting solutions. We are working on migrating Oracle Reports to JasperReports, building the architecture and approach. Our reports are highly customizable as customers require specific formats. Oracle Reports has comparatively more features for customization. Developers working with the new solution need multiple skills including JavaScript, SQL, and PL/SQL for our complex, customized reports. On a scale of 1-10, I would rate Oracle Reports a 9, noting that Oracle is having difficulty finding report resources.

Hybrid Cloud

Other

As a partner, I use Oracle Reports to develop many reports for my customers, including operational reports, business reports, third-party customer reports, and letters.

It's easy to build an OTBI, and it doesn't take much time to create a report for the customer or business purposes.

We don't have a tool to access the backend read-only. We should get a tool instead of using the BIP, where there are limitations on querying the number of reports. It would be good if Oracle could provide an easy-to-use read-only tool to access the database. Using the BIP model to run a query is time-consuming.

Earlier, we used to have a Toad SQL developer. Whenever you run the BIP data model, you get only 100 to 200 records simultaneously, which you cannot extract without building a report. A flexible tool will help developers look at the data instead of going into BIP, building the report, having a layout, and then creating the report to extract your data.

I have been using Oracle Reports for three to four years.

Oracle Reports is a stable solution.

Around 3,000 to 4,000 people are using Oracle Reports in our organization.

I have not raised any tickets about the reports or the tool, but I have raised tickets for information about specific seeded reports. There is no guidance from customer support, and the engineers route simple queries to Oracle Cloud Connect. It is annoying as it does not solve the purpose of raising a ticket.

There is no initial installation for the solution. You get it along with the instant or the role, and it's very flexible.

I used Oracle Reports on the E-Business Suite and on the Oracle cloud. Oracle Reports is a really good tool. It would be good to have a tool that provides flexibility in extracting or querying the data. Otherwise, Oracle Reports is pretty good for developing the reports.

Oracle Reports has improved our financial reporting and analysis overall. The solution's template design has benefited our reporting.

Overall, I rate the solution a nine out of ten.

The primary use case is for financial  and Health care reporting.

Our financial department has to provide our managers with reports on how the product is doing every month and on a yearly basis

With this solution, we can provide the managerial-level reports to show them the profits, losses, company expenses, and assets.

The features that I like the most are the database design and the BI tools.

The GUI could use some improvement.

The pricing can be reduced and some changes could be made to the interface.

I have been using Oracle Reports for 5 years.

This solution is stable and it is better than other solutions that I have been using.

This solution is scalable.

We have five to six people using it. Some are at the managerial level and others are on the administrative level.

I have not been in touch with technical support, but my manager has. I think that they were helpful.

Previously, I have used solutions by IBM, Cognos, Maxima, Microsoft, and Tableau.

The initial setup was simple, not that complex.

The deployment took two hours.

We have a team of two for deployment and maintenance.

We did not use an integrator or vendor. We followed the instructions and did it ourselves.

sql server

Oracle Reports is a big name in the market. It's good but I have heard that it is costly.

The architectural report is good, this solution is stable, and it's easy to work with.

I would rate this solution an eight out of ten.

Hybrid Cloud

I primarily use this solution for generating reports and presenting them to high-level management.

Oracle Reports allows us to analyze things that are going on in the organization, according to customer requirements, and generate reports. It gives us good visibility.

The most valuables features are the dashboard and the APIs. I use the dashboard to generate reports.

The reports can be customized based on the requirements. It is possible to create reports using both dynamic and static variables.

Depending on which variables are being used in the report, there can be issues related to security.

I have been using Oracle Reports for about one year.

We have had no issues with stability.

Oracle technical support is good.

It takes between five and ten minutes to deploy reports.

Oracle Reports are very easy to create and fast to implement.

I would rate this solution a nine out of ten.

The most valuable feature is that if a user wants a report with whatever information and in whichever format, we can provide it for them. Also, its ability to provide simple calculations is particularly useful.

I really don't like much about Oracle Reports. It's only value, I think, is that it integrates well with our existing Oracle products. The Grid function, which actually draws out the reports, is not good. One little mistake will cause everything to fall apart, and then you have to rebuild from the beginning.

We've had no issues deploying it.

It's stable and it generates a report for you, but we're talking about moving to 11g right now and that's the version that we have issues with.

When you purchase Oracle Forms, you purchase a certain number of licenses, and so it works for a certain number of licenses. We have been able to add additional licenses and users with no problem.

At first, we didn't have a lot of options out there, but now Oracle APEX (Application Express) has come in, and it's really useful as well. We still use Reports but I think we'll be using APEX a lot more.

The initial setup is complex because our network is private.

I think that once we move to APEX, we won't be using Reports anymore.

The most valuable feature for us has been the ability to provide reports to the customer that's tailored to their needs. They can see the exact data that they want by simply giving us their requirements and we'll create the reports from there.

It gives us the capability to track what we have and what the customer's able to see. It lends itself to software configuration management so that we aren't out there creating the same report for two different people. We can use essentially the template of an existing report, and for a completely different application, provide the same capability with a minimum amount of work. 

It's expensive, but I think the quality of the product itself is important to our company. 

Finally, it provides a standardized look and feel to reports, which I like.

I absolutely hate the layout with all the little lines, the different panels, and if you bump the wrong thing just a smidgen, it no longer compiles. You've brought it outside of its area of focus. It says, "We're done here." 

I've looked at a couple of the E-Business Suite reports, and there's no way to fit it all on one screen. When it throws that layout on the screen, you would need a monitor the size of a wall to be able to see everything. It's like using a magnifying glass, and you're seeing only a tiny bit of it. For me, I lose context. That would be the biggest complaint I have there. 

Otherwise, slap this here, and that there, and this here, and you're ready to go. Depending on how detailed the report is, and how much information you're actually putting on there, that leads to the, "Where's this?" It's all kind of a confusing mess, and that would be the biggest problem area for me.

We've had no real issues with deployment.

Everything's been solid. We've had no issues with instability.

It's been scaleable for our needs.

The initial setup was nothing. It was simple and straightforward. It's learning the tool that requires a little more involvement.

Every Oracle product is expensive, and this is no different.

The big issue for me was learning the tool.