Release 12 is designed so that you have decision making information at your fingertips. This provides "Greater Business Insight".
Oracle Daily Business Intelligence (DBI) is a portal with Key Performance Indicators (KPI) and portlets focused on measuring your growth and direction for each of your business and cost center managers. In the Oracle E-Business Suite, there are over sixty dashboards, over 360 KPIs, and approximately 920 portlets.
DBI requires very little setup and delivers information along the major dimensions of your business. It reflects your daily incremental activity and facilitates immediate response bringing the information that you need directly to your staff's browsers. DBI provides continuous updates, usually daily, but as frequently as you require.
Financials Daily Business Intelligence includes dashboards for Profit and Loss managers, Payables Manager, and Receivables Manager. You can personalize and customize DBI to some extent.
More formal fiscally controlled financial reporting is available directly from the General Ledger ledgers and ledger sets using a tool called Financial Statement Generator (FSG). You can use FSG to product financial statements such as Cash Flow Statements, Balance Sheet Statements, and Income Statements.
Use FSG to map accounts to reporting lines and results (such as activity, balances, and budgets) to columns in reports. You can associate FSG reports with individual and multiple ledgers and ledger sets, and you can save the output in several formats including XBRL (eXtensible Business Reporting Language) that can be further processed and published.
XBRL is a language for the electronic communication of business and financial data. It is one of a family of "XML" (Extensible Markup Language) languages that is becoming a standard means of communicating information between businesses and on the internet. XBRL is being developed by an international non-profit consortium of major companies, organizations and government agencies. It is an open standard, free of licence fees. XBRL offers cost savings, greater efficiency, and improved accuracy and reliability to those involved in supplying or using financial data.
Products that are built on the Oracle Enterprise Performance Foundation such as Oracle Enterprise Planning and Budgeting, Oracle Financial Consolidation Hub, Oracle Profitability Manager, and Oracle Transfer Pricing, include their own deeply configurable reporting. The Enterprise Performance Foundation based products share a rich interface with your desktop office applications.
For additional information about these products, refer to the following:
Oracle Enterprise Planning and Budgeting User's Guide
Oracle Financial Consolidation Hub User's Guide
Oracle Profitability Manager User's Guide
Oracle Transfer Pricing User Guide
Oracle Financials provides extensive reporting capability as described in the following sections.
Several thousand reports are shipped with Oracle Financials products.
Oracle Financials includes many standard reports that are designed to support your ability to file statutory, transaction tax (for example, sales tax, Value Added Tax (VAT), and Goods and Service Tax (GST)), and other reports with authorities in over 120 countries around the world.
Many other standard reports are oriented towards reconciling and controlling your data. Examples include receivables aging reports and customer and vendor trial balances.
The Oracle E-Business Suite products are integrated and based on a common data model. Interrelated drill-down reports are efficient and comprehensive, and in many cases, several layers deep.
Oracle Financials provides many reports for specific functional areas. Oracle General Ledger and Oracle Subledger Accounting report on accounting affairs. Oracle Receivables and Oracle Payables report on invoices and payments. Oracle Cash Management provides detailed cash flow reports. Oracle E-Business Tax provides reports specifically for sales and value added tax reporting.
You can run reports from our menu system. Extracts are generated from the database and are then formatted and published. Traditional reports have a unique extract. Newer and revised reports may share extracts and allow formatting to hide data that is not required.
Oracle XML Publisher is a key reporting tool in Release 12. XML Publisher helps users to create formatting templates in desktop products such as Microsoft Word and Microsoft Excel so that non technical and non Information Technology people can do this. XML Publisher also facilitates helps to automatically pair these templates with extracts to produce the ideal report.
You can use XML Publisher to save reports to many different file types including XML, PDF, RTF, and Excel and to publish reports by printing, sending in an e-mail, or posting to web sites or portals. XML Publisher can be applied to both reports and documents.
Release 12 includes new common extracts and XML Publisher templates for many standard reports. Certain standard reports retain their previous unique extracts and formatting.
Tip for Existing Oracle Financials Users
In Release 12, standard reports are migrating to XML Publisher. Approximately 20 extracts support 400 reports. Other standard reports are supported as before.
Other important reporting tools include the Desktop Integrators. Desktop Integration provides support for creating and summarizing both input and output data in two-dimensional spreadsheets. Desktop Integration is provided by most products in appropriate circumstances.
The RXi Reports Administration Tool allows you to design the content and layout of your RXi reports. You can print the same report using different layouts, and you can control the data items included in your report. RXi lets you tailor your reports to meet statutory and other reporting requirements, and to create reports for your own internal use.
Your staff can create and run SQL extracts to obtain additional information from the database.
Oracle Discoverer is a business intelligence tool for analyzing data. Users can access and analyze data in a company's database without having to understand difficult database concepts. Users can also view workbooks and integrate database output onto a web site and portal that can be easily customized to conform to a particular web site look and feel, or to build custom Discoverer applications for the web.
You can use Oracle Portal to create a portal Web interface, publish and manage information, access dynamic data, and customize the portal experience. You can design enterprise portals that are the single entry point to business applications, content, collaborative tools, and Web sites.
For the most part, access and security to reports of all kinds follows the access and security that are associated with the system representation of your organization and the process involved. Where appropriate, reporting security extends this model. For example, a reporter working on the receivables balance needs to know the full receivable, even if the reporter doesn't have access to each invoice.
In general, reporting respects your organization as you have modeled it in the system. For example, reports associated with a ledger will be limited to that ledger. Reports associated with a ledger set will include all ledgers in the ledger set.
Subledger reports are generally defined by the operating unit with which they are reported. For example, reports for the Italian operating until will include data for Italy only. In specific cases, reports can run across subledgers. Certain Daily Business Intelligence (DBI) reports are secured by operating unit, and are Multiple Organizations enabled. You can access data for either a subset of the operating unit or all of the operating units, depending on the setup.
For example, if Joe is a Payables Manager for North America, the DBI Payables page can be set up to give Joe summary information across the United States and Canada only, while Joe's boss Mary can be set up to have access to information across all operating units.
Other product specific reports are also designed to run across operating units.
As the data in operating units can be defined specifically for that operating unit (for example, the operating unit may define transactions in different currencies) users must be careful that the aggregated report includes similar data. For example, the report should not add values in USD currency from a United States operating unit to values in CAD currency from a Canadian operating unit.