Reporting Oracle E-Business Suite - Overview for Developer

Oracle Reports, Oracle Discoverer, Oracle XML Publisher, RXi Report, FSG Reports, Business Intelligence System

In this article we are going to show some tools that can be used to develop reports to Oracle e-Business Suite. Most of organizations that have installed Oracle Applications have their data base systems with a lot of data about their business. However their data is trapped inside the database, being very difficult to find it and to convert into valuable information, very important to make decisions to run the business.

Knowing all the problems regarding reporting, Oracle has a number of offerings helping organizations to solve the reporting needs they have. Some of these tools are part of Oracle E-Business 11i and others are Oracle products that access the data stored in Oracle Applications database.

The most common reporting tools for Oracle Applications are:

o Oracle Reports: the fixed format reports delivered with the 11i release were built on this tool. Nowadays, this is the most used tool for reporting on Oracle Applications. Most of reports customizations are built with this tool.

o Oracle Discoverer: is an intuitive tool for creating reports and performing on-line analysis. Discoverer uses the EUL (End User Layer), a metadata definition, which hides the complexity of the database from the end user and provides easy to use wizards for creating reports to suite individual needs.

o Oracle XML Publisher: is a new Oracle tool for reporting. It enables users to utilize a familiar desktop tool, like MS Word or MS Excel, to create and maintain their own report. At runtime, XML Publisher merges the custom templates with the concurrent request extracts data to generate output in PDF, HTML, RTF and EXCEL.

o RXi Report: (Variable reports) - variable format reports delivered with the E-Business 11i. With this tool a user have the ability to print the same report with multiple layouts. This tool is most used on Oracle Financials Applications.

o FSG Reports (Financial Statement Generator): is a powerful report building tool for Oracle General Ledger. Some of benefits of using this tool are that a user can generate financial reports, generate presentation quality, design custom financial reports and schedule reports to run automatically.

o Business Intelligence System (BI): is a set of tools

to provide high level information for the managers (decision makers) to run their business. The information this tool provides helps managers to take the right decision with the daily data that is upload on their systOracle Reports, Oracle Discoverer, Oracle XML Publisher, RXi Report, FSG Reports, Business Intelligence System

In this article we are going to show some tools that can be used to develop reports to Oracle e-Business Suite. Most of organizations that have installed Oracle Applications have their data base systems with a lot of data about their business. However their data is trapped inside the database, being very difficult to find it and to convert into valuable information, very important to make decisions to run the business.

Knowing all the problems regarding reporting, Oracle has a number of offerings helping organizations to solve the reporting needs they have. Some of these tools are part of Oracle E-Business 11i and others are Oracle products that access the data stored in Oracle Applications database.

The most common reporting tools for Oracle Applications are:

o Oracle Reports: the fixed format reports delivered with the 11i release were built on this tool. Nowadays, this is the most used tool for reporting on Oracle Applications. Most of reports customizations are built with this tool.

o Oracle Discoverer: is an intuitive tool for creating reports and performing on-line analysis. Discoverer uses the EUL (End User Layer), a metadata definition, which hides the complexity of the database from the end user and provides easy to use wizards for creating reports to suite individual needs.

o Oracle XML Publisher: is a new Oracle tool for reporting. It enables users to utilize a familiar desktop tool, like MS Word or MS Excel, to create and maintain their own report. At runtime, XML Publisher merges the custom templates with the concurrent request extracts data to generate output in PDF, HTML, RTF and EXCEL.

o RXi Report: (Variable reports) - variable format reports delivered with the E-Business 11i. With this tool a user have the ability to print the same report with multiple layouts. This tool is most used on Oracle Financials Applications.

o FSG Reports (Financial Statement Generator): is a powerful report building tool for Oracle General Ledger. Some of benefits of using this tool are that a user can generate financial reports, generate presentation quality, design custom financial reports and schedule reports to run automatically.

o Business Intelligence System (BI): is a set of tools to provide high level information for the managers (decision makers) to run their business. The information this tool provides helps managers to take the right decision with the daily data that is upload on their systems.

Every organization is unique and the standard reports delivered with Oracle Applications are never going to meet all the requirements in every organization. Customizing reports is a must on all Oracle e-Business implementation and our company "Alba Spectrum" can help you in this task.

Give us a call 1-866-528-0577 or [email protected] if you need additional information or directions.

Author is technical consultant at Alba Spectrum Technologies ( serving clients in Illinois, California, Texas, New York, Florida, Louisiana, Georgia, New Jersey, Washington, Pennsylvania, Ohio, Michigan, Wisconsin, Arizona, Nevada, and having locations in Brazil, Colombia, Chile, Argentina, Germany, Mexicoems.

Every organization is unique and the standard reports delivered with Oracle Applications are never going to meet all the requirements in every organization. Customizing reports is a must on all Oracle e-Business implementation and our company "Alba Spectrum" can help you in this task.

Give us a call 1-866-528-0577 or [email protected] if you need additional information or directions.

Author is technical consultant at Alba Spectrum Technologies ( serving clients in Illinois, California, Texas, New York, Florida, Louisiana, Georgia, New Jersey, Washington, Pennsylvania, Ohio, Michigan, Wisconsin, Arizona, Nevada, and having locations in Brazil, Colombia, Chile, Argentina, Germany, Mexico