Oracle Discoverer: A Reporting and Decision Support Tool for Oracle E-Business Suite

Oracle Applications, Oracle E-Business Suite, Oracle Financials, Oracle Reports, Oracle Discoverer

Oracle Discoverer is a business intelligence tool to support organizational decisions. It uses a repository called EUL (End User Layer) which is based on information stored and controlled by transactional applications. The main EUL goal is to hide details and complexity of a transactional database, organizing data to reflect the company specific business areas, making all data queries faster and easier.

Oracle E-Business Suite (EBS - also known as Oracle Applications and sometimes called Oracle Financials) has a BI module with an EUL mapped from Oracle EBS transactional data, which permits Oracle Discoverer to be used as a decision support tool for information stored into Oracle EBS database.

By using Oracle EBS security schema, which uses responsibilities to control access rights, Oracle Discoverer shows its repository in a user friendly way, using folders for each business area, listing all items that you can select for a query.

When you select an item for a query, all items that don