ECC report generation in Oracle EBS tutorial
This video provides instructions for rapid report development using standardized Oracle ECC SQL queries that generate Excel reports, in realtime from EBS. These can be attached to any EBS form using the 'Zoom' toolbar option to replace the slow and inconvenient CSV export function.
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.
Reports available
There are over 220 Oracle ECC reports including core process areas such as Service Contracts, Leasing, Projects, Order Management, Inventory, OPM, Costing, Sub Ledger details, Payables, Receivables, iProc, and Supply Chain to name a few. All of these can be imported in less than 2 minutes, ready for business users to schedule and run in EBS with perfectly formatted Excel output. A full overview of ECC SQL Reports as used in the dashboard is available from our home page - https://www.enginatics.com/wp-content....
