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.