Oracle Reports 6i

[Adriana Gowen]

OracleReports is Oracle's award-winning, high-fidelity enterprise reporting tool. It enables businesses to give immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment.

Using Oracle Reports, you can rapidly develop and deploy sophisticated Web and paper reports against any data source (including an Oracle database, JDBC, XML, and text files). Leveraging Java EE technologies such as JSP and XML, you can publish your reports in a variety of formats (including HTML, XML, PDF, Enhanced Spreadsheet, Spreadsheetdata, delimited text, delimiteddata, PostScript, and RTF) to any destination (including e-mail, Web browser, WebDav, FTP, Oracle Portal, and file system) in a scalable, efficient manner.

Oracle Reports Services is the focus of this manual. It executes, distributes, and publishes your reports for enterprise wide reporting. Using Oracle Reports Services to deploy your reports results in gains of flexibility, time savings, and processing capacity. It includes the following components:

As its name implies, Oracle Reports Builder (rwbuilder) is the report-building component of Oracle Reports. Report developers use the Oracle Reports Builder design-time user interface to create and maintain report definitions, using:

rwrun (Reports Runtime) runs a report by starting its own in-process server (not to be confused with the default in-process Reports Server), which runs in the same JVM as the rwrun process. The configuration file for this in-process server is rwbuilder.conf and trace files are saved in the rep_machinename-rwbuilder directory.

Oracle Reports Servlet (rwservlet) is a component of Oracle Reports Services that translates and delivers information between either a Web Server or a Java EE Container (for example, Oracle WebLogic Server) and the Reports Server, enabling you to run a report dynamically from your Web browser.

Oracle Reports Server (rwserver) is a component of Oracle Fusion Middleware that provides reporting services to execute, distribute, and publish your reports for enterprise-wide reporting. This component processes client requests, including user authentication, scheduling, caching, and report distribution. Use Oracle Reports clients such as Oracle Reports Servlet (rwservlet), Reports JSP, and Oracle Reports Client (rwclient) to send a report to Oracle Reports Server (generally referred to as Reports Server).

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).

Viewed 1000+ timesYou Asked I have been working with the Oracle Database for several years now, but have recently taken a position with a company implementing Oracle Financials. As part of the implementation, a mandate has been made to minimize customizations (no new forms), but report enhancement is necessary.

I took the course on Oracle Reports Developer, and now I'd like to start working on report customization. I've spent the last couple weeks sifting through documentation, and to my knowledge I have been unable to find anywhere where oracle talks about modifying existing reports when your Apps server is on a different platform from your desktops.

Basically, I need to take the report executable from a UNIX box, and transfer it along with any attached libraries to my developer environment (Windows NT 4.0). How do I go about doing this? Correct me if I am wrong, but if I just use FTP, I have a problem with differet compiled versions (Unix as opposed to NT). I see the same problem arising if I create a new report for use with Oracle Apps.

Can you point me in the direction of how to proceed, or to documentation that I may have missed that would be of use?

Thanks a million!

Rory Monteith

Programmer

and Tom said...In reports, the .rdf files may be transferred between platforms. The compiled version of the reports are .rep files. Reports can run directly off of the rdf files as well as the compiled rep files. For the libraries, you need the .pll files to move across platforms.

Make sure to issue "BIN" in ftp !

Rating (10 ratings)

Is this answer out of date? If it is, please let us know via a Comment Comments Comment Anyother Method to Create a RDF file programmatticallyKamini, August 31, 2002 - 4:33 am UTC

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account. More to Explore Live SQLShare and learn SQL and PL/SQL; free access to the latest version of Oracle Database!

Oracle Reports, a component of Oracle Fusion Middleware is Oracle's award-winning, high-fidelity enterprise reporting tool. It enables businesses to provide instant access to information to all levels within and outside of the organization in a scalable and secure environment. Oracle Reports consists of Oracle Reports Developer - a powerful, declarative WYSIWYG reports design tool and a JEE 5 based Oracle Reports Server with multi-tier architecture to access any data sources, generate reports in any popular format for web and paper, and to burst and distribute reports to any destination. Oracle remains committed to the development of this technology, and to the ongoing release as a component of the Oracle Fusion Middleware platform.

On this page, you can access the latest documentation set for Oracle Reports, as well as documentation for prior releases. For the complete Oracle Application Server documentation library, refer to the Oracle Application Server Documentation page.

As oracle has announced Oracle fusion middleware statement of directions and it has oracle forms and reports. I know oracle BI publisher is recommended product to replace oracle reports. but my question is about to inquire more about oracle reports inclusion in Forms 14. please advice or suggest , will oracle reports product shipped with Oracle forms 14c ? will we able to configure oracle reports in Forms14c?

Basically I'm setting up a test server for 12c in preparation for migrating an existing forms/reports application written in 11g. Oracle 12c is installed and forms is running. I have recompiled a couple of forms and confirmed that it works in 12c. So the forms portion is working. Now the problem lies with the report server. In 11g, we've never used the in-process reports server but always setup a standalone server. This is what I'm trying to do in 12c.

[2018-11-26T11:21:44.741-08:00] [reports] [INCIDENT_ERROR] [REP-51002] [oracle.reports.zrclient] [tid: 1] [ecid: aec467bb-f1be-4107-a216-8bcf678c52c8-00000002,0] REP-51002 : Bind to Reports Server rep_server1 failed. [[

I did a search on the INFO: jsp startup failed and it had something to do with security. Specifically, the jps-config.xml and the jps-config-jse.xml. I checked both files and the database host connect parameters look fine.

But are there any other alternatives out for Oracle Forms customers? In this blog, as part of our Oracle Reports series, we give an overview of the some of the most popular solutions when it comes to Oracle Reports alternatives.

As early as October 2016, Oracle announced that Oracle Fusion Middleware 12.2.1.3.0 was the last report release. In addition, they revealed that Oracle Reports support would fully retire in 2023. Enterprise applications based on the Oracle Fusion middleware stack, which includes Oracle Forms and Reports, are therefore faced with a big problem. They need to immediately plan their new reporting strategy. But what Reports alternatives are currently on the market and what are their benefits?

The second main reason for Jasper is, that it is written in Java, which is widely used. JasperReports can handle various data source options: JDBC, Hibernate, XML, EJB, POJO. While there are many data sources possible, there are loads of export formats available: PDF, HTML, XLS, RTF, ODT, XML, CSV, TXT, DOCX.

JasperReports from TIBCO is probably the Java based open source solution with the widest community. Similar to BIRT, reports development takes place in the Eclipse IDE and at runtime, the engine can be integrated into any Java application. In contrast to BIRT, Jasper can also be consumed via a scheduler or web services. That Oracle Forms integration very flexible and diverse.

The possibility of integrating JasperReports via WebServices and URL calls also makes the tool interesting outside of pure Java application development. Pixel-perfect printing also allows safe use for classic tasks such as labels, barcodes and forms. If it is the first step in the Java world, the learning curve should not be underestimated like in BIRT.

While using Jasper Reports has some benefits it comes with some negative aspects and problems when you are moving from Oracle Reports. The biggest problem for most Oracle Reports developers will be the fact, that Jasper is not supporting PL/SQL. So if there is a lot of logic or validation in your reports we recommend to move the PL/SQL Code to the database and refactor the validation within Java.

Another problem could be, that you need Java knowledge to utilize JasperReports: If you already have Java knowledge in your company your Java developers will find it easier to work with JasperReports, but if your developers are pure PL/SQL developers Java training to a certain extend is not a bad idea. Also Java resources are quite common (Java is still the most famous programming language).

This changes the flow of work when it comes to the creation of a report. The advantage is, that reports that use the same data source but have a different layout must not be created multiple times. For creating these different layout-templates the development environment or a Microsoft Word Add-in can be utilized. An additional advantage of BI Publisher compared to Reports is that BI Publisher supports many sources and export formats.

3a8082e126