Types of Reports

These are the various types of reports available in oracle applications. According to the client requirement we can use them:

Objects:

            We have mainly two types of objects

1.      Custom Objects:

           Developing  a new objects as per business requirements called as custom objects

 Eg: Developing a Reports, Forms etc…

2.      Customization of Objects:

           Modifying the existing objects as per client requirements called as customization objects

Eg: Modifying Reports, Forms, Workflow etc…

Reports:

            A production reporting tool to dynamically retrieve, format and distribute database information.

Reports are of three types they are

1.      .rdf  Reports

2.      Pl/Sql Reports

3.      SQL*Plus Reports

Question: When to use RDF, when to use PL/SQL procedure and when to use SQL*Plus ?

RDF Reports:

            If we have more than one group in the document then we can go to RDF Report method.

PL/SQL Reports:

            If we have only group it is better to do in PL/SQL procedure because it makes the query easy, Database will work fast etc.. If we have more than one group then we can go for pl/sql but it will take more time we can go for pl/sql but it will take more time to generate the output. So, it’s better to go for RDF method only.

SQL*Plus Reports:

            SQL*Plus is a formatting reporting tool which will convert SQL query output into formatted output as per client requirement we should use SQL*Plus commands for developing.


Note:

·         If client required fully formatted output we go for the RDF report

·         If client required plain output then we go for PL/SQL output

·         If client requires plain data with same format then we go for sql*plus.