How to develop proven EBS reports using Oracle Enterprise Command Center SQL’s in under 5 minutes
Introduction
Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Oracle E-Business Suite Dashboards are provided for functional areas such as General Ledger, Receivables, Payables, Project Accounting, Service Contracts, and Supply Chain modules.
This article provides instructions for rapid report development using standardized Oracle ECC SQL queries within EBS.
Benefits
This method enables rapid report development using the same queries used by the ECC dashboards. Since these have been tested and approved by Oracle the output is assured. Users of Blitz Report can download the dashboard data to Excel using the standard Oracle concurrent request framework overcoming the CSV file type reports used when exporting data from ECC. There are no data limits with Blitz Report imported ECC report queries.
Further articles
For information on extending Enterprise Command Centers to address additional requirements specific to your implementation refer to Oracle E-Business Suite Extending Oracle Enterprise Command Centers.
For upgrading from v3/v4 to v5 of ECC you can follow our upgrade blog
Note: Oracle Enterprise Command Center Framework is available for Oracle E-Business Suite from version 12.2.4 or higher. This document is based on version 5 of ECC. You can access our demonstration instance with ECC dashboards here.
Pre-requisites
EBS version 12.2.4 or higher to allow ECC dashboards to be installed
Download the trial version of Blitz Report
Try for yourself on our demonstration platform